Go To Page function

[monalisa2t]

Is there a Go To Page function in Excel 2003?

 

[Bob I]

Excel doesn't have pages.

 

[Gord Dibben]

No

There may be an alternative but need more details on what you are trying to
accomplish.


Gord Dibben MS Excel MVP

 

[Dave Peterson]

You can hit F5 to see the Goto dialog.
Then type an address of a cell -- if you include the name of the worksheet,
that'll work, too.

like:
Sheet1!x99
or
'Sheet 99'!z23

If you're looking to select a different worksheet...

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. There's a link on that site for an xl2007 version for the ribbon
(from Ron de Bruin).

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