Knowledgebase: Microsoft Excel
Move within a selected range.
Posted by - NA - on 17 April 2006 01:06 AM
Solution:

Move from top to bottom within the selected range.
ENTER

Move from bottom to top within the selected range.
SHIFT+ENTER

Move from left to right within the selected range. If cells in a single column are selected, move down.
TAB

Move from right to left within the selected range. If cells in a single column are selected, move up.
SHIFT+TAB

Move clockwise to the next corner of the selected range.
CTRL+PERIOD

In nonadjacent selections, switch to the next selection to the right.
CTRL+ALT+RIGHT ARROW

Switch to the next nonadjacent selection to the left.
CTRL+ALT+LEFT ARROW


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.

(144 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Software by Kayako Fusion