Microsoft Office Tutorials and References
In Depth Information
Move in a Different Direction When You Press Enter
Chapter 1: Making Excel More Efficient
4 Make sure that the After
Pressing Enter, Move
Selection check box is
5 Click the Direction
drop-down arrow, and
select the direction that
you want Excel to move
the selection after you
6 Click OK.
Excel now moves the
selection in the direction
you specified when you
press Enter to confirm a
Did You Know?
If you have only a few data items to enter, you can force Excel to move the selection in
the direction of the next cell entry by using the arrow keys. For example, suppose you
are entering data in a row from left to right. When you finish editing a cell, press the
right arrow key, which moves the selection to the next cell on the right. Similarly, you
can press the left arrow key to move the selection to the left, or you can press the up
arrow key to move the selection up.