Sometimes workbooks can be very large and hard to navigate. Only so many tabs fit across the bottom of the screen, and it’s hard to know how long each worksheet is. Excel doesn’t have a built-in way to add a table of contents to a workbook; however, there is a way! In this post, I’ll show you how to add a new worksheet to the beginning of your workbook called “TOC” (table of contents). This example uses Excel 2010. On the TOC sheet, Column A lists each sheet name and includes a hyperlink shortcut
Read More...
Read the complete post at http://blogs.office.com/b/microsoft-excel/archive/2011/01/13/add-a-table-of-contents-to-your-workbook-it-s-easy-i-promise.aspx
Posted
Jan 13 2011, 03:00 AM
by
Microsoft Excel