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

  • Thread starter Thread starter Darmy
  • Start date Start date
D

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?
 
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
 
Right click on the first,previous,next,last buttons to the left of the first
Sheet tab...will display the first 15 tabs..
 
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
 
Back
Top