Excel Tips and Tricks Archives - KuduTek.com

Category Archives for "Excel Tips and Tricks"

How to get Excel Vertical Sheet Tabs

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.

excel sheet tab

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.

excel horizontal scroll bar

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.

excel sheets left right

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.

excel available sheets

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.

Excel Vertical Tabs

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.

Don’t Forget…

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.

Check Out My Latest Posts

How to adjust multiple column width or row height in Excel

How to quickly adjust multiple column width or row height in Excel

Have you ever spent endless time adjusting and re-adjusting the column width in Excel to show all the content of columns? Or perhaps you had to make all the columns and rows the same even width and height for a uniform appearance of some important report that you have been working on?

Well, Excel has built-in features that make this a snap and you should always use Excel in an ergonomic way to save you precious time. Here is a quick 4-minute video to show you how to do this in Excel quickly and hassle free:

Please support my YouTube Channel by clicking the button below… I would really appreciate that.

Don’t Forget…

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.

Check Out My Latest Posts

>