Microsoft Excel Keyboard Shortcuts — Complete Cheatsheet
Microsoft Excel is a powerful spreadsheet program used for data organization, analysis, and visualization. Mastering its keyboard shortcuts can dramatically increase your efficiency and productivity, allowing you to navigate and manipulate data with speed and precision.
Upgrade Your Workflow: MX Master 3S Mouse
Pair your shortcuts with the ultimate developer mouse. Silent clicks, 8K DPI tracking, and hyper-fast scrolling.
Shortcuts
| Action | Windows | Mac | Category |
|---|---|---|---|
| Cut selected cells | Ctrl+X | Cmd+X | Basic Editing |
| Copy selected cells | Ctrl+C | Cmd+C | Basic Editing |
| Paste content | Ctrl+V | Cmd+V | Basic Editing |
| Undo last action | Ctrl+Z | Cmd+Z | Basic Editing |
| Redo last action | Ctrl+Y | Cmd+Y | Basic Editing |
| Save workbook | Ctrl+S | Cmd+S | File Management |
| Open workbook | Ctrl+O | Cmd+O | File Management |
| Create new workbook | Ctrl+N | Cmd+N | File Management |
| Close workbook | Ctrl+W | Cmd+W | File Management |
| Select all cells in current worksheet | Ctrl+A | Cmd+A | Selection & Navigation |
| Move to the beginning of the row | Home | Fn+Left Arrow | Selection & Navigation |
| Move to the beginning of the worksheet | Ctrl+Home | Cmd+Home | Selection & Navigation |
| Move to the end of the worksheet (last used cell) | Ctrl+End | Cmd+End | Selection & Navigation |
| Enter edit mode for active cell | F2 | Control+U | Cell Editing |
| Fill down from cell above | Ctrl+D | Cmd+D | Cell Editing |
| Fill right from cell to the left | Ctrl+R | Cmd+R | Cell Editing |
| Apply bold formatting | Ctrl+B | Cmd+B | Formatting |
| Apply italic formatting | Ctrl+I | Cmd+I | Formatting |
| Apply underline formatting | Ctrl+U | Cmd+U | Formatting |
| Open Format Cells dialog box | Ctrl+1 | Cmd+1 | Formatting |
| Insert current date | Ctrl+; | Cmd+; | Data Entry |
| Insert current time | Ctrl+Shift+; | Cmd+Shift+; | Data Entry |
| Toggle absolute/relative references in formula | F4 | Cmd+T | Formulas |
| Insert a new worksheet | Shift+F11 | Shift+Fn+F11 | Worksheet Management |
| Go to next worksheet | Ctrl+Page Down | Cmd+Page Down | Worksheet Management |
Tips
- Practice regularly: The more you use shortcuts, the more ingrained they become, leading to muscle memory and significant time savings.
- Focus on categories: Instead of trying to learn all shortcuts at once, pick a category you use frequently (e.g., Basic Editing) and master those first.
- Use the Alt key (Windows): On Windows, pressing the Alt key reveals 'Key Tips' on the ribbon, allowing you to navigate menus and commands using only the keyboard.
- Create a 'cheat sheet': Keep a small list of your most-used shortcuts near your workspace for quick reference until they become second nature.
Frequently Asked Questions
How do I see all Microsoft Excel shortcuts?
While there isn't one single 'show all shortcuts' button, you can find comprehensive lists online from Microsoft's official support pages or by searching 'Excel keyboard shortcuts' in your preferred search engine. For Windows users, pressing Alt will reveal Key Tips on the ribbon, guiding you through menu shortcuts.
Can I customise Microsoft Excel shortcuts?
Yes, to a limited extent. In Excel for Windows, you can customize the Quick Access Toolbar (QAT) to add commands and assign keyboard shortcuts to them. For more advanced customization, you might need to use VBA (Visual Basic for Applications) to create macros and assign shortcuts to those macros. Mac users have fewer direct customization options for built-in shortcuts but can use macOS system preferences to create custom keyboard shortcuts for menu commands.