Go To Page function
 

Is there a Go To Page function in Excel 2003?

Go To Page function
 

Excel doesn't have pages.

monalisa2t wrote:

Is there a Go To Page function in Excel 2003?

Go To Page function
 

No

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


Gord Dibben MS Excel MVP


On Fri, 26 Feb 2010 10:26:01 -0800, monalisa2t
wrote:

Is there a Go To Page function in Excel 2003?

Go To Page function
 

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


monalisa2t wrote:

Is there a Go To Page function in Excel 2003?

--

Dave Peterson