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

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?
 
M

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
 
J

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..
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top