Microsoft Office Tutorials and References
In Depth Information
Learning some handy data-entry techniques
Learning some handy data-entry techniques
You can simplify the process of entering information into your Excel worksheets and make
your work go quite a bit faster by using a number of useful tricks, described in the
following sections.
Automatically moving the cell pointer after entering data
By default, Excel automatically moves the cell pointer to the next cell down when you
press the Enter key after entering data into a cell. (The exception is if you have previously
used Tab to make entries across a row; when you press Enter in that case, the cell pointer
moves to the next row, in the fi rst column where you entered data in the row above.) To
change this setting, choose File Options and click the Advanced tab (see Figure 13.4). The
check box that controls this behavior is labeled After pressing Enter, move selection. If you
enable this option, you can choose the direction in which the cell pointer moves (down,
left, up, or right).
FIGURE 13.4
You can use the Advanced tab in Excel Options to select a number of helpful input option
settings.
13
Your choice is completely a matter of personal preference. I prefer to keep this option
turned off. When entering data, I use the navigation keys rather than the Enter key (see
the next section).
Search JabSto ::




Custom Search