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?
4 Replies
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:
https://support.office.com/en-us/article/Work-with-hyperlinks-in-Excel-7fc80d8d-68f9-482f-ab01-584c44d72b3e
https://www.ablebits.com/office-addins-blog/2014/05/15/excel-insert-hyperlink/
However, I have an https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/32124664-why-don-t-we-have-in-excel-a-navigation-pane similar to this topic, if you agree please hit the upvote button!
You vote matters!
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)
