move between pages with out scrolling

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

Guest

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
 
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
 
"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
 
Back
Top