Manage a high number of worksheets in one workbook (Excel 2007)

[Darmy]

Excel 2007: Many of the workbooks I deal with have 20+ sheets. I'd like a
more practical method to view all sheets (tabs at bottom of workbook) than
scrolling or right clicking and seeing a list... Is there any way to 'stack'
the tabs, say three high, across the bottom of the workbook so that all are
immediately visible and accessible?

 

[Ron de Bruin]

Maybe you like this one
http://www.contextures.com/xlToolbar01b.html

 

[Mike H]

Hi,

If you right click the FF/Rew button to the left of the leftmost sheet you
get a list of all sheets which you can use to navigate to those sheets.

Mike

 

[Jacob Skaria]

Right click on the first,previous,next,last buttons to the left of the first
Sheet tab...will display the first 15 tabs..

 

[Gord Dibben]

Since you don't like the right-click on the navigation arrows

You can build a Sheet Navigation Toolbar as per Dave Peterson's code on
Debra Dalgleish's site. Sorts as well as navigates.

http://www.contextures.on.ca/xlToolbar01.html

Or see this google search thread for the BrowseSheets macro from Bob
Phillips.

http://tinyurl.com/yoa3dw

I personally prefer Bob's method. No extra Toolbar, just a button to click.

I have added BrowseSheets to my right-click menu.


Gord Dibben MS Excel MVP