Written by Puneet for Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019
Video Tutorial
Knowing and using Keyboard Shortcuts while using Excel is one of those Basic Excel Skills that can help you save a ton of time every day. There are more than 500 keyboard shortcuts that you can use in Excel but the problem is not all of those can be helpful for you.
That’s why I have listed only the 82 most important keyboard shortcuts that you can learn and use easily. If somehow you are not able to find a keyboard shortcut for the option that you use frequently in your work, you can use the following method to find it.
Here’s the Tip: When you press the ALT key Excel shows you the keys that you can use to open the tab from the ribbon.
And when you press a key for a particular tab to open it further shows you the keys to open the options that you have on that tab, so one for further drop-downs.
Super Tips
- Replace your 10 most used options with shortcuts.
- Make your fingers learn the shortcut keys.
S No | Description | Shortcut Keys |
|---|---|---|
1 | Move Right | Ctrl + → |
2 | Move Left | Ctrl + ← |
3 | Move Down | Ctrl + ↓ |
4 | Move Up | Ctrl + ↑ |
Basic Operations (8)
S No | Description | Shortcut Keys |
|---|---|---|
1 | Copy | Ctrl + C |
2 | Paste | Ctrl + V |
3 | Cut | Ctrl + X |
4 | Save | Ctrl + S |
5 | Print Preview | Ctrl + P |
6 | Save As | Ctrl + F4 |
7 | Undo | Ctrl + Z |
8 | Redo | Ctrl + Y |
Range (6)
S No | Description | Shortcut Keys |
|---|---|---|
1 | Select All | Ctrl + A |
2 | Select Entire Column | Ctrl + Space |
3 | Select Entire Row | Shift + Space |
4 | Delete | Delete |
5 | Edit a Cell | F2 |
6 | Close Edit More | Esc |
Options (17)
S No | Description | Shortcut Keys |
|---|---|---|
1 | Open Help | F1 |
2 | Right Click Menu | Menu Button |
3 | Conditional Formatting | Alt ⇢ H ⇢ L ⇢ N |
4 | Apply Table | Ctrl + T |
5 | Cell Style | Alt ⇢ H ⇢ J |
6 | Insert a Pivot Table | Alt ⇢ N ⇢ V |
7 | Appy an Excel table to the Data | Alt ⇢ N ⇢ T |
8 | Name Manager | Alt ⇢ M ⇢ N |
9 | Add Filters | Alt ⇢ D ⇢ F ⇢ F |
10 | Insert Data Validation | Alt ⇢ A ⇢ V ⇢ V |
11 | Remove Duplicates | Alt ⇢ A ⇢ M |
12 | Refresh All | Alt ⇢ A ⇢ R ⇢ A |
13 | Open Text to Column | Alt ⇢ A ⇢ E |
14 | Group Rows and Columns | Alt ⇢ A ⇢ G |
15 | Ungroup Rows and Columns | Alt ⇢ A ⇢ U |
16 | Add Subtotal | Alt ⇢ A ⇢ U |
17 | Open Sort | Alt ⇢ A ⇢ S ⇢ S |
Formatting (17)
S No | Description | Shortcut Keys |
|---|---|---|
1 | Bold | Ctrl + B |
2 | Italic | Ctrl + I |
3 | Underline | Ctrl + U |
4 | Open Format Option | Ctrl + ! |
5 | Apply Time Format | Ctrl + Shift + @ |
6 | Apply Date Format | Ctrl + Shift + # |
7 | Apply Currency Format | Ctrl + Shift + $ |
8 | Apply Percentage Format | Ctrl + Shift + % |
9 | Adjust Cell Width to Cell Content | Alt ⇢ H ⇢ O ⇢ I |
10 | Apply Border | Alt ⇢ H ⇢ B ⇢ A |
11 | Change Font Color | Alt ⇢ H ⇢ F ⇢ C |
12 | Change Cell Color | Alt ⇢ H ⇢ H |
13 | Align Text to the Center | Alt ⇢ H ⇢ A ⇢ C |
14 | Merge Cell | Alt ⇢ H ⇢ M ⇢ C |
15 | Wrap Text | Alt ⇢ H ⇢ W |
16 | Change Font Style | Alt ⇢ H ⇢ F ⇢ F |
17 | Change Font Size | Alt ⇢ H ⇢ F ⇢ S |
Insert (9)
S No | Description | Shortcut Keys |
|---|---|---|
1 | Insert a Picture | Alt ⇢ N ⇢ P |
2 | Insert a Shape | Alt ⇢ N ⇢ S ⇢ H |
3 | Insert Charts | Alt ⇢ N ⇢ S ⇢ C |
4 | Insert a Hyperlink | Alt ⇢ N ⇢ I |
5 | Insert Text Box | Alt ⇢ N ⇢ X |
6 | Insert Object | Alt ⇢ N ⇢ J |
7 | Insert Symbol | Alt ⇢ N ⇢ U |
8 | Insert a Header & Footer | Alt ⇢ N ⇢ H |
9 | Open Sparklines | Alt ⇢ N ⇢ Z ⇢ K |
View (9)
S No | Description | Shortcut Keys |
|---|---|---|
1 | Hide/Unhide Formula Bar | Alt ⇢ W ⇢ V ⇢ F |
2 | Hide/Unhide Heading | Alt ⇢ W ⇢ V ⇢ H |
3 | Hide/Unhide Gridlines | Alt ⇢ W ⇢ V ⇢ G |
4 | Change Zoom | Alt ⇢ W ⇢ Q ⇢ C |
5 | Freeze Pane | Alt ⇢ W ⇢ F ⇢ F |
6 | Page Break View | Alt ⇢ W ⇢ I |
7 | Custom View | Alt ⇢ W ⇢ F ⇢ C |
8 | Page Layout View | Alt ⇢ W ⇢ F ⇢ P |
9 | Arrange Windows | Alt ⇢ W ⇢ A |
Functions (10)
S No | Description | Shortcut Keys |
|---|---|---|
1 | Insert Function | Shift + F3 |
2 | Recently Used Functions | Alt ⇢ M ⇢ R |
3 | Financial Functions | Alt ⇢ M ⇢ I |
4 | Logical Functions | Alt ⇢ M ⇢ L |
5 | Text Functions | Alt ⇢ M ⇢ T |
6 | Date and Time Functions | Alt ⇢ M ⇢ E |
7 | Lookup Functions | Alt ⇢ M ⇢ O |
8 | Math and Trig Functions | Alt ⇢ M ⇢ G |
9 | More Functions | Alt ⇢ M ⇢ Q |
10 | Auto Sum | Alt + = |