How to create an automated list of worksheet names in Excel -- and add a table of contents.

Click the "OK" button to create the drop-down list for the selected cell or group of cells on the worksheet, or "Sheet2." Save the workbook. Hover over a cell to reveal the drop-down list box.

Sometimes a formula precedent is in another worksheet. Tracking to a different worksheet requires that you learn how the Trace Precedents tool works.

Working with ranges in Excel can speed up your formulas and macros, or help you navigate through your spreadsheets. It’s also a more efficient way to manage processes within your worksheets ...