Keyboard Shortcuts

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.

Leave a Comment