Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 "Micro Office Excell" <Micro Office wrote in message ... 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 |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
"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 wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Several questions about move cursor | Excel Discussion (Misc queries) | |||
Excel printing "additional" blank pages? | Excel Discussion (Misc queries) | |||
What keys to move from bottom to top of page without scrolling? | New Users to Excel | |||
How to get a listbox to move when scrolling down spreadsheet | Excel Discussion (Misc queries) | |||
Want listbox to move when scrolling down spreadsheet | Excel Discussion (Misc queries) |