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

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?

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

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Darmy" wrote in message ...
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?

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

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

"Darmy" wrote:

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?

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

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

--
Jacob


"Darmy" wrote:

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?

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

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

On Tue, 15 Dec 2009 09:37:03 -0800, Darmy
wrote:

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?