Datasheet

14
33
22
11
The Excel Options dialog
box appears.
3 Click the Advanced tab.
1 Click the File tab.
2 Click Options.
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.
Move in a Different Direction
When You Press Enter
03_577769-ch01.indd 1403_577769-ch01.indd 14 3/27/10 9:00 AM3/27/10 9:00 AM