If you work in Microsoft Excel daily, you already know how repetitive tasks can slow you down. Clicking through menus again and again not only wastes time but also breaks your focus and flow.
That’s exactly why learning Excel shortcut keys is very important. These shortcuts help you perform tasks instantly, improve accuracy, and make your workflow much smoother.
In this complete guide, you will find a comprehensive list of Excel shortcut keys, organized category-wise so you can easily learn and use them in your daily work.
Why Excel Shortcut Keys Are Important
Using shortcut keys is not just about speed. It also improves productivity.
- You save time on repetitive tasks
- You reduce dependency on the mouse
- You improve productivity
- You work more efficiently with large amounts of data
Once you start using them regularly, they become part of your workflow.
🔹 Basic Shortcut Keys
| Shortcut | Action |
| Ctrl + C | Copy |
| Ctrl + V | Paste |
| Ctrl + X | Cut |
| Ctrl + Z | Undo |
| Ctrl + Y | Redo |
| Ctrl + S | Save |
| Ctrl + O | Open |
| Ctrl + N | New Workbook |
| Ctrl + P | |
| Ctrl + W | Close Workbook |
| Ctrl + F | Find |
| Ctrl + H | Replace |
🔹 Navigation Shortcut Keys
| Shortcut | Action |
| Arrow Keys | Move one cell |
| Ctrl + Arrow Keys | Jump to data edge |
| Home | Start of row |
| Ctrl + Home | Go to A1 |
| Ctrl + End | Last used cell |
| Page Up | Move up |
| Page Down | Move down |
| Alt + Page Up | Move left |
| Alt + Page Down | Move right |
| Ctrl + Tab | Switch workbook |
🔹 Selection Shortcut Keys
| Shortcut | Action |
| Shift + Arrow Keys | Select cells |
| Ctrl + Shift + Arrow | Select range |
| Ctrl + A | Select all |
| Shift + Space | Select row |
| Ctrl + Space | Select column |
| Ctrl + Shift + Space | Select sheet |
| Ctrl + Click | Select multiple areas |
🔹 Formatting Shortcut Keys
| Shortcut | Action |
| Ctrl + B | Bold |
| Ctrl + I | Italic |
| Ctrl + U | Underline |
| Ctrl + 1 | Format cells |
| Ctrl + Shift + $ | Currency |
| Ctrl + Shift + % | Percentage |
| Ctrl + Shift + # | Date |
| Ctrl + Shift + @ | Time |
| Ctrl + Shift + ! | Number format |
| Ctrl + Shift + & | Add border |
| Ctrl + Shift + _ | Remove border |
🔹 Data Entry & Editing Shortcut Keys
| Shortcut | Action |
| F2 | Edit cell |
| Alt + Enter | New line |
| Ctrl + D | Fill down |
| Ctrl + R | Fill right |
| Delete | Clear content |
| Ctrl + Backspace | Active cell |
| Ctrl + K | Insert hyperlink |
| Ctrl + ; | Insert date |
| Ctrl + Shift + : | Insert time |
🔹 Formula & Calculation Shortcut Keys
| Shortcut | Action |
| Alt + = | AutoSum |
| Ctrl + ` | Show formulas |
| F9 | Calculate workbook |
| Shift + F9 | Calculate sheet |
| Ctrl + Alt + F9 | Force calculate |
| Shift + F3 | Insert function |
| Ctrl + Shift + Enter | Array formula |
🔹 Rows & Columns Shortcut Keys
| Shortcut | Action |
| Ctrl + Shift + + | Insert row/column |
| Ctrl + – | Delete row/column |
| Ctrl + 9 | Hide row |
| Ctrl + Shift + 9 | Unhide row |
| Ctrl + 0 | Hide column |
| Ctrl + Shift + 0 | Unhide column |
| Alt + H + I + R | Insert row |
| Alt + H + I + C | Insert column |
🔹 Workbook & Worksheet Shortcut Keys
| Shortcut | Action |
| Ctrl + Page Up | Previous sheet |
| Ctrl + Page Down | Next sheet |
| Shift + F11 | New sheet |
| Alt + H + O + R | Rename sheet |
| Ctrl + F4 | Close workbook |
| Alt + F4 | Exit Excel |
| Ctrl + Tab | Switch workbook |
🔹 Advanced & Ribbon Shortcut Keys
| Shortcut | Action |
| Ctrl + T | Create table |
| Ctrl + Shift + L | Toggle filter |
| Alt + Down Arrow | Dropdown |
| Ctrl + Alt + V | Paste special |
| Ctrl + E | Flash fill |
| Alt + H | Home tab |
| Alt + N | Insert tab |
| Alt + P | Page layout |
| Alt + M | Formulas tab |
| Alt + A | Data tab |
| Alt + R | Review tab |
🔹 Pivot Table & Data Analysis Shortcuts
| Shortcut | Action |
| Alt + N + V | Insert pivot table |
| Alt + A + T | Apply filter |
| Ctrl + Shift + L | Toggle filter |
| Alt + F1 | Create chart |
| F11 | Create chart sheet |
Tips to Remember Excel Shortcut Keys Easily
Learning all shortcuts at once can feel overwhelming. However, you can make it easier by following a simple approach.
- Start with frequently used shortcuts
- Practice daily
- Avoid mouse usage where possible
- Focus on your workflow needs
FAQs
1. Are there more than 100 Excel shortcut keys?
Yes, Excel has more than 200 shortcut keys depending on usage and version.
2. Do all shortcuts work in every version?
Most of them work across versions, but some advanced ones may vary.
Wrapping it Up
Now you have a complete and categorized list of excel shortcut keys that can significantly improve your workflow.
Instead of relying on the mouse, start using these shortcuts daily. Over time, you will notice a major improvement in your speed and efficiency.
Read Also – How to get help in Windows
