The following are some Excel keyboard shortcuts that are especially useful:
Shortcut | Meaning |
Ctrl-C | Copy highlighted range (Copy) |
Ctrl-V | Paste previously copied range into the highlighted location (Paste) |
Ctrl-X | Remove contents of highlighted range (Cut) |
Ctrl-D | Copy contents of the topmost cell (or row) in the highlighted range into the cells below (Fill Down) |
Ctrl-R | Copy contents of the leftmost cell (or column) in the highlighted range into the cells on the right (Fill Right) |
Ctrl-Y | Repeat/Redo |
Ctrl-Z | Undo |
Ctrl-Shft-A | Display the arguments in a worksheet function after typing the function’s name |
Ctrl-Shft-Enter | Enter an array formula |
Ctrl-Shft-& | Draw a border around the highlighted range |
Ctrl-Shft-_ | Remove any borders in and around the highlighted range |
Ctrl-Shft-↓ | If the current cell is not empty then extend the range down to the last non-blank cell, while if the current cell is empty then extend the range down to the first non-empty cell |
F4 | Cycle through absolute and relative addressing in a cell range |
F9 | Calculate the value of a formula and then replace the formula by its value |
Arrow keys | Move one cell up, down, right or left in a worksheet |
Delete key | Remove contents of all cells in the highlighted range |
Esc key | Cancel a cell entry; this is especially useful when you have inadvertently tried to modify a part of a range containing an array formula |
Figure 1 – Excel keyboard shortcuts
Observation: The Ctrl-Shft-↓ shortcut can also be used when more than one cell is selected. If the selected range contains only one column, then the result is based on the last cell in the selected range. If the selected range contains more than one column, then the result is based on the first column of the selected range, although the corresponding rows in the other columns are also selected.