Have you ever tried creating a table of content page for your Excel workbook? Many people think content page is only needed when writing a report but never thought an Excel workbook may also require one. Adding a content page to your workbook will greatly improve the user experience and makes your work looks more professional. Now let's take a look at how we can do that to make you look smarter.
Very often, you will have a workbook contains multiple worksheets e.g. one worksheet for each month's data. In order to create a content page, follow the steps below:
1. Creating a new worksheet and rename it as "Content Page"
2. In cell A1(or anywhere of your preference) , type in "Table of Contents".
3. Below your TOC, key in your worksheet names, e.g Jan, Feb, one row for each worksheet, or choose any arrangement you like.
4. Move to "Jan", press "Ctrl + K", the shortcut to call out the "Edit Hyperlink" function. ALTernatively, you can right click on the cell and choose "Hyperlink" located at the end of the pop-up menu.
5. In the pop up window, under the "Link to" box, choose "Place in This Document", then choose "Jan" under "Or select a place in this document". Click "OK".
6. Now you have linked the cell to worksheet "Jan" and you will be navigated to the "Jan" tab when you click on the cell,"Jan" (which will be underlined and colored).
7. Do the same for the rest of the cell and link them to the respective worksheets.
8. If you wish, you can add a "back to content page" in each worksheet to allow the user the quickly go back and forth between worksheets and the TOC page.
9. Add a background color/picture to your page to complete the page.
And that's it. You have just created a simple content page for your workbook and made it fully navigable between worksheets. Start doing it for your Excel reports right now!
Share this page:
Would you prefer to share this page with others by linking to it?
Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation.
advanced-excel.com is in no way associated with Microsoft