Software

Ask something
Question Locked

Excel

0 helpful
7 replies

by tkupec

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I would like to know if you can change the number of spreadsheets that are
visable when you right click the sheet arrows in the lower left hand corner
(these are the arrows that let you scroll thru the workbook spreadsheets).
The default is 15 and I need this to be around 25.

7 replies

by seanferd

Hover the cursor over the separator to the right of the tabs. Click on it and drag it to the right as far as you like.

by tkupec

I'm sorry if my question was not clear. If you right click on the arrows you get a list of all the sheets in that workbook, the default is 15 sheets in the list. I have 25 sheets that I would like to view in that list at one time. All that draging the separator does is make the tool bar show more sheets in the tool bar but not all of them. Is this not possible?

by thumbsup2

You're not ever going to be able to see all 25 sheet tabs using a standard monitor. It might be possible to see all 25 sheet tabs if you have dual monitors and spread the window between the two. You can also name your sheets with very small names, such as one character, so you can fit more tabs on the screen.

But, you will always need to see the horizontal scrollbar which resides to the right of the tabs, so if dragging the separator bar as far to the right as possible doesn't give you enough room to see all 25 sheet tabs, you're out of luck.

by tkupec

Open an excel workbook and right click on the arrows in the lower left hand corner of Excel. You get a drop down list of sheets in the workbook, Yes? I want to view 25, not the 15 default? I do not want to view the sheet on the toolbar! Maybe this will get me the answer I am looking for!!!!

by thumbsup2

The tab scrolling buttons are not a toolbar which you can customize. In fact, they're not a toolbar. That is built into the program.

This list will only display the first 15 worksheets, if your workbook contains more then an additional "More Sheets" command will display the Activate dialog box allowing you to select the worksheet from a list box.

However, there is at least one add-in which you can purchase which will give you the functionality you are seeking.

http://www.add-ins.com/office/sheet_navigator.htm

There may be more available. This is just the first one I found and I don't have any idea if it actually works.

This discussion is closed to new replies.