Excel provides the following keyboard shortcuts for entering data in your worksheets and editing the existing entries in cells . To start entering data in a blank cell, simply select the cell and type the entry.
[Enter]
By default, when you press [Enter] , Excel selects the next cell below the active cell. You can change the direction of the next cell (up, down, left, or right), or turn off the movement, by using the Move Selection After Enter check box and Direction drop-down list on the Edit tab of the Options dialog box (Tools Options).
[Esc]
Canceling editing loses any changes you ve made to the cell s contents.
[Shift] - [Enter]
Press [Shift] - [Enter] to select the cell in the opposite direction from that specified in the Direction drop-down list on the Edit tab of the Options dialog box.
[Tab]
[Shift] - [Tab]
[Ctrl] - [Enter]
Select the range of cells you want to affect, type the entry, and press [Ctrl] - [Enter] to enter it in all the cells simultaneously .
[Ctrl] - [Shift] - [:]
[Ctrl] - [;]
[Ctrl] - [F3]
Use the Define Name dialog box (shown here) to add and delete range names .
[Ctrl] - [Shift] - [F3]
Use the Create Names dialog box (shown here) to create names from row labels and column labels.
[Alt] - [ “ ]
The AutoComplete drop-down list shows the entries in the column available for reuse.
[F2]
To edit the existing contents of a cell, select it and press [F2] . Excel places the insertion point at the end of the cell s existing contents.
Note | If the Edit Directly in Cell check box on the Edit tab of the Options dialog box is cleared, pressing [F ’ ] activates the Formula bar instead. |
[Shift] - [F2]
If the active cell has a comment attached to it, Excel opens the comment for editing. If the active cell has no comment, Excel creates a new comment.
[Backspace]
Pressing [Backspace] deletes the contents of the active cell when the cell is not in Edit mode.
[Ctrl] - [Delete]
Press [F2] to switch the cell to Edit mode, position the insertion point after the last character you want to keep, and then press this shortcut to delete the rest.
[Alt] - [Enter]
Use this shortcut when you need to break text to a new line within a cell.
[Ctrl] - [Shift] - [Z]
This shortcut works only when Excel is displaying the AutoCorrect Smart Tag.
Excel 2000 Excel 2000 doesn t support Smart Tags, so it doesn t offer this shortcut.
[Ctrl] - [6]
Press [Ctrl] - [6] to cycle between displaying objects, displaying placeholders for objects, and hiding objects.