Microsoft Office Tutorials and References
In Depth Information
Move in a Different Direction When You Press Enter
Move in a Different Direction
When You Press Enter
In certain cases, you can make your Excel
data-entry chores more efficient by changing the
direction that Excel moves the selection when
you press Enter after you finish editing a cell.
Generally, you enter the data vertically in a
column of cells. Excel allows you to do this by
automatically moving the selection down to
the next cell when you press Enter.
However, in some cases you might need to
enter a large amount of data in a row, either
from left to right or from right to left, or in a
column from top to bottom. Although you can
use the arrow keys to force the selection to
move in the direction you want, the Enter key
is larger than the arrow keys and is thus faster
to use and less prone to error. Therefore, you
can configure Excel to move the selection in
the direction you prefer when you press Enter.
1 Click the File tab.
2 Click Options.
The Excel Options dialog
3 Click the Advanced tab.