Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Some days I'm working with extremely large Excel files, they have to many sheet that can't be show in 1 sheet tab. (see image)

too many sheet in an Excel files

So, I'm wondering that whether or not we can show Excel sheet on more than 1 row. Many tries with Google don't help much then I post this question here!


Many tries but I still can't make Excel show 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 upto 15 sheets. and for more, click on View more in the list appeared.

share|improve this question
    
Another 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 – user452833 May 28 '15 at 16:04

Another work around that might not be immediately obvious is that you can right click on the little arrows in the bottom left corner of the window that you use to scroll left and right on the sheets. Doing so opens a vertical list sheets with the option to display more.

Microsoft Excel 2010:

enter image description here

Microsoft Excel 2013:

enter image description here

share|improve this answer
2  
Good one – never noticed that (as you said: not exactly obvious). – kopischke Oct 28 '11 at 10:45
    
I knew about it, but it just displays 15 sheets in that list. and to kopischke : view more take we to a scroll list of all sheet. – LongTTH Oct 28 '11 at 12:30

Excel will only display one row of sheet tabs, I’m afraid. If space runs scarce, you have the following options to display more:

  • resize the tab area (by dragging the handle separating it from the horizontal scrollbar), and / or
  • rename your sheets to have a shorter name, so that more sheets show (by removing the “Sheet” part, say, making the tab names “1”, “2” etc.), and / or
  • hide sheets (right click on their tab to get the option; right clicking on a visible tab will get you an option to see all hidden sheets and show them again) if there are some you do not need.

Finally, there are VBA scripts out there claiming to build a menu of all sheets in the workbook, which might solve your problem (untested).

share|improve this answer

Another workaround: use Kutools for Excel (free to try with no limitation in 30 days).

  1. Click Kutools > Navigation. See screenshot:

enter image description here

  1. Then you can see a Navigation Pane shown at the left of the sheet, click Sheets tab, and in the Workbooks list select the workbook whose sheet tabs you want to view, then in the Worksheets list, you can view all the sheet tabs.

enter image description here

If the sheet tabs are too many to display all in the Worksheets list, you can shorten the workbooks list with moving cursor over the bottom border of Workbooks list, and then drag it up when the cursor becomes.

enter image description here

The Vertical scrollbar will come out automatically when the sheet tabs can’t be shown fully.

Click here for more details on Navigation Pane.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .