move between pages with out scrolling

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Micro Office Excell - 25 Sep 2006 00:23 GMT

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

Reply to this Message

Paul B - 25 Sep 2006 00:42 GMT

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

Signature

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

> 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

Reply to this Message

Gord Dibben - 25 Sep 2006 00:52 GMT

"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

>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

Reply to this Message

Rate this thread: