18
1
Some days I'm working with extremely large Excel files. They have too many sheets that can't be shown in one sheet tab. (see image)
So, I'm wondering whether or not we can show Excel sheet on more than 1 row. Many tries with Google don't help much.
Many tries but I still can't make Excel show the sheet bar the way I want (≥ 2 rows), so I'm working with some VBA Scripts kopischke suggested.
FYI, right click on |< << >> >|
button on the bottom-right corner show you a list of up to 15 sheets.
For more, click on View more
in the list appeared.
1Another option is to make a list of the sheets, eg in the first sheet, with hyperlinks to the actual sheets... so you create your own list. :) HTH – None – 2015-05-28T16:04:18.440
Can you hide a sheet but still get to it using a hyperlink? – posfan12 – 2016-08-13T04:39:43.267
I just tried and was unable to get it to work. – posfan12 – 2016-08-13T04:46:31.250