Creating a Table of Content Page for a Workbook
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!
Have your say about what you just read! Leave me a comment in the box below.
Share this page:
Enjoy this page? Please pay it forward. Here’s how…
Would you prefer to share this page with others by linking to it?
- Click on the HTML link code below.
- Copy and paste it, adding a note of your own, into your blog, a Web page, forums, a blog comment, your Facebook account, or anywhere that someone would find this page valuable.
<a href=”https://www.advanced-excel.com/”>Advanced Excel – From a Business Perspective</a><a href=”https://www.advanced-excel.com/”>Advanced Excel – From a Business Perspective</a>
Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation.
advanced-excel.com is in no way associated with Microsoft