move between pages with out scrolling

[Micro Office Excell]

I am currently using a 20 page spread sheet and i am new to this the only way
i can move from one page to another is to scrool down through the pages is
there a way to type in a page number a cell number or even the arrows that
move you through the program easier any help would be very helpful

 

[Paul B]

Macro, from excel help

Arrow keys
Move one cell up, down, left, or right.
CTRL+arrow key
Move to the edge of the current data region.
HOME
Move to the beginning of the row.
CTRL+HOME
Move to the beginning of the worksheet.
CTRL+END
Move to the last cell on the worksheet, in the bottom-most used row of the
rightmost used column.
PAGE DOWN
Move down one screen.
PAGE UP
Move up one screen.
ALT+PAGE DOWN
Move one screen to the right.
ALT+PAGE UP
Move one screen to the left.
F6
Switch to the next pane in a worksheet that has been split (Window menu,
Split command).
SHIFT+F6
Switch to the previous pane in a worksheet that has been split.
CTRL+BACKSPACE
Scroll to display the active cell.
F5
Display the Go To dialog box.
SHIFT+F5
Display the Find dialog box.
SHIFT+F4
Repeat the last Find action (same as Find Next).
TAB
Move between unlocked cells on a protected worksheet.

you can also type a cell reference in the name box and press enter


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Gord Dibben]

"pages" usually refer to printed pages.

Excel workbooks can have multiple worksheets(tabs).

Do you mean one worksheet with 20 "pages" when you print out?

To go to a specific cell address type it into the namebox at left of formula bar
and hit enter key.

If you mean 20 worksheets, use CTRL + Pageup or Pagedown to move through the
sheets.


Gord Dibben MS Excel MVP

On Sun, 24 Sep 2006 16:23:01 -0700, Micro Office Excell <Micro Office