Have you ever wondered why in Microsoft Excel there is only an horizontal sheet tabs option to scroll and navigate through Excel Worksheets?
This becomes somewhat slow and cumbersome if you have a large Excel Workbook that contains 10 or more sheets, especially when the tab names are long. Excel Sheet Tab names can be up to 31 characters long. Having such long sheet tab names result in by default that you only see about 4 sheet tabs at a time that you can easily click on to navigate to those sheet tabs.
Even in displaying only the 4 sheet tabs in the example above, you can by default not even see the complete tab name of the last visible tab to the right.
Now of course if you are familiar with Excel and Excel Sheet Tabs you can make the horizontal scrollbar narrower by dragging the resizer (directly to the right of the (+)) to the right. Now you may see perhaps 7 sheet tabs and the last one again my not be fully readable.
This is then when if you need to find another sheet tab to the right or left of the sheet tabs that are currently shown, you will typically click on the small triangles pointing left and right in the bottom left corner.
Now some advanced users may know that you can also right-click on those small left and right triangles and from there select that sheet that you wish to navigate to and open.
Considering all the steps and mouse clicks involved, would it not be nice if there was an easier and quicker way to easily and quickly navigate between multiple sheet tabs and see more or all the sheet tabs without having to scroll left, or right?
Well there is an easier way, if you have vertical sheet tabs then those vertical tabs can show many more sheet tabs without the need to scroll. And if you have more than about 30 vertical tabs then a standard up and down scroll bar makes it a breeze to navigate to the end or the start of the list of sheets.
Check out this 2-minute video on how this Excel Vertical Tabs Add-in works:
To enable the Excel Vertical Sheet Tabs in Excel 2000 or later on Windows PC’s, simply download this free Excel Add-in called KuduXLNavigator below by clicking on this link.
Please support my YouTube Channel by clicking the button below… I would really appreciate that.
Subscribe to my mailing list today and you will receive actionable and practical Excel how-to information and receive email notifications whenever I publish a new video on my youtube channel.