managing multiple worksheets

[GLC]

Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I am working on a workbook that contains 20 worksheets and it's difficult to scroll through all of them. Is there a way to combine/group some of the tabs so as not to have to scroll trough 20 tabs all the time?

 

[Mike Middleton]

GLC -

Here's one thing to try: To the left of the sheet tabs there are four arrow navigation keys. Position the cursor in that area, and right-click (or Control-Click) to see a list of the sheet tabs for navigation.

- Mike
http://www.MikeMiddleton.com

Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I am working on a workbook that contains 20 worksheets and it's difficult to scroll through all of them. Is there a way to combine/group some of the tabs so as not to have to scroll trough 20 tabs all the time?

 

[CyberTaz]

Another Option: Study up on creating Named Ranges, then use the Name Box
list to navigate the workbook based on the range names.

Also: Even if you don't create named ranges you can click in the Name Box &
type where you want to go, such as: [sheetname]!A1, then press return.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[CyberTaz]

PS: I should have pointed out to *not* include the brackets as used in my
"Also:" example... So if the name of the sheet is Sheet97 you'd enter:

Sheet97!A1

Or use whatever cell reference you prefer.

Regards |:>)
Bob Jones
[MVP] Office:Mac

Another Option: Study up on creating Named Ranges, then use the Name Box
list to navigate the workbook based on the range names.

Also: Even if you don't create named ranges you can click in the Name Box &
type where you want to go, such as: [sheetname]!A1, then press return.

HTH |:>)
Bob Jones
[MVP] Office:Mac

Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I am
working on a workbook that contains 20 worksheets and it's difficult to
scroll
through all of them. Is there a way to combine/group some of the tabs so as
not to have to scroll trough 20 tabs all the time?