82 Keyboard Shortcuts for Excel YOU Need + (PDF Cheat Sheet)
Last Updated: January 10, 2024
Knowing and using Keyboard Shortcuts is one of those 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.
Super Tips
- Replace your 10 most used options with shortcuts.
- Make your fingers learn the shortcut keys.
Most Amazing Keyboard Shortcuts for Excel
Navigation
Ctrl + → | Move Right |
Ctrl + ← | Move Left |
Ctrl + ↓ | Move Down |
Ctrl + ↑ | Move Up |
Options
F1 | Help |
Menu Button | Right Click Menu |
Ctrl + T | Apply Table |
Alt ⇢ H ⇢ J | Cell Style |
Alt ⇢ N ⇢ V | Insert a Pivot |
Alt ⇢ N ⇢ T | Appy an Excel Table |
Alt ⇢ M ⇢ N | Name Manager |
Alt ⇢ D ⇢ F ⇢ F | Add Filters |
Alt ⇢ A ⇢ V ⇢ V | Add Data Validation |
Alt ⇢ A ⇢ M | Remove Duplicates |
Alt ⇢ A ⇢ R ⇢ A | Refresh All |
Alt ⇢ A ⇢ E | Text to Column |
Alt ⇢ A ⇢ G | Group |
Alt ⇢ A ⇢ U | Ungroup |
Alt ⇢ A ⇢ U | Add Subtotal |
Alt ⇢ A ⇢ S ⇢ S | Open Sort |
View
Alt ⇢ W ⇢ V ⇢ F | Hide Formula Bar |
Alt ⇢ W ⇢ V ⇢ H | Hide Heading |
Alt ⇢ W ⇢ V ⇢ G | Hide Gridlines |
Alt ⇢ W ⇢ Q ⇢ C | Change Zoom |
Alt ⇢ W ⇢ F ⇢ F | Freeze Pane |
Alt ⇢ W ⇢ I | Page Break View |
Alt ⇢ W ⇢ F ⇢ C | Custom View |
Alt ⇢ W ⇢ F ⇢ P | Page Layout View |
Alt ⇢ W ⇢ A | Arrange Windows |
Basic Operations
Ctrl + C | Copy |
Ctrl + V | Paste |
Ctrl + X | Cut |
Ctrl + S | Save |
Ctrl + F4 | Save As |
Ctrl + P | Print Preview |
Ctrl + Z | Undo |
Ctrl + Y | Redo |
Formatting
F1 | Bold |
Menu Button | Italic |
Alt ⇢ H ⇢ L ⇢ N | Underline |
Ctrl + T | Format Option |
Alt ⇢ H ⇢ J | Apply Time Format |
Alt ⇢ N ⇢ V | Apply Date Format |
Alt ⇢ N ⇢ T | Apply Currency Format |
Alt ⇢ M ⇢ N | Apply Percent Format |
Alt ⇢ D ⇢ F ⇢ F | Adjust Cell Width |
Alt ⇢ A ⇢ V ⇢ V | Apply Border |
Alt ⇢ A ⇢ M | Change Font Color |
Alt ⇢ A ⇢ R ⇢ A | Change Cell Color |
Alt ⇢ A ⇢ E | Align Text to the Center |
Alt ⇢ A ⇢ G | Merge Cell |
Alt ⇢ A ⇢ U | Wrap Text |
Alt ⇢ A ⇢ U | Change Font Style |
Alt ⇢ A ⇢ S ⇢ S | Change Font Size |
Alt ⇢ H ⇢ L ⇢ N | Conditional Formatting |
Range
Ctrl + A | Select All |
Ctrl + Space | Select Column |
Shift + Space | Select Row |
Delete | Delete |
F2 | Edit a Cell |
Esc | Close Edit More |
Insert
Alt ⇢ N ⇢ P | Insert a Picture |
Alt ⇢ N ⇢ S ⇢ H | Insert a Shape |
Alt ⇢ N ⇢ S ⇢ C | Insert Charts |
Alt ⇢ N ⇢ I | Insert Hyperlink |
Alt ⇢ N ⇢ X | Insert Text Box |
Alt ⇢ N ⇢ J | Insert Object |
Alt ⇢ N ⇢ U | Insert Symbol |
Alt ⇢ N ⇢ H | Insert a Header |
Alt ⇢ N ⇢ Z ⇢ K | Open Sparklines |
Functions
Shift + F3 | Insert Function |
Alt ⇢ M ⇢ R | Recent Functions |
Alt ⇢ M ⇢ I | Finance Functions |
Alt ⇢ M ⇢ L | Logical Functions |
Alt ⇢ M ⇢ T | Text Functions |
Alt ⇢ M ⇢ E | Date Functions |
Alt ⇢ M ⇢ O | Lookup Functions |
Alt ⇢ M ⇢ G | Math Functions |
Alt ⇢ M ⇢ Q | More Functions |
Alt + = | Auto Sum |
Helpful Note
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 dropdowns.
More Excel Keyboard Shortcuts
More Tutorials for You
Written by Puneet for Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, and Excel 365