| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Excel Workbook multiple worksheets I want 1 chart | Charts and Charting in Excel | |||
| Excel 2007 storing the high and low | Excel Discussion (Misc queries) | |||
| how do I limit the Number of rows in an excel 2007 workbook | Setting up and Configuration of Excel | |||
| Number of rows in Excel 2007 worksheets | Excel Discussion (Misc queries) | |||
| Excel 2007 high cpu | Excel Discussion (Misc queries) | |||
Linear Mode
