This article shows how to reach other tabs in a workbook quickly when you have lots of them. Apart from simple “CTRL+PageUP/Pagedown” option, it talks about other alternate solutions like “Excel’s activate sheet option” and “Insert hyperlink” which are less time consuming and more efficient ways to navigate comfortably between worksheets.

If you have lots of tabs and you would like to go from one tab to another then doing ctrl+  pageup/pagedown would turn out to be quite a slow process.
There are following two ways that we can use to navigate between tabs:

1) Activate Sheet option
If you do right click on the extreme left corner, a window will pop up with a list of all the tabs currently in the workbook.

Simply click on the worksheet name that you want to visit.

2) Insert hyperlink
You can add one tab like “Tablist” at the beginning of the workbook and run a simple macro to get the names of all the worksheets.
Here is the link to “Worksheets name” macro:

List of all tabs in a workbook

Once you have the list of all the worksheets, you can create links to all the internal worksheets using “Insert hyperlink” option. Press Ctrl+K, and click on the “place in this document” button and this will give the list of all the tabs that are currenlty there in the workbook. Start from the first tab on your list, just select the same name from the hyperlink list and click on it. Once you do that, you will see that tab will turn into blue with a underline and if you move your cursor over it, you will notice it will show a link sign. If you click on it, it will take you to the relevant tab.

Although this is a time consuming method but it’s a one-time process and also a neater way to show worksheet names with the links to their respective location.
Also, if there are several users of this spreadsheet then some of them might not even be familiar with the first option and will find the second option much easier to use especially with a readymade list and links to the tabs.

Popularity: 17%