If you use Microsoft Excel regularly, you probably know the feeling: you start with one small task, click through several menus, and suddenly five minutes have disappeared. Keyboard shortcuts can change that.
This Excel shortcuts cheat sheet brings together more than 100 useful Excel keyboard shortcuts for Windows and Mac. They cover everyday tasks such as copying data, moving around a worksheet, formatting cells, entering formulas, selecting ranges, managing worksheets, and working with data.
Microsoft confirms that keyboard shortcuts can help users perform commands without relying on a mouse, although some shortcuts can vary by platform, keyboard layout, and Excel version.
What Is an Excel Shortcuts Cheat Sheet?
An Excel shortcuts cheat sheet is a quick reference list of keyboard combinations that help you perform common Excel tasks faster.
Instead of opening menus or searching through the ribbon, you press a few keys to complete an action. For example, Ctrl + C copies selected content on Windows, while Command + C performs the same basic action on Mac.
Excel is a spreadsheet application developed by Microsoft and is available across Windows, macOS, mobile platforms, and the web.
The shortcuts below focus on practical commands that are useful for students, office workers, accountants, analysts, business owners, and anyone who spends time working with spreadsheets.
Why Is an Excel Shortcuts Cheat Sheet Important?
Learning shortcuts can make repetitive Excel work much easier.
Imagine you are preparing a report with 500 rows of sales data. You need to select a column, format numbers, find a customer, insert a formula, and move between worksheets.
Doing everything with a mouse works, but repeating those actions dozens of times becomes slow.
With keyboard shortcuts, many of these tasks can be completed in seconds.
Main benefits include:
- Faster navigation through large worksheets
- Less mouse usage during repetitive work
- Quicker data entry and editing
- Faster formatting
- Easier formula management
- Better productivity
- More efficient spreadsheet analysis
- Improved workflow for financial and business models
Keyboard shortcuts can also be useful for accessibility because they provide an alternative to mouse-based commands. Microsoft specifically notes this benefit for Microsoft 365 applications.
100+ Excel Keyboard Shortcuts for Windows & Mac
The following Excel shortcuts cheat sheet is divided into practical categories so you can find what you need quickly.
Shortcut note: Windows commonly uses Ctrl, Alt, and F-keys, while Mac commonly uses Command (⌘), Option (⌥), and Control (⌃). Some shortcuts differ between platforms and Excel versions. Microsoft also notes that its Mac shortcuts refer to a US keyboard layout.
1. Basic Excel Shortcuts
| Action | Windows | Mac |
| New workbook | Ctrl + N | Command + N |
| Open workbook | Ctrl + O | Command + O |
| Save workbook | Ctrl + S | Command + S |
| Ctrl + P | Command + P | |
| Close workbook | Ctrl + W | Command + W |
| Undo | Ctrl + Z | Command + Z |
| Redo/repeat | Ctrl + Y | Command + Y |
| Cut | Ctrl + X | Command + X |
| Copy | Ctrl + C | Command + C |
| Paste | Ctrl + V | Command + V |
| Find | Ctrl + F | Command + F |
| Select all | Ctrl + A | Command + A |
| Insert hyperlink | Ctrl + K | Command + K |
| Cancel action | Esc | Esc |
| Help | F1 | F1 |
These basic shortcuts are worth learning first because you will use them in almost every Excel session.
Microsoft’s official Mac shortcut documentation confirms common commands such as Command + N, Command + O, Command + S, Command + P, Command + Z, Command + C, Command + V, and Command + F.
2. Excel Navigation Shortcuts
Moving around a large spreadsheet can be frustrating when you constantly scroll with the mouse.
These shortcuts help you move quickly:
| Action | Windows | Mac |
| Move one cell | Arrow keys | Arrow keys |
| Move to beginning of row | Home | Fn + Left Arrow |
| Move to last used cell | Ctrl + End | Command + End |
| Move to first cell | Ctrl + Home | Control + Home |
| Move down one screen | Page Down | Page Down |
| Move up one screen | Page Up | Page Up |
| Move right one screen | Alt + Page Down | Option + Page Down |
| Move left one screen | Alt + Page Up | Option + Page Up |
| Move to edge of data region | Ctrl + Arrow | Command + Arrow |
| Move between worksheets | Ctrl + Page Up/Down | Option + Left/Right Arrow |
For large datasets, Ctrl + Arrow on Windows is particularly useful because it lets you jump toward the edge of a continuous data region instead of scrolling row by row.
3. Selection Shortcuts
Selecting the correct range is an important part of Excel work.
| Action | Windows | Mac |
| Select entire column | Ctrl + Space | Control + Space |
| Select entire row | Shift + Space | Shift + Space |
| Extend selection | Shift + Arrow | Shift + Arrow |
| Select to edge of data | Ctrl + Shift + Arrow | Command + Shift + Arrow |
| Select to beginning | Ctrl + Shift + Home | Command + Shift + Home |
| Select to end | Ctrl + Shift + End | Command + Shift + End |
| Select current data region | Ctrl + A | Command + A |
| Select worksheet | Ctrl + A | Command + A |
When working with thousands of rows, selecting a data region with keyboard commands can save a surprising amount of time.
4. Excel Editing Shortcuts
These Excel keyboard shortcuts are useful when entering or changing information.
| Action | Windows | Mac |
| Edit active cell | F2 | Control + U |
| Delete selected content | Delete | Delete |
| Complete cell entry | Enter | Return |
| Cancel cell entry | Esc | Esc |
| Move to next cell | Tab | Tab |
| Move to previous cell | Shift + Tab | Shift + Tab |
| Insert current date | Ctrl + ; | Control + ; |
| Insert current time | Ctrl + Shift + ; | Command + ; |
| Repeat last action | F4 | Command + Y |
| Copy formula/data down | Ctrl + D | Control + D |
| Copy formula/data right | Ctrl + R | Control + R |
The F2 shortcut is especially useful when editing formulas or correcting text inside a cell without replacing the entire cell contents.
5. Excel Formatting Shortcuts
Formatting does not have to mean repeatedly opening the ribbon.
| Action | Windows | Mac |
| Bold | Ctrl + B | Command + B |
| Italic | Ctrl + I | Command + I |
| Underline | Ctrl + U | Command + U |
| Format Cells | Ctrl + 1 | Command + 1 |
| Apply general format | Ctrl + Shift + ~ | Control + Shift + ~ |
| Apply number format | Ctrl + Shift + 1 | Control + Shift + 1 |
| Apply time format | Ctrl + Shift + 2 | Control + Shift + 2 |
| Apply date format | Ctrl + Shift + 3 | Control + Shift + 3 |
| Apply currency format | Ctrl + Shift + 4 | Control + Shift + 4 |
| Apply percentage format | Ctrl + Shift + 5 | Control + Shift + 5 |
| Apply scientific format | Ctrl + Shift + 6 | Control + Shift + 6 |
| Apply border | Ctrl + Shift + 7 | Command + Option + 0 |
For everyday reporting, Ctrl/Command + 1 is one of the most useful shortcuts because it opens the Format Cells dialog.
6. Formula and Calculation Shortcuts
Formulas are at the heart of Excel, and shortcuts can make formula-heavy work much faster.
| Action | Windows | Mac |
| Start a formula | = | = |
| AutoSum | Alt + = | Command + Shift + T |
| Show formulas | Ctrl + ` | Control + ` |
| Calculate workbook | F9 | F9 |
| Calculate active worksheet | Shift + F9 | Shift + F9 |
| Recalculate everything | Ctrl + Alt + F9 | Control + Option + F9 |
| Insert function | Shift + F3 | Shift + F3 |
| Toggle absolute reference | F4 | Command + T |
| Copy formula down | Ctrl + D | Control + D |
| Copy formula right | Ctrl + R | Control + R |
For example, if you are building a monthly budget, you can enter a SUM formula and then use the appropriate fill shortcut to apply the formula across a range rather than typing it repeatedly.
7. Data Management Shortcuts
Excel is often used to sort, filter, clean, and analyze information.
| Action | Windows | Mac |
| Create table | Ctrl + T | Command + T |
| Toggle filters | Ctrl + Shift + L | Command + Shift + F |
| Open filter menu | Alt + Down Arrow | Option + Down Arrow |
| Flash Fill | Ctrl + E | Control + E |
| Insert cells | Ctrl + Shift + + | Control + Shift + + |
| Delete cells | Ctrl + – | Command + – |
| Insert row/column | Ctrl + Shift + + | Control + Shift + + |
| Delete row/column | Ctrl + – | Command + – |
| Paste Special | Ctrl + Alt + V | Command + Control + V |
| Refresh data | Ctrl + Alt + F5 | Command + Option + F5 |
Flash Fill can be particularly useful when Excel recognizes a pattern. For example, if you have full names in one column and manually create the first few first-name examples in another column, Flash Fill may recognize the pattern and complete the remaining entries.
8. Worksheet Shortcuts
When a workbook contains multiple sheets, keyboard navigation becomes even more useful.
| Action | Windows | Mac |
| Insert worksheet | Shift + F11 | Shift + F11 |
| Move to next sheet | Ctrl + Page Down | Option + Right Arrow |
| Move to previous sheet | Ctrl + Page Up | Option + Left Arrow |
| Move/copy worksheet | Alt + H, O, M | Use sheet menu |
| Select multiple sheets | Ctrl + click tabs | Command + click tabs |
| Rename selected sheet | Alt + O, H, R | Use sheet menu |
| Hide selected sheet | Alt + H, O, U, H | Use sheet menu |
| Unhide sheet | Alt + H, O, U, U | Use sheet menu |
Some ribbon sequences are platform-specific, so Mac users should check the current Excel commands available in their version.
9. Row and Column Shortcuts
Rows and columns are much easier to manage when you know a few simple commands.
| Action | Windows | Mac |
| Select column | Ctrl + Space | Control + Space |
| Select row | Shift + Space | Shift + Space |
| Insert row/column | Ctrl + Shift + + | Control + Shift + + |
| Delete row/column | Ctrl + – | Command + – |
| Hide selected rows | Ctrl + 9 | Command + 9 |
| Hide selected columns | Ctrl + 0 | Command + 0 |
| Unhide rows | Ctrl + Shift + 9 | Command + Shift + 9 |
| Unhide columns | Ctrl + Shift + 0 | Command + Shift + 0 |
These shortcuts become especially helpful when cleaning reports or preparing worksheets for presentation.
10. Find, Search, and Review Shortcuts
Finding information manually in a large spreadsheet wastes time.
Use:
- Ctrl + F / Command + F — Find text or values
- Ctrl + H — Find and Replace on Windows
- Command + Shift + H — Find and Replace on supported Mac versions
- Ctrl + G — Go To
- F5 — Go To dialog in supported Windows versions
- Ctrl + A / Command + A — Select current region or all data depending on context
- Esc — Close or cancel a search-related action
The best shortcut here is often simply Ctrl + F or Command + F. If a workbook has hundreds or thousands of records, searching is much faster than scanning the worksheet.
11. Useful Advanced Excel Shortcuts
Once you are comfortable with the basics, these shortcuts can improve more advanced workflows:
- Ctrl + Shift + L — Turn filters on or off
- Ctrl + T — Create a table
- Ctrl + E — Flash Fill
- Ctrl + Shift + $ — Currency format
- Ctrl + Shift + % — Percentage format
- Ctrl + Shift + # — Date format
- Ctrl + Shift + @ — Time format
- Ctrl + Shift + ! — Number format
- Ctrl + Shift + ^ — Scientific format
- Ctrl + Shift + & — Apply outline border
- Ctrl + Shift + _ — Remove outline border
- Ctrl + Shift + “ — Copy value from cell above
- Ctrl + ‘ — Copy formula from cell above
- Alt + = — Insert AutoSum
- Ctrl + Shift + Enter — Enter an array formula in versions where this behavior applies
Shortcut behavior can change with Excel versions and operating systems, so Microsoft recommends checking the shortcut documentation for the specific Excel environment you use.
How to Learn Excel Shortcuts Quickly
You do not need to memorize all 100+ shortcuts at once.
A better approach is to learn them in groups.
Step 1: Learn the everyday shortcuts
Start with:
- Copy
- Paste
- Cut
- Undo
- Redo
- Save
- Find
- Select All
Step 2: Learn navigation
Next, practice:
- Ctrl/Command + Arrow
- Ctrl/Command + Home
- Ctrl/Command + End
- Page Up
- Page Down
- Worksheet navigation
Step 3: Learn formatting
Add:
- Bold
- Italic
- Underline
- Format Cells
- Currency
- Percentage
- Date
Step 4: Learn data shortcuts
Finally, learn:
- Filters
- Tables
- Flash Fill
- Paste Special
- Insert/delete rows and columns
The goal is not to remember every shortcut. The goal is to make your most common Excel tasks feel automatic.
Why Keyboard Shortcuts Can Make Excel Faster
The biggest advantage of Excel shortcuts is not that every command saves a huge amount of time.
It is the repetition.
If you save only two seconds each time you perform an action and repeat that action 100 times, you have already saved more than three minutes. Across a week or month, small improvements can add up.
For analysts, accountants, students, administrators, and other frequent Excel users, shortcuts can become part of a natural workflow.
Common Excel Shortcut Mistakes to Avoid
Not every shortcut works identically on every system.
Keep these points in mind:
- Check your platform. Windows and Mac use different modifier keys for many commands.
- Check your keyboard layout. Microsoft notes that Mac shortcut documentation is based on a US keyboard layout.
- Check your Excel version. Some newer functions and commands may not exist in older versions.
- Watch for add-ins. Office add-ins can register keyboard shortcuts and may create conflicts.
- Do not memorize everything. Focus first on shortcuts that match your daily tasks.
For additional background about Excel itself, you can also explore the Microsoft Excel Wikipedia page.
FAQs
What is the most useful Excel shortcut?
For many users, Ctrl + C, Ctrl + V, Ctrl + Z, Ctrl + F, Ctrl + S, and Ctrl + Arrow are among the most useful Windows shortcuts. On Mac, the corresponding common commands generally use Command instead of Ctrl. The best shortcut depends on the tasks you perform most often.
What is the shortcut for AutoSum in Excel?
On Windows, Alt + = inserts AutoSum. It is a quick way to create a SUM formula for a nearby range of numbers. Mac behavior can differ by Excel version, so users should verify the current Mac shortcut for their installation.
What is the shortcut for copying and pasting in Excel?
On Windows, use Ctrl + C to copy and Ctrl + V to paste. On Mac, use Command + C and Command + V. These are among the most frequently used Excel keyboard shortcuts.
How do I select an entire column in Excel?
On Windows, press Ctrl + Space to select the current column. On Mac, Control + Space can perform the same function in supported Excel configurations.
How do I quickly find something in Excel?
Press Ctrl + F on Windows or Command + F on Mac to open the Find function. Type the word, number, or phrase you want to locate, then search through the worksheet.
Are Excel shortcuts the same on Windows and Mac?
No. Many commands have equivalent shortcuts, but the keys can differ. Windows often uses Ctrl and Alt, while Mac commonly uses Command and Option. Some shortcuts also vary by Excel version and keyboard layout.
How many Excel shortcuts should I learn?
You do not need to memorize all 100+ shortcuts in this guide. Start with around 10–20 shortcuts that match your daily work. Once those become natural, add shortcuts for formatting, navigation, formulas, and data management.
Conclusion
A good Excel shortcuts cheat sheet is more than a list of keyboard combinations. It is a practical reference that helps you replace repetitive mouse movements with faster keyboard commands.
Start with the basics: copy, paste, undo, save, find, navigation, and selection. Then move into formatting, formulas, data management, and worksheet shortcuts.
You do not have to become an Excel shortcut expert overnight. Pick five shortcuts today, use them repeatedly, and add five more when you are comfortable.
Over time, those small keyboard habits can turn a slow Excel workflow into a much smoother one.
