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

Revenue recognition: A complex effort

Implementing the new standard requires careful judgment. Learn how to make significant accounting judgments and document them and collaborate with peers for consistent application.

TECHNOLOGY Q&A

How to create maps in Excel 2016

Microsoft Excel 2016 has two new mapping capabilities. J. Carlton Collins, CPA, demonstrates how to make masterful 2D and 3D maps in Excel 2016.

QUIZ

News quiz: Economy and health care changes top CPAs’ list

CPA decision-makers’ economic outlook and the House Republicans’ proposed tax changes as part of replacing the Patient Protection and Affordable Care Act received attention recently. See how much you know with this short quiz.