M
monalisa2t
Is there a Go To Page function in Excel 2003?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob I
Excel doesn't have pages.
G
Gord Dibben
No
There may be an alternative but need more details on what you are trying to
accomplish.
Gord Dibben MS Excel MVP
There may be an alternative but need more details on what you are trying to
accomplish.
Gord Dibben MS Excel MVP
D
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
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