How-to Quickly Find and Jump to the Right Worksheet Tab in Your Excel Workbook

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.

image

2) Create a Hyperlink from the worksheet name to cell A1 of the desired worksheet.

Click on the Tab Text in the Summary Worksheet, then click on the Insert Ribbon and then click on the Hyperlink button in the Links control group:image

Then click on the “Places in this Document” in the Link to area and type in A1 in the Type the Cell Reference field and choose the destination Worksheet: image

 

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:image

Then click on the “Places in this Document” in the Link to area and type in A1 in the Type the Cell Reference field and choose the Tab Summary Worksheet: image

Now you can easily find and jump between all of your worksheet tabs in the complex work book.

 

Video Demonstration

Video Update (Part 2):

 

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.

 

Steve=True