Navigation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a spreadsheet that will have numerous sheets and would like to
set the first page up as a navigation page - can someone help?!
 
Consider using hyperlinks.

You can set up hyperlinks to take you to individual worksheets or to
specific tables on the worksheets. Just follow the Wizard and specify
hyperlink to "a place in this document".
 
slavenp said:
I have set up a spreadsheet that will have numerous sheets and would like to
set the first page up as a navigation page - can someone help?!
Click to expand...
 
Oops...

If you rightclick on the VCR like controls (to the left of the worksheet tabs),
you'll see a list of worksheets in that workbook.

Other options:

Maybe you could use David McRitchie's Build Table of Contents to get the list
and the hyperlinks all at once:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Another option if you want a more generic solution:
http://contextures.com/xlToolbar01.html
(From Debra Dalgleish's site.)

It builds a toolbar that you can use with any workbook to navigate to any
worksheet.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Back
Top