Forum Discussion
Multiple tab view in Excel
Hi-
Does anybody know if there is a way to view multiple tabs on the same sheet at the bottom? I have about 40 sheets in a workbook and I would rather click a tab rather than slide the horizontal scroll bar back and forth. Do the tabs have a setting to go two or three tab rows in height versus just a single row left and right?
Pete,
you can right-klick on the arrow section and get the complete sheet list.
Additionally there are some tools available which might interest you:
Tab Filter (thespreadsheetguru.com)
And multi tools with some sheet/tab functions:
Dose for Excel (zbrainsoft.com)
Excel Tools Add-in.(contextures.com)
Pete,
There is no option in Excel to make the sheet tabs show in multiple bars!
But you can create a main sheet and add hyperlinks to all existing sheets as below screenshot:
To learn more about this please follow these links:
How to add a hyperlink to another sheet
However, I have an idea similar to this topic, if you agree please hit the upvote button!
You vote matters!
