Every second counts when you’re working in Microsoft Excel. Reaching for the mouse to perform simple tasks may seem harmless, but those extra clicks quickly add up, reducing productivity and interrupting your workflow. Whether you’re organizing data, creating reports, or analyzing spreadsheets, knowing the right keyboard shortcuts can significantly improve your speed and efficiency. Why Excel shortcuts matter becomes clear once you realize they help you complete tasks faster, minimize errors, and make working in Excel more comfortable. In this guide, you’ll discover the most useful Excel shortcut keys that can help you work smarter and become more productive.
Key Tip: The US keyboard layout is assumed here. If you use a different layout, some symbols/keys may vary. We focus on Excel 2019, 2021, 2024, and Microsoft 365 (Office 365) for Windows and Mac. (Older versions are similar; differences are noted below.)
Must Know Shortcuts (Windows vs Mac)
The most common actions have almost identical shortcuts on Windows and Mac—except that the Ctrl key on Windows corresponds to the Command (⌘) key on Mac. Some examples:
- File Actions: New (Win: Ctrl+N; Mac: ⌘+N), Open (Ctrl+O; ⌘+O), Save (Ctrl+S; ⌘+S), Close (Ctrl+W; ⌘+W).
- Clipboard: Copy (Ctrl+C; ⌘+C), Cut (Ctrl+X; ⌘+X), Paste (Ctrl+V; ⌘+V). These are the most-used shortcuts – you’ll likely use them many times a day.
- Undo/Redo: Undo (Ctrl+Z; ⌘+Z), Redo (Ctrl+Y; ⌘+Y). (Tip: On Mac,
⌘+YorControl+Yboth redo, depending on your settings.) - Find/Go To: Find (Ctrl+F; Mac: ⌘+F), Go To (Ctrl+G or F5; Mac: Fn+F5 or Control+G). These open the search and the “Go To” dialog, respectively.
- Navigation: Move around cells with arrow keys; jump to sheet edges with Ctrl+Arrow (Win) or ⌘+Arrow (Mac). Go to first/last cell in sheet with Ctrl+Home / Ctrl+End (Win) or Control+Home / Control+End (Mac).
- Row/Column Selection: Select a row with Shift+Space, a column with Ctrl+Space.
- Formulas: Edit cell (F2), repeat last action (F4 or Ctrl+Y), insert function (Shift+F3), toggle formulas (Ctrl+
on Win, Control+on Mac). - Formatting: Bold (Ctrl+B or ⌘+B), Italic (Ctrl+I; ⌘+I), Underline (Ctrl+U; ⌘+U). Format cells dialog (Ctrl+1; ⌘+1) is a powerhouse for number formats, alignment, fonts, borders, etc.
- Data Entry: New line in cell (Alt+Enter on Win, Control+Option+Return on Mac), Insert current date (Ctrl+; on both Win and Mac), Insert current time (Ctrl+Shift+; on Win, ⌘+; on Mac).
These are a few examples; the chart below lists many more. (On Mac laptops, remember to hold the Fn key with function shortcuts if needed, e.g. Fn+F5 for “Go To” or Fn+F11 for New Sheet.)
Comprehensive Shortcut Chart (Windows and macOS)
The table below summarizes essential Excel shortcuts for both Windows and Mac (Excel 365/2019+). Each row shows the action and the keys (for Windows PC vs Mac). An asterisk (*) indicates shortcuts that conflict with default Mac OS keys or need special settings (see notes).
EXCEL SHORTCUT KEYS
| ACTION | WINDOWS SHORTCUT | MAC SHORTCUT |
|---|---|---|
| New workbook | Ctrl + N | ⌘ + N |
| Open workbook | Ctrl + O | ⌘ + O |
| Save | Ctrl + S | ⌘ + S |
| Save As | F12,Ctrl + Shift + S | Fn + Shift + F12 |
| Close workbook | Ctrl + W | ⌘ + W |
| Ctrl + P | ⌘ + P | |
| Undo | Ctrl + Z | ⌘ + Z |
| Redo/Repeat | Ctrl + Y or F4 | ⌘ + Y or ⌘ + Shift + Z |
| Copy | Ctrl + C | ⌘ + C |
| Cut | Ctrl + X, | ⌘ + X |
| Paste | Ctrl + V | ⌘ + V |
| Paste Special | Ctrl + Alt + V | ⌘ + Control + V or ⌘ + Option + V |
| Find (search) | Ctrl + F | ⌘ + F |
| Replace | Ctrl + H | ⌘ + Shift + H |
| Select All | Ctrl + A | ⌘ + A |
| Format Cells dialog | Ctrl + 1 | ⌘ + 1 |
| Bold | Ctrl + B | ⌘ + B |
| Italic | Ctrl + I | ⌘ + I |
| Underline | Ctrl + U | ⌘ + U |
| Center align (Ribbon) | Alt + H, A, C | ⌘ + E |
| Open Ribbon Search | Alt + Q | ⌘ + Option + F |
| AutoSum (sum range) | Alt + = | ⌘ + Shift + T |
| Fill Down (copy above) | Ctrl + D | ⌘ + D |
| Fill Right (copy left) | Ctrl + R | ⌘ + R |
| Insert function | Shift + F3 | Shift + Fn + F3 |
| Go To (dialog) | F5 | Fn + F5 or Ctrl + G |
| Insert current date | Ctrl + ; | Control + ; |
| Insert current time | Ctrl + Shift + ; | ⌘ + ; |
| Toggle filter | Ctrl + Shift + L | ⌘ + Shift + F |
| Freeze top row | Alt + W, F, R | ⌘ + Shift + K (choose View menu) |
| Freeze first col | Alt + W, F, C | ⌘ + Shift + L (choose View menu) |
| Add borders | Alt + H, B, A | Ctrl + Option + 0 |
| Clear cell contents | Delete,⌦ | (Fn + Delete on MacBook) |
| Delete row | Ctrl + -, or Alt + H, D, R | ⌘ + - (minus) or use menu |
| Delete column | Ctrl + 0 | ⌘ + 0 |
| Hide row | Ctrl + 9 | ⌘ + 9 |
| Hide column | Ctrl + 0 | ⌘ + 0 |
| Next sheet | Ctrl + PgDn | Control + Page Down (or ⌘ + PgDn) |
| Previous sheet | Ctrl + PgUp | Control + Page Up (or ⌘ + PgUp) |
| Next workbook | Ctrl + Tab | ⌘ + ` (switch tabs) |
| Previous workbook | Ctrl + Shift + Tab | ⌘ + Shift + ` |
| Spell check | F7 | Fn + F7 |
| Insert or edit comment | Shift + F2 | ⌘ + Shift + Fn + F2 |
| Open VBA (Editor) | Alt + F11 | ⌥ + F11 or ⌥ + Fn + F11 |
| Toggle formulas (show formulas) | Ctrl + ` | Control + ` |
| Zoom In/Out | Alt + W, Q, then % | Cmd+Plus/Minus (macOS) |
Notes: This chart is based on US keyboard shortcuts (other layouts may differ). Mac shortcuts use the Command (⌘) key for most actions. Some shortcuts conflict with macOS defaults (marked above); you may need to adjust System Preferences → Keyboard → Shortcuts to enable them. For example, on a Mac the Insert Sheet shortcut (Shift+F11) is flagged with *, and the Freeze Panes shortcuts involve the View menu rather than Alt sequences. Always refer to Microsoft’s official lists for your exact version.
Top Shortcuts: Examples and Use Cases
Here are brief examples of how some top shortcuts speed up real work:
- Ctrl+C / Ctrl+V (Copy/Paste): Quickly duplicate cells, formulas, or text. Example: Copy a formula from one cell to others by selecting the cell and pressing Ctrl+C, moving to the target range, and pressing Ctrl+V. (In Mac Excel, use ⌘+C / ⌘+V.)
- Alt + = (AutoSum): Summation shortcut. Example: To sum a column of numbers, select the cell at the bottom of the range and hit Alt+= (Windows) or ⌘+Shift+T (Mac). Excel instantly inserts a
SUM()formula. - Ctrl + Z / Ctrl + Y (Undo/Redo): Quickly revert or reapply an action. Example: If you accidentally delete a range, Ctrl+Z undoes it. If you undo too much, Ctrl+Y or F4 redoes.
- Ctrl + F (Find): Instantly search. Example: Open the Find dialog with Ctrl+F (or ⌘+F) and type a value to locate it in your sheet.
- Ctrl + Arrow (Navigation): Jump to data edges. Example: If you’re in a table with empty cells, pressing Ctrl+↓ jumps to the bottom of the current data region.
- Shift + Space / Ctrl + Space: Select entire row or column. Useful for formatting or deleting whole rows.
- Ctrl + 1 (Format Cells): Brings up the Format Cells dialog. Example: Press Ctrl+1, switch to the Number or Alignment tab, and set number formats or text alignment without using the ribbon. On Mac, use ⌘+1.
- Ctrl + D / Ctrl + R (Fill Down/Right): Copy values/formulas from the cell above or left. Example: Enter a formula in the top cell of a column, then select the column and press Ctrl+D to fill it down.
- Ctrl + T (Create Table): Converts a range to an Excel Table. Example: Select any cell in your data and press Ctrl+T (or ⌘+T on Mac) to quickly format it as a table with filters and styling.
- F2 (Edit Cell): Begin editing the active cell’s contents. Example: Press F2 to place the cursor in the formula bar for the selected cell, then type or edit directly.
- Alt + Enter: Insert a new line in a cell (within text). Example: To break an address into lines, type part of the address, then Alt+Enter to continue on a new line within the same cell.
- Freeze Panes (Windows: Alt+W, F, R/C; Mac: use the View menu): Lock headers in place. Example: To keep the top row visible while scrolling, press Alt+W, F, R (Windows). On Mac, go to View > Freeze Panes > Freeze Top Row.
- Ctrl + Shift + L (Filter): Toggle filters on/off. Example: With a header row selected, press Ctrl+Shift+L (or ⌘+Shift+F on Mac) to enable filter drop-downs instantly.
- Shift + F2 (Comment): Insert or edit a comment. Example: Select a cell and press Shift+F2 to add a comment (on Mac: ⌘+Shift+Fn+F2).
- F7 (Spell Check): Check spelling. Example: Run a quick spell-check on your sheet by pressing F7 (on Mac, Fn+F7).
- Alt + H, B, A (Borders – All): Apply borders. Example: Select a range, press Alt+H, B, A to draw all borders. (Use Alt+H, B, S for outline borders.) This works in Windows; on Mac use the ribbon or the Format Cells dialog.
- Alt + H, F, C (Font Color) and Alt + H, H (Fill Color): Quickly set text or background color via shortcut (using the ribbon key tips). For instance, Alt+H, F, C opens the font color menu.
- Ctrl + Up/Down (Move to top/bottom of data): Jump through blocks of data.
- Ctrl + W (Close Workbook): Closes the current file (on Mac: ⌘+W).
- Alt + F11: (Advanced) Open the VBA Editor (on Mac: ⌥+F11). Useful for users working with macros.
Each of these shortcuts should become second nature. The chart above includes many more for navigation, selection, formatting, formulas, and other tasks.
Accessibility and Tips
- Keyboard vs Mouse: Always aim for keyboard shortcuts to minimize mouse use. Remember that on Mac you often use ⌘ instead of Ctrl, and Option instead of Alt. The official Microsoft guide notes this difference (many Mac shortcuts use Command, Control, Option, and Fn).
- Full Keyboard Access (Mac): To ensure all shortcuts work, enable “Full Keyboard Access” in System Settings → Keyboard → Shortcuts. Microsoft notes some Mac shortcuts may require this setting.
- Fn Key (Mac): On MacBooks, you may need to hold Fn to use F1–F12 keys (e.g. Fn+F5 for Go To). Some older Mac laptops have a “Fn Lock” to toggle this.
- Narrator/Screen Readers: For visually impaired users, use Excel’s Accessibility Checker (Review → Check Accessibility) and ensure images/charts have alt text. When describing shortcuts, use unambiguous text (e.g. say “Control C” instead of “Ctrl+C”).
- Sticky Keys: If physically pressing multiple keys is hard, enable Sticky Keys (Windows Ease of Access or Mac Accessibility settings) so you can press keys one at a time.
- Table Accessibility: The shortcut chart above should be accessible to screen readers, but consider providing a simpler text summary of key shortcuts as well.
Printable Shortcut Table (CSV)
For convenience, the chart is also provided above in CSV format (within the code block). You can copy that section into a text file and save as .csv for printing or quick reference. Each column is comma-separated: Action, Windows shortcut, Mac shortcut, Notes. This makes it easy to import into a spreadsheet or distribute as a cheat sheet.
Learning Flowchart
To gradually learn shortcuts, it helps to start with basic tasks and work up to more advanced ones. The mermaid flowchart below outlines a suggested progression:
This diagram suggests learning in layers: first master file commands and basic editing (Copy/Paste/Undo), then learn to move around large sheets and select data, next learn shortcuts for entering and formatting data, then learn formula shortcuts (auto-sum, named ranges), and finally data analysis tools (filters, PivotTables, etc.). Adjust the path based on your needs and Excel version.
Still have questions? Here are answers to some of the most common questions about this topic.
FAQs
Q: Which Excel shortcuts should I learn first as a beginner?
A: Start with the basics: Copy, Cut, Paste (Ctrl+C/X/V), Undo/Redo (Ctrl+Z/Y), Save (Ctrl+S), and Select Row/Column (Shift+Space/Ctrl+Space). These cover everyday tasks. Then add Sum (Alt+=), Format Cells (Ctrl+1), and navigation keys (arrow keys, Ctrl+Arrows).
Q: How do I use the same shortcut on Mac vs Windows?
A: On Mac, use the Command (⌘) key in place of Ctrl and Option (⌥) in place of Alt. For example, copy is ⌘+C on Mac instead of Ctrl+C. Many shortcuts otherwise remain the same; check our chart. If a Mac shortcut isn’t working, ensure Full Keyboard Access is enabled (in System Settings).
Q: Are these shortcuts for all Excel versions?
A: This guide covers Excel 365 and recent versions (2019, 2021, 2024) on Windows and macOS. Most shortcuts are identical across versions. A few older versions may lack newer features (e.g. the “Tell Me” search was called “Search” in newer Office apps). Always refer to your version’s docs for changes. We focused on current releases and noted any version-specific notes in the chart.
Q: Why won’t Alt+W,F,R (Windows) work on my Mac?
A: Excel for Mac does not support Windows-style Alt-key ribbon shortcuts. Instead, use the View menu: go to View → Freeze Panes and choose the option, or customize a Mac shortcut in System Preferences. Many ribbon tasks on Mac require the mouse or a different key combo (e.g. ⌘+Shift+L for filters).
Q: How can I print or share this cheat sheet?
A: The chart above is formatted for printing. You can copy it into Excel or a word processor and print. We also provided a CSV version for download (see the code block). This way, you can have a handy reference or laminate a cheat sheet.
Q: What if a shortcut doesn’t work?
A: First, check if you need Fn (on Mac) or if Num Lock is affecting keys (e.g. numeric keypad use). Second, confirm you’re using the correct modifier (Ctrl vs Cmd). Some programs let you override shortcuts: you can customize shortcuts in Excel Options > Customize Ribbon > Keyboard shortcuts (Windows) or in macOS keyboard preferences. Also ensure your shortcut is supported in your version (macOS Excel lacks some legacy Alt-key shortcuts).
Q: Can I add my own shortcuts?
A: Yes. In Windows Excel, go to File → Options → Customize Ribbon → Keyboard shortcuts to assign custom keys to commands. On Mac, macOS allows custom app shortcuts in System Settings under Keyboard Shortcuts. This is useful for actions you use frequently that lack defaults.
Q: Are there similar shortcuts for Excel Online or mobile?
A: Excel for the web has its own (usually similar) shortcuts; see Microsoft’s documentation. Mobile/tablet versions rely on touch, but external keyboards often work. This guide focuses on desktop Excel, where keyboard shortcuts are most extensive.
Q: What about accessibility – how do shortcuts help?
A: Shortcuts make Excel more accessible by reducing mouse use. For example, a blind user can navigate and edit cells via keyboard and screen reader. Ensure your system’s accessibility settings (like Sticky Keys, Narrator, high-contrast mode) are on if needed. Use descriptive text (e.g. “Control C” instead of “Ctrl+C”) when training others or creating accessible materials. We’ve aimed for clear language and avoided jargon for readability.
Q: Where can I find more Excel tips or help?
A: Visit Microsoft’s official support (e.g. Keyboard Shortcuts in Excel) and forums. Excel community blogs (like those by Excel MVPs) or you can follow up our blogs for further information. Internal resources on your organization’s site (like a knowledge base) might link to related topics (e.g. Excel formulas, data analysis). Always verify with official docs for critical tasks.