Display Multiple Excel Worksheet Tabs

BY STANLEY ZAROWIN

Q. Some of my Excel spreadsheets contain many worksheets—up to 36 in some cases. But not all the worksheet tabs show at the bottom of the screen. Is there some way to make more tabs visible, such as displaying multiple rows?

A. Multiple rows would be a good idea, but unfortunately Microsoft hasn’t come up with that solution. There are three things you can do. The first is to slide the divider bar, which is on the bottom of the screen between the tabs and the horizontal scroll bar, all the way to the right; that opens up a bit more space for the tabs.

The second option is to shorten the names on the tabs; that will allow more to show at the bottom of the screen. Notice in the screenshot above how little space the number 2 takes compared with Sheet11 . But of course, no matter how short you make a tab name, you still can’t fit 36 in the space at the bottom of the screen.

The third option is to change how the tabs are displayed. Right-clicking on the controls to the left of the tabs produces a vertical list of all the worksheets in the spreadsheet (see screenshot at below).

If the sheet you want still is not visible, click on More Sheets at the bottom of the list. That launches the Activate dialog box (see below). Click on any of the sheet names to call it to the screen. By the way, Excel can handle as many as 255 worksheets per spreadsheet.

 

SPONSORED REPORT

How to make the most of a negotiation

Negotiators are made, not born. In this sponsored report, we cover strategies and tactics to help you head into 2017 ready to take on business deals, salary discussions and more.

VIDEO

Will the Affordable Care Act be repealed?

The results of the 2016 presidential election are likely to have a big impact on federal tax policy in the coming years. Eddie Adkins, CPA, a partner in the Washington National Tax Office at Grant Thornton, discusses what parts of the ACA might survive the repeal of most of the law.

COLUMN

Deflecting clients’ requests for defense and indemnity

Client requests for defense and indemnity by the CPA firm are on the rise. Requests for such clauses are unnecessary and unfair, and, in some cases, are unenforceable.