Microsoft Excel is a powerful tool, and knowing the right keyboard shortcuts can help you navigate and work faster. Whether you're a beginner or an Excel pro, mastering these shortcuts can save you time and effort. Below is a list of essential Excel shortcuts you should start using today.
Essential Excel Shortcuts
- Alt + A + M – Remove duplicates (Data tab)
- Ctrl + N – New workbook
- Ctrl + O – Open workbook
- Ctrl + S – Save workbook
- Ctrl + P – Print
- Ctrl + Z – Undo
- Ctrl + Y – Redo
- Ctrl + C – Copy
- Ctrl + X – Cut
- Ctrl + V – Paste
- Ctrl + F – Find
- Ctrl + H – Find and Replace
- Ctrl + A – Select all
- Ctrl + Arrow Keys – Navigate to edge of data
- Shift + Space – Select entire row
- Ctrl + Space – Select entire column
- Ctrl + Home – Go to cell A1
- Ctrl + End – Go to last used cell
- Ctrl + B – Bold
- Ctrl + I – Italic
- Ctrl + U – Underline
- Ctrl + 1 – Format Cells dialog
- F2 – Edit cell
- Alt + = – AutoSum
- Ctrl + ; – Insert current date
- Ctrl + Shift + ; – Insert current time
- Alt + N + V – Insert PivotTable
- Alt + F1 – Create chart in same sheet
- F11 – Create chart in new sheet
- Ctrl + Shift + L – Toggle filters
Quick Tip
If you frequently deal with large datasets, the shortcut Alt + A + M is a lifesaver—it allows you to quickly remove duplicate values directly from the Data tab.
Final Words
Mastering these shortcuts will drastically improve your efficiency in Excel. Bookmark this post and keep practicing until these become second nature!