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. How to create excel macro to color every second row
  3. Stock alerts in excel
  4. Insert a new row at the top every time a value has been entered
  5. How to automatically fill all blanks with missing data or formula
  6. Scan stock markets in excel
  7. Create a unique distinct list of a long list without sacrificing performance using vba in excel
  8. Color every second row using dynamic conditional formatting in excel
  9. Sort values in parallel (array formula)
  10. Filter unique distinct values using “contain” condition of a column in excel