Page 248 - Excel Data Analysis
P. 248
13 537547 AppA.qxd 3/4/03 11:58 AM Page 234
APPENDIXAPPENDIX
EXCEL KEYBOARD SHORTCUTS
DATA ENTRY SHORTCUTS
SHORTCUT RESULT
Enter Completes the cell entry and moves to the next cell.
Alt + Enter Starts a new line within the same cell.
Shift + Enter Completes the cell entry and moves up to the cell above.
Tab Completes the cell entry and moves to next cell on the right.
Shift + Tab Completes the cell entry and moves to the next cell on the left.
Esc Cancels the cell entry and restores original cell contents.
Ctrl + D Fills the active cell with the contents of the cell above it.
Ctrl + R Fills the active cell with the contents of the cell to the left of it.
Ctrl + F3 Displays the Define Name dialog box.
Ctrl + K Displays the Insert Hyperlink dialog box.
F2 Edits the active cell by placing the insertion point at the end of the cell contents.
EDITING SHORTCUTS
SHORTCUT RESULT
Ctrl + C Copies the selection.
Ctrl + X Cuts the selection.
Ctrl +V Pastes the selection.
Backspace Deletes entire contents of a cell, or character on the left of the insertion point if
you are editing the cell contents.
Delete Deletes entire contents of a cell, or character on the right of the insertion point if
you are editing the cell contents.
Ctrl + Delete Deletes text from the insertion point to the end of the cell contents.
Ctrl + Z Undoes an action.
Ctrl + Y Repeats an action (Redo).
F4 Repeats an action (same as Ctrl + Y).
Ctrl + - Deletes the selection.
Ctrl + Shift + + Inserts blank cells.
234
234