Finding specific sheets within a workbook

R

Roy

I have a workbook with over 1000 sheets. 25 of these are numbers unit 1,
unit 2, etc... Each one of these is followed by 50 sheets with supplemental
information. Other than organizing the sheets named "unit x" in order, is
there any way to jump or go to these sheets without having to scroll through
all the other sheets between "unit 1" and the last sheet for "unit 25"?

Thanks in advance for your help.
 
R

ronthedog

Roy said:
I have a workbook with over 1000 sheets. 25 of these are numbers uni
1,
unit 2, etc... Each one of these is followed by 50 sheets wit
supplemental
information. Other than organizing the sheets named "unit x" in order
is
there any way to jump or go to these sheets without having to scrol
through
all the other sheets between "unit 1" and the last sheet for "uni
25"?

Thanks in advance for your help.
Click to expand...

I would suggest the simplest option is to create a navigation shee
with a hyperlinked cell to each sheet on it. You could then use CTRL+
to find the sheet you want and click to get to it.

If you want something more dynamic you'll need a macro to read shee
names and do something like populate a drop-down on a toolbar
 
J

Jim Rech

If you right-click on one of the 4 little arrow-heads in the lower left
corner of the worksheet window you'll get a list of the visible sheets which
you can use to go to a specific one. Other than that I might suggest that
you give a unique name (using Insert, Name, Define or Ctrl-F3) to cell A1 on
each sheet you want to be able to go to quickly and then use that name with
the F5 key.

--
Jim
|I have a workbook with over 1000 sheets. 25 of these are numbers unit 1,
| unit 2, etc... Each one of these is followed by 50 sheets with
supplemental
| information. Other than organizing the sheets named "unit x" in order, is
| there any way to jump or go to these sheets without having to scroll
through
| all the other sheets between "unit 1" and the last sheet for "unit 25"?
|
| Thanks in advance for your help.
|
 
Top