Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default move between pages with out scrolling

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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 709
Default move between pages with out scrolling

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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default move between pages with out scrolling

"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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Several questions about move cursor Hank Excel Discussion (Misc queries) 1 August 4th 06 10:44 PM
Excel printing "additional" blank pages? marsulein Excel Discussion (Misc queries) 1 June 30th 06 12:51 PM
What keys to move from bottom to top of page without scrolling? wkscott New Users to Excel 4 October 15th 05 05:54 PM
How to get a listbox to move when scrolling down spreadsheet kdunnSBLI Excel Discussion (Misc queries) 1 June 24th 05 12:31 AM
Want listbox to move when scrolling down spreadsheet kdunnSBLI Excel Discussion (Misc queries) 3 June 23rd 05 11:11 PM


All times are GMT +1. The time now is 09:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"