Author: Oscar Cronquist Article last updated on August 16, 2018

Question: I have a workbook containing a lot of worksheets and data. I need a way to find certain data/sheets quickly. How can I do this?

Answer: Create a table of contents and use hyperlinks to move around in a large complex workbook.

Here is how to do this in Excel:

  1. On your front sheet create a list with important workbook sheets you often visit
    table-of-contents.png
  2. Right click on January and select Hyperlink...
  3. Click "Link to: A place in this document"
    table-of-contents_1.png
  4. Type cell reference. You can link to the same sheet as many times as you want. But by using a cell reference you can link to a certain place in that sheet, creating a more sophisticated navigation system.
  5. Click OK!
    table-of-contents_2.png
  6. Try clicking on January. Now can find important places in a workbook really quick!
  7. Repeat with remaining sheets.

Download excel sample file for this tutorial.
table-of-contents.xls (Excel 97-2003 Workbook *.xls)

Related articles