Show Excel sheet tab in ≥ 2 rows

Question

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.

Answer 1

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:

Microsoft Excel 2013:

Answer 2

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).

Answer 3

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

1. Click Kutools > Navigation. See screenshot:

2. 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.

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.

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

Click here for more details on Navigation Pane.

Answer 4

Excel doesn't natively support multi-row sheet tabs. There are other ways to view more sheets, as outlined in other answers here, but no way to view multiple rows of sheet tabs.

However, there is a commercial Excel add-in called FormulaDesk Navigator that can display multiple rows of sheet tabs as well as vertical sheet tabs and other features:

Disclosure: This is my product. I don't wish to self-promote, but it's the only way to accomplish what the question asks.