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 horizon...
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!
Thanks for the help!