Excel tutorials

Sometimes, having a lot of sheets in Excel can be overwhelming. It’s beneficial to have a table of contents on the first sheet.

The picture below shows what we want to achieve.

To create a table of contents follow the steps below:

• The first sheet will hold our table of contents.
• Create some more sheets and enter some random data.
• On the first sheet select cell A2
• Right-click and select “Link“

• A new window shows up, here we will select the sheet that the link will point to.
• Change the show name at the top if you want.
• Repeat the above steps for the rest of the sheets.
• Returning to our first sheet, when we click the links, we will be directed to the actual sheet.

This is a good way to navigate a workbook with many sheets.