arrow across, up and down etc in an excel row? How ?

P

progress2work

I am using Excel, and I need to arrow up and down etc into other rows by
using the arrow keys on the keyboard. Can you tell me how to do this ?
 
P

Paul B

progress2work, from help, Keyboard shortcuts

Arrow keys
Move one cell up, down, left, or right.
CTRL+arrow key
Move to the edge of the current data region.


Move within a selected range

ENTER
Move from top to bottom within the selected range.
SHIFT+ENTER
Move from bottom to top within the selected range.
TAB
Move from left to right within the selected range. If cells in a single
column are selected, move down.
SHIFT+TAB
Move from right to left within the selected range. If cells in a single
column are selected, move up.
CTRL+PERIOD
Move clockwise to the next corner of the selected range.
CTRL+ALT+RIGHT ARROW
In nonadjacent selections, switch to the next selection to the right.
CTRL+ALT+LEFT ARROW
Switch to the next nonadjacent selection to the left.
Note You can change the direction of movement after pressing ENTER or
SHIFT+ENTER: press ALT+T and then O (Tools menu, Options command), press
CTRL+TAB until the Edit tab is selected, and then change the Move selection
after Enter settings.



--
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
 
B

BJ Gates

I am fairly new to Excel after years of using Lotus 1-2-3. I know how to do
non adjacent cell selections there, and from what I read, it should work the
same in Excel, but when I get my selections made and save print area, and
preview, the entire worksheet comes us.

I must be missing a step. I can do the selections with the mouse or with
the keyboard.
 
Top