As Excel users, we may create a spreadsheet with many many many worksheets (tabs at the bottom) within the workbook. However, if you create more tabs than you can see on the bottom of the spreadsheet, it can become too difficult to navigate in between the tabs.
In my current project, I have a spreadsheet with over 40 worksheets in one workbook. To find an update one worksheet tab in the workbook can very time consuming.
So how can you make that easier? Simply follow these simple steps. Check it out in action in the quick video file below:
1) Create a tab summary worksheet in the workbook that has all the worksheet names in the top left most columns.
2) Create a Hyperlink from the worksheet name to cell A1 of the desired worksheet.
3) On the desired worksheet, create a return hyperlink to the tab summary worksheet.
Click on the top left cell that contains text, then click on the Insert Ribbon and then click on the Hyperlink button in the Links control group:
Now you can easily find and jump between all of your worksheet tabs in the complex work book.
What other quick tips do you have like this one that makes you super efficient while using Microsoft Excel? Let me know in the comments below.