Show Excel sheet tab in ≥ 2 rows

Solution 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:

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