Hello All. Let’s look at commonly used excel shortcuts used for Windows. If you are looking for shortcuts used for MAC, please check here.
Sl. No | Action | Shortcut |
1 | New Workbook | Ctrl + N |
2 | Open Workbook | Ctrl + O |
3 | Save Workbook | Ctrl + S |
4 | Save As Workbook | F12 |
5 | Ctrl + P | |
6 | Print Preview | Ctrl + F2 |
7 | Close Workbook | Ctrl + F4 |
8 | Close Excel (all open workbook) | Alt + F4 |
9 | Help | F1 |
10 | Redo | Ctrl + Y |
11 | Undo | Ctrl + Z |
12 | Copy selected cells | Ctrl + C |
13 | Cut selected cells | Ctrl + X |
14 | Paste | Ctrl + V |
15 | Paste Special | Ctrl + Alt + V |
16 | Find & Replace | Ctrl + F |
17 | Replace Selected | Ctrl + H |
18 | Select entire worksheet | Ctrl + A |
19 | Select one cell to the right | Shift + Right Arrow |
20 | Select one cell to the left | Shift + Left Arrow |
21 | Select one cell to the top | Shift + Up Arrow |
22 | Select one cell to the bottom | Shift + Down Arrow |
23 | Select till the last cell in the right | Ctrl + Shift + Right Arrow |
24 | Select till the last cell in the left | Ctrl + Shift + Left Arrow |
25 | Select till the last cell in the top | Ctrl + Shift + Up Arrow |
26 | Select till the last cell in the bottom | Ctrl + Shift + Down Arrow |
27 | Edit active cell | F2 |
28 | Insert comment | Shift + F2 |
29 | Apply or Remove Bold formatting | Ctrl + B |
30 | Apply or Remove Italic formatting | Ctrl + I |
31 | Apply or Remove underscoring | Ctrl + U |
32 | Calculate various formulas in worksheet | F9 |
33 | Next worksheet | Ctrl + Pg Dn |
34 | Previous worksheet | Ctrl + Pg Up |
35 | Spelling check | F7 |
I hope you like this short tutorial on the commonly used shortcut. If you don’t see the desired shortcut, check out advanced shortcuts for excel post.
Please let us know your feedback to help improve our content. Thanks for reading.
One thought on “Commonly used Excel Shortcuts for Windows”