Microsoft Excel Shortcut Keys Every Professional Must Know in 2026
Mar 31, 2026 5 Min Read 99 Views
(Last Updated)
Every minute you spend clicking through Excel menus is a minute you are not actually working. Yet most people never learn the Excel shortcut keys that could cut their spreadsheet time in half, not because they are difficult, but because nobody showed them where to start.
Excel shortcut keys are the single fastest way to level up your productivity. Studies show that regular users of keyboard shortcuts save an average of 8 days of work per year by keeping their hands off the mouse. Whether you are building financial models, cleaning up data, or managing simple lists, the right shortcuts make the difference between struggling and flowing.
This guide covers every essential Microsoft Excel shortcut key, from beginner basics to advanced power-user commands, all organized by category so you can find what you need and start using it today. And the best part? Every shortcut here works across Excel 2016, Excel 2019, and Microsoft 365, so no matter what version you are on, you are covered.
Quick Answer:
Excel shortcut keys are keyboard combinations that help you navigate, format, edit, and manage data faster than using a mouse. The most essential Excel shortcut keys ones include Ctrl+C (copy), Ctrl+V (paste), Ctrl+Z (undo), Alt+= (AutoSum), and Ctrl+T (create a table).
Table of contents
- Why Learn Microsoft Excel Shortcut Keys?
- Basic Navigation Shortcuts
- 2. File and Workbook Management Excel Shortcut Keys
- Cell Formatting Shortcuts
- 4. Data Entry and Editing Shortcuts
- 5. Selection and Copy-Paste Shortcuts
- 6. Formula and Function Shortcuts
- Row, Column, and Sheet Shortcuts
- Advanced and Power User Shortcuts
- Quick Reference Cheat Sheet: All Microsoft Excel Shortcut Keys
- File Management
- Formatting
- Formulas
- Conclusion
- Frequently Asked Questions
- 1. What are Excel shortcut keys?
- What are the most commonly used Excel shortcut keys?
- 3. Are Excel shortcut keys the same in all versions?
- How can beginners start learning Excel shortcuts?
- Do Excel shortcuts really improve productivity?
- What are advanced Excel shortcut keys used for?
- Can I customize Excel shortcut keys?
- What is the fastest way to remember Excel shortcuts?
- Are there shortcuts for formulas in Excel?
- Which Excel shortcuts should I learn first as a professional?
- Which Excel shortcuts are best for daily work?
- How many Excel shortcuts should I learn?
Why Learn Microsoft Excel Shortcut Keys?
Before diving in, here is why Excel shortcut keys matter:
- Speed: Excel shortcut keys are 2–3x faster than navigating ribbon menus with a mouse.
- Accuracy: Fewer mouse clicks means fewer accidental wrong-clicks.
- Ergonomics: Reducing mouse dependency lowers the risk of repetitive strain injuries.
- Professionalism: Mastering Excel shortcut keys makes you stand out at work.
- Universal: These shortcuts work across Excel 2016, 2019, and Microsoft 365.
1. Basic Navigation Shortcuts
Start here if you are new to Excel shortcut keys. These five navigation shortcuts alone will change how you move around large spreadsheets.
| Shortcut Key | Action |
| Ctrl + Home | Jump to cell A1 (beginning of the sheet) |
| Ctrl + End | Jump to the last used cell in the spreadsheet |
| Ctrl + Arrow Keys | Move to the edge of the current data region |
| Ctrl + Page Up/Down | Switch between worksheet tabs |
| F5 / Ctrl + G | Open the Go To dialog box |
Also Explore: Top 7 Excel Course with Certifications
2. File and Workbook Management Excel Shortcut Keys
These Excel shortcut keys help you manage files quickly without using the mouse.
| Shortcut Key | Action |
| Ctrl + N | Create a new workbook |
| Ctrl + O | Open an existing workbook |
| Ctrl + S | Save the current workbook |
| Ctrl + Shift + S | Save As (save a copy with a new name) |
| Ctrl + W | Close the current workbook |
| Alt + F4 | Close Microsoft Excel completely |
Want to put these shortcuts into real practice? The HCL GUVI Microsoft Excel Course walks you through hands-on exercises so these skills actually stick.
3. Cell Formatting Shortcuts
Formatting shortcuts are among the most searched Excel shortcut keys. Use these to apply styles, number formats, and colors instantly.
| Shortcut Key | Action |
| Ctrl + B | Apply or remove Bold formatting |
| Ctrl + I | Apply or remove Italic formatting |
| Ctrl + U | Apply or remove Underline formatting |
| Ctrl + 1 | Open the Format Cells dialog box |
| Ctrl + Shift + $ | Apply Currency number format |
| Ctrl + Shift + % | Apply Currency number format |
| Ctrl + Shift + ^ | Apply Scientific (Exponential) format |
| Ctrl + Shift + # | Apply Date format (dd-mmm-yy) |
| Alt + H + H | Open the Fill Color picker |
| Alt + H + FC | Open the Font Color picker |
Read: Work Smarter with Microsoft Excel: The Complete 2026 Guide
4. Data Entry and Editing Shortcuts
Speed up your data entry and editing with these essential shortcuts. These are the ones you will use dozens of times every working day.
| Shortcut Key | Action |
| F2 | Edit the active cell (enter edit mode) |
| Ctrl + D | Fill Down — copy the top cell to selected cells below |
| Ctrl + R | Fill Right — copy the leftmost cell to selected cells to the right |
| Ctrl + ; | Insert today’s date |
| Ctrl + Shift + : | Insert the current time |
| Ctrl + Z | Undo the last action |
| Ctrl + Y | Redo the last undone action |
| Delete | Clear cell contents (keeps formatting) |
| Backspace | Delete one character at a time inside a cell in edit mode |
| Esc | Cancel the current cell entry without saving |
5. Selection and Copy-Paste Shortcuts
Efficient selection is critical for working with large datasets. These shortcuts let you select, copy, cut, and paste data at lightning speed. Efficient selection becomes easy when you use the right Excel shortcut keys.
| Shortcut Key | Action |
| Ctrl + A | Select all cells in the spreadsheet |
| Ctrl + Shift + End | Extend selection to the last used cell |
| Shift + Arrow Keys | Extend selection one cell at a time |
| Ctrl + Shift + Arrow | Extend selection to the edge of the data region |
| Ctrl + C | Copy selected cells |
| Ctrl + X | Cut selected cells |
| Ctrl + V | Paste copied or cut content |
| Ctrl + Alt + V | Open the Paste Special dialog |
| Ctrl + D (after Copy) | Duplicate a selected range down |
6. Formula and Function Shortcuts
If you work with calculations, these Excel shortcut keys are essential for faster formula handling.
| Shortcut Key | Action |
| Alt + = | AutoSum — automatically insert a SUM formula |
| Ctrl + ` | Toggle between formula view and value view |
| F4 | Toggle absolute/relative cell references ($A$1, A$1, $A1, A1) |
| Shift + F3 | Open the Insert Function dialog |
| Ctrl + Shift + Enter | Enter an array formula |
| F9 | Recalculate all formulas in the workbook |
| Shift + F9 | Recalculate only the active worksheet |
7. Row, Column, and Sheet Shortcuts
Managing spreadsheet structure becomes faster with these Excel shortcut keys.
| Shortcut Key | Action |
| Ctrl + Shift + + | Insert a new row or column |
| Ctrl + – | Delete the selected row or column |
| Ctrl + Spacebar | Select the entire column |
| Shift + Spacebar | Select the entire row |
| Ctrl + 9 | Hide selected rows |
| Ctrl + Shift + 9 | Unhide rows |
| Ctrl + 0 | Hide selected columns |
| Ctrl + Shift + 0 | Unhide columns |
| Alt + O + R + R | Rename the active sheet tab |
8. Advanced and Power User Shortcuts
Ready to take it to the next level? These advanced Microsoft Excel shortcut keys are used by analysts, accountants, and data professionals every day.
| Shortcut Key | Action |
| Ctrl + T | Convert a range of data into an Excel Table |
| Alt + F1 | Create an embedded chart from the selected data |
| Ctrl + Shift + L | Toggle AutoFilter on or off |
| Alt + F8 | Open the Macro dialog box |
| Alt + F11 | Open the Visual Basic Editor (VBA) |
| Ctrl + F | Open the Find dialog |
| Ctrl + H | Open the Find and Replace dialog |
| Ctrl + K | Insert a hyperlink |
| Shift + F11 | Insert a new worksheet |
| Alt + W + F + F | Freeze or unfreeze panes |
Shortcuts are just the beginning. If you are serious about becoming an Excel expert, the Microsoft Excel Course on HCL GUVI gives you structured lessons, real-world projects, and a certificate to show for it.
Quick Reference Cheat Sheet: All Microsoft Excel Shortcut Keys
Here is a complete reference of every shortcut covered in this guide, organized by category for easy scanning and printing.
Navigation
| Shortcut Key | Action |
| Ctrl + Home | Go to cell A1 |
| Ctrl + End | Go to last used cell |
| Ctrl + Arrow | Jump to edge of data |
| Ctrl + PgUp/PgDn | Switch worksheets |
| F5 / Ctrl + G | Go To dialog |
File Management
| Shortcut Key | Action |
| Ctrl + N | New workbook |
| Ctrl + O | Open workbook |
| Ctrl + S | Close workbook |
| Ctrl + Shift + S | Save As |
| Ctrl + W | Close workbook |
Formatting
| Shortcut Key | Action |
| Ctrl + B / I / U | Bold / Italic / Underline |
| Ctrl + 1 | Format Cells dialog |
| Ctrl + Shift + $ | Currency format |
| Ctrl + Shift + % | Percentage format |
| Alt + H + H | Fill color |
Formulas
| Shortcut Key | Action |
| Alt + = | AutoSum |
| Ctrl + ` | Toggle formula view |
| F4 | Toggle reference type ($) |
| Shift + F3 | Insert Function dialog |
| F9 | Recalculate all |
Conclusion
Here is the truth about Excel shortcut keys: you do not become faster by reading about them. You become faster by using them. Pick 5 Excel shortcut keys from this guide right now and commit to using them daily.
It will feel awkward for a day or two. Then it will feel natural. By the end of the week, it will feel slow to do it any other way.
Come back to this guide whenever you are ready to add more to your toolkit. Bookmark it, print the cheat sheet, or pin it somewhere visible at your desk. The professionals who seem to “just know” Excel did not learn it all at once. They built the habit one shortcut at a time, and so can you.
Come back to this guide whenever you are ready to add more to your toolkit. Bookmark it, print the cheat sheet, or pin it somewhere visible at your desk. The professionals who seem to “just know” Excel did not learn it all at once. They built the habit one shortcut at a time, and so can you.
Come back to this guide whenever you are ready to add more to your toolkit. Bookmark it, print the cheat sheet, or pin it somewhere visible at your desk. The professionals who seem to “just know” Excel did not learn it all at once. They built the habit one shortcut at a time, and so can you.
Frequently Asked Questions
1. What are Excel shortcut keys?
Excel shortcut keys are keyboard combinations that help you perform tasks faster without using a mouse. They improve speed, accuracy, and overall productivity when working in spreadsheets.
2. What are the most commonly used Excel shortcut keys?
The most essential Excel shortcut keys every professional should know include:
Ctrl + C – Copy
Ctrl + V – Paste
Ctrl + Z – Undo
Ctrl + S – Save
Ctrl + T – Create table
Alt + = – AutoSum
These are the foundation of Excel productivity tips and are used daily.
3. Are Excel shortcut keys the same in all versions?
Yes, most Excel shortcut keys work across:
Excel 2016
Excel 2019
Microsoft 365
However, a few advanced shortcuts (especially related to macros or newer features) may vary slightly.
4. How can beginners start learning Excel shortcuts?
Start with basic Excel navigation shortcuts and gradually expand:
Learn 5–10 shortcuts first (copy, paste, save, undo)
Use them daily instead of the mouse
Add new shortcuts every week
This step-by-step approach works best for Excel shortcuts for beginners.
5. Do Excel shortcuts really improve productivity?
Yes. Studies and workplace observations show:
Tasks become 2–3x faster
Reduced dependency on mouse
Better workflow continuity
Using Excel keyboard shortcuts consistently can save hours every week.
6. What are advanced Excel shortcut keys used for?
Advanced Excel shortcut keys are used for:
Data analysis (Ctrl + Shift + L for filters)
Table creation (Ctrl + T)
Macros (Alt + F8)
VBA editor (Alt + F11)
These are widely used by analysts and professionals working with large datasets.
7. Can I customize Excel shortcut keys?
Yes, you can customize some shortcuts by:
Using Quick Access Toolbar (Alt shortcuts)
Creating macros with assigned keys
Using VBA for advanced customization
8. What is the fastest way to remember Excel shortcuts?
The best way to remember shortcuts is:
Practice daily on real tasks
Use a printed cheat sheet
Focus on repetition rather than memorization
Consistency is the key to mastering the Excel keyboard shortcuts list.
9. Are there shortcuts for formulas in Excel?
Yes, some important formula-related shortcuts include:
Alt + = – AutoSum
F4 – Toggle absolute references
Ctrl + ` – Show formulas
Shift + F3 – Insert function
These are essential for anyone working with calculations and data analysis.
10. Which Excel shortcuts should I learn first as a professional?
Start with high-impact shortcuts:
Navigation: Ctrl + Arrow Keys
Editing: F2, Ctrl + D
Formatting: Ctrl + 1
Selection: Ctrl + Shift + Arrow
Data handling: Ctrl + T
11. Which Excel shortcuts are best for daily work?
Focus on navigation, editing, and formatting shortcuts like Ctrl + Arrow, F2, Ctrl + D, and Ctrl + 1.
12. How many Excel shortcuts should I learn?
Start with 5–10 shortcuts, then gradually expand. Over time, you can build a strong set of advanced Excel shortcut keys.



Did you enjoy this article?