Question: I have a huge workbook. 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 2007:

  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)

Share and Enjoy:
  • Share/Bookmark

Related posts:

  1. Quickly select a range of values in excel
  2. Stock alerts in excel
  3. Scan stock markets in excel
  4. Create a unique distinct list of a long list without sacrificing performance using vba in excel
  5. Sort values in parallel (array formula)
  6. Filter unique distinct values using “contain” condition of a column in excel