| The Most Useful Excel Keyboard Shortcuts |
| |
| Key |
Description |
| Ctrl + Z |
Undo |
| Ctrl + C |
Copy |
| Ctrl + C and then Enter |
Paste |
| Ctrl + V |
Multiple Paste |
| Ctrl + X |
Cut |
| Ctrl + F or Shift + F5 |
Find |
| Ctrl + H |
Find & Replace |
| Ctrl + G or F5 |
Go To |
| Ctrl + P |
Print |
| Ctrl + O |
Open |
| Ctrl + N |
Creates a new blank file |
| Ctrl + S |
Save |
| Ctrl + W |
Close workbook |
| Ctrl + F4 |
Close |
| Alt + F4 |
Close Excel |
| F9 |
Calculate all sheets in all open
workbooks |
| Shift + F9 |
Calculate the active worksheet |
| Ctrl + Alt + F9 |
Calculate all sheets in the
active workbook |
| Ctrl + Arrow or End and then
press Arrow |
Move to edge of region |
| Ctrl + * |
Select current region |
| Ctrl + A |
Select entire region or
worksheet (press twice for worksheet) |
| Ctrl + Home |
Select A1 |
| Ctrl + End |
Select last cell in range |
| Ctrl + Shift + End |
Select from active cell to last
cell in range |
| Ctrl + Shift + Home |
Select from active cell to A1 |
| Ctrl + Page Down |
Move to next worksheet |
| Ctrl + Page Up |
Move to previous worksheet |
| Ctrl + Tab |
Move to next open workbook |
| Ctrl + N |
Open new workbook |
| Shift + F11 |
Insert new worksheet |
| Alt + F11 |
Open VBE |
| Ctrl + Shift + Enter |
Array formula |
| Ctrl + F3 |
Define name |
| Ctrl + Space |
Selects the current columns |
| Shift + Space |
Selects the current rows |
| Ctrl + 9 |
Hides the selected rows |
| Ctrl + 0 |
Hides the selected columns |
| Ctrl + ( |
Display hidden rows |
| Ctrl + ) |
Display hidden columns |
| Ctrl + - |
Deletes rows, columns or cells |
| Ctrl + + |
Inserts rows, columns or cells |
| Ctrl + ` |
Toggles between displaying cell
values or formulas in the worksheet |
| Ctrl + K |
Insert Hyperlink or Edit
hyperlink |
| Ctrl + L |
Displays the Create List dialog
box |
| Ctrl + 1 |
Format cells |
| Ctrl + : |
Enters the current time |
| Ctrl + ; |
Enters the current date |
|
|