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





3 COMMENTS

  1. Another option to activate any sheet (if sheet tabs are not turned off) is to right click on the sheets navigation arrows in the area to the left from the sheet tabs and select needed sheet name in the launched Activate dialog box.
    The method you described is very useful in client facing Excel applications when “Show sheet tabs” option is unchecked. This way I restrict the end user to navigate only by hyperlinks provided.
    To create back hyperlink I’d select all sheets and entered once for all something like =HYPERLINK(“#Summary!A1″,”Back”)

    • Hi Leonid, thanks for the comment. I didn’t know you could do this. What a cool technique. However, only issue with right clicking on the tab arrows is that you are limited to 15 tabs. So (as in my case) there are too many too see on this list without going to the next window to look at all tabs. Thanks again. Great tip. Steve=True

LEAVE A REPLY

Please enter your comment!
Please enter your name here