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
  2. Press with right mouse button on on January and select Hyperlink...
  3. Press with left mouse button on "Link to: A place in this document"
  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. Press with left mouse button on OK!
  6. Try press with left mouse button oning on January. Now can find important places in a workbook really quick!
  7. Repeat with remaining sheets.

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