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 ?
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 amp; 2003
quot;progress2workquot; gt; wrote in message
...
gt; I am using Excel, and I need to arrow up and down etc into other rows by
gt; using the arrow keys on the keyboard. Can you tell me how to do this ?
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.
- Nov 21 Wed 2007 20:41
arrow across, up and down etc in an excel row? How ?
close
全站熱搜
留言列表
發表留言