How to Create a Table of Contents in Excel 2010

6 Flares 6 Flares ×

Often, when you work with Excel, you tend to use a number of worksheets so that data related to a particular project stays in one workbook. Soon, you find yourself having ten to fifteen worksheets and struggling to find data from among those several sheets. One quick way to solve this problem is to create a table of contents using hyperlinks. In this tutorial, I’ll show you how to create a table of contents in Excel 2010.

How to Create a Table of Contents in Excel 2010

To create a table of contents in Excel:

1. If your Excel sheet already contains data, insert a fresh sheet. Right-click the first Sheet tab in your workbook and choose Insert. In the Insert dialog box, select Worksheet and click OK. A new sheet titled Sheet 1 is inserted.

insert dialog box

2. Press Ctrl+K. The Insert Hyperlink dialog box is displayed.

3. In the dialog box, in the Link to section, select Place in this Document.

4. In the list box that displays the text Cell Reference, select the worksheet you want to link to.

5. At the top of the dialog box, in the Text To Display text box, observe that the sheet name is displayed along with a reference to cell A1. Delete characters before and after the page name so that only the sheet name shows up in the Table of Contents.

6. Click OK.

insert hyperlink dialog box - Create a Table of Contents

7. In Sheet 1, place the cursor in cell A2, and repeat steps 2 to 5 to add a hyperlink for the next sheet. Continue this for each of the remaining sheets.

8. Select the View tab. In the Show group, uncheck the Gridlines and Headings checkboxes to turn them off.

9. You can also remove the underline from the hyperlinks. Select Column A and then, on the Home tab, in the Font group, click Underline.

Table of Contents

That’s it. You now have a quick reference sheet a.k.a a table of contents to help you quickly navigate to any sheet you want to.

There’s also a quick shortcut to navigate to various sheets if you don’t want to create a table of contents. Just right-click the scroll buttons to the left of the Sheet tab and you can select the worksheet you want to navigate to.

right-click navigation

I hope this tutorial has helped you make your navigation quicker in Excel 2010.

Follow us on Twitter or join our Facebook fan page to get the latest tutorials, updates and how-to articles on Microsoft, Google and Apple products.