Microsoft Office Tutorials and References
In Depth Information
Techniques for entering data
category, and either clear the After Pressing Enter, Move Selection check box or change
the selection in the Direction drop-down list. You also lock in an entry when you move the
selection to a different cell by pressing Tab, Shift+Tab, Shift+Enter, or an arrow key, among
other methods, after you type the entry, as described in Table 6-3.
TABLE 6-3 Keyboard shortcuts for data entry
Activate the cell below the active cell, or whatever direction you have
selected for the After Pressing Enter, Move Selection option in the
Advanced category in the Excel Options dialog box.
Activate the cell above the active cell, or the opposite of the direction
set for the After Pressing Enter, Move Selection option in the Advanced
category in the Excel Options dialog box.
Activate the cell one column to the right of the active cell.
Activate the cell one column to the left of the active cell.
Activate the adjacent cell in the direction of the arrow key you press.
When you begin typing an entry, three buttons appear on the formula bar: Cancel, Enter,
and Insert Function. When you type a formula in which the entry begins with an equal
sign (=), a plus sign (+), or a minus sign (–), a drop-down list of frequently used functions
becomes available, as shown in Figure 6-7.
For more about editing formulas, see Chapter 12.
Figure 6-7 When you start entering a formula by typing an equal sign, the formula bar offers
ways to help you finish it.