Excel Shortcuts Cheat Sheet: The Complete Guide to Working Faster
If you spend hours every day clicking through Excel’s ribbon menus, you’re leaving a huge amount of time on the table. Keyboard shortcuts are one of the simplest ways to dramatically speed up your workflow in Excel, whether you’re formatting cells, navigating massive spreadsheets, entering formulas, or managing entire workbooks. The problem is that Excel has hundreds of shortcuts, and most people only ever learn a handful of the most basic ones like Ctrl+C and Ctrl+V.
In this guide, we’ve put together a comprehensive Excel shortcuts cheat sheet covering navigation, formatting, formulas, data selection, and workbook management, with separate shortcuts listed for both Windows and Mac. Whether you’re a beginner looking to speed up basic tasks or an advanced user wanting to shave seconds off repetitive actions, this cheat sheet is designed to be a reference you can come back to again and again.
Why Learning Excel Shortcuts Is Worth Your Time
It might seem like a small thing, but the time saved by using shortcuts adds up significantly over weeks and months of regular spreadsheet work. Reaching for the mouse to click through menus for formatting, navigation, or basic edits interrupts your flow and slows down your thinking process. Shortcuts let you keep your hands on the keyboard, which not only speeds up individual actions but also reduces the mental context-switching that happens every time you move between the keyboard and mouse.
Beyond speed, shortcuts also reduce repetitive strain from constant mouse movement, something that matters if you’re working in Excel for extended periods throughout the day.
Basic Navigation Shortcuts
Getting around a large spreadsheet quickly is one of the most valuable skills you can build in Excel, especially when working with datasets containing thousands of rows.
| Action | Windows | Mac |
|---|---|---|
| Move to the beginning of a row | Home | Home |
| Move to the beginning of the worksheet | Ctrl + Home | Cmd + Home (Fn + Left on some Macs) |
| Move to the last used cell | Ctrl + End | Cmd + End (Fn + Right on some Macs) |
| Move one screen up/down | Page Up / Page Down | Page Up / Page Down |
| Move one screen right/left | Alt + Page Down / Alt + Page Up | Option + Page Down / Option + Page Up |
| Jump to the edge of a data region | Ctrl + Arrow Key | Cmd + Arrow Key |
| Switch between worksheet tabs | Ctrl + Page Down / Ctrl + Page Up | Option + Right / Option + Left (Fn + Ctrl + arrows also work) |
| Open the Go To dialog box | F5 or Ctrl + G | Cmd + Fn + F5 |
Selection Shortcuts
Selecting data efficiently is often just as important as navigation, especially when applying formatting or formulas to specific ranges.
| Action | Windows | Mac |
|---|---|---|
| Select an entire row | Shift + Space | Shift + Space |
| Select an entire column | Ctrl + Space | Ctrl + Space |
| Select the entire worksheet | Ctrl + A | Cmd + A |
| Extend selection to the last used cell | Ctrl + Shift + End | Cmd + Shift + End |
| Extend selection to the beginning of the worksheet | Ctrl + Shift + Home | Cmd + Shift + Home |
| Select a contiguous range using arrow keys | Shift + Arrow Key | Shift + Arrow Key |
| Select non-adjacent cells or ranges | Ctrl + Click | Cmd + Click |
| Extend selection to the edge of a data region | Ctrl + Shift + Arrow Key | Cmd + Shift + Arrow Key |
Formatting Shortcuts
Applying consistent formatting quickly makes your spreadsheets more readable and professional-looking without slowing down your workflow.
| Action | Windows | Mac |
|---|---|---|
| Bold text | Ctrl + B | Cmd + B |
| Italicize text | Ctrl + I | Cmd + I |
| Underline text | Ctrl + U | Cmd + U |
| Open the Format Cells dialog | Ctrl + 1 | Cmd + 1 |
| Apply currency format | Ctrl + Shift + 4 | Cmd + Shift + 4 |
| Apply percentage format | Ctrl + Shift + 5 | Cmd + Shift + 5 |
| Apply general number format | Ctrl + Shift + 1 | Cmd + Shift + 1 |
| Add borders around selected cells | Ctrl + Shift + 7 | Cmd + Option + 0 |
| Remove all borders | Ctrl + Shift + Underscore (_) | Cmd + Option + Minus (-) |
| Wrap text within a cell | Alt + H, W | Cmd + Option + W (varies by version) |
| Copy formatting only (Format Painter) | Ctrl + Shift + C, then Ctrl + Shift + V | Cmd + Shift + C, then Cmd + Shift + V |
Formula and Function Shortcuts
Since formulas are at the core of most Excel work, these shortcuts can significantly speed up how quickly you build and troubleshoot calculations.
| Action | Windows | Mac |
|---|---|---|
| Insert the AutoSum function | Alt + = | Cmd + Shift + T |
| Toggle between formula view and value view | Ctrl + ` (grave accent) | Cmd + ` |
| Insert a function | Shift + F3 | Shift + Fn + F3 |
| Calculate all worksheets in all open workbooks | F9 | Fn + F9 |
| Insert the current date | Ctrl + ; (semicolon) | Cmd + ; |
| Insert the current time | Ctrl + Shift + ; (semicolon) | Cmd + Shift + ; |
| Toggle absolute/relative references (add $ signs) | F4 | Cmd + T |
| Enter a formula as an array formula | Ctrl + Shift + Enter | Cmd + Shift + Enter |
| Edit the active cell | F2 | Ctrl + U or Fn + F2 |
Data Entry and Editing Shortcuts
Small time savings during data entry compound quickly when you’re working with large volumes of information.
| Action | Windows | Mac |
|---|---|---|
| Fill down (copy the cell above) | Ctrl + D | Cmd + D |
| Fill right (copy the cell to the left) | Ctrl + R | Cmd + R |
| Insert a new row | Ctrl + Plus (+) | Cmd + Plus (+) |
| Delete the selected row/column | Ctrl + Minus (-) | Cmd + Minus (-) |
| Undo the last action | Ctrl + Z | Cmd + Z |
| Redo the last undone action | Ctrl + Y | Cmd + Y |
| Insert a new comment/note | Shift + F2 | Fn + Shift + F2 |
| Delete cell contents | Delete key | Delete key |
| Repeat the last action | F4 | Cmd + Y |
| AutoComplete a formula or entry | Tab | Tab |
Workbook and File Management Shortcuts
Managing files and worksheets efficiently reduces the friction of switching between multiple projects.
| Action | Windows | Mac |
|---|---|---|
| Create a new workbook | Ctrl + N | Cmd + N |
| Save the current workbook | Ctrl + S | Cmd + S |
| Print the current worksheet | Ctrl + P | Cmd + P |
| Close the current workbook | Ctrl + W | Cmd + W |
| Insert a new worksheet | Shift + F11 | Shift + Fn + F11 |
| Switch between open workbooks | Ctrl + Tab | Cmd + Backtick (`) |
Filtering and Sorting Shortcuts
Quickly organizing your data helps you find exactly what you need without manually scrolling through long lists.
| Action | Windows | Mac |
|---|---|---|
| Apply a filter to the selected range | Ctrl + Shift + L | Cmd + Shift + F |
| Sort ascending (with a column selected) | Alt + A, S, A | Data menu > Sort Ascending |
| Group selected rows or columns | Alt + Shift + Right Arrow | Cmd + Shift + K |
| Ungroup selected rows or columns | Alt + Shift + Left Arrow | Cmd + Shift + J |
PivotTable and Chart Shortcuts
For anyone who frequently builds reports, these shortcuts can save considerable time when working with summarized data.
| Action | Windows | Mac |
|---|---|---|
| Create a PivotTable from selected data | Alt + N, V | Insert menu > PivotTable |
| Insert a recommended chart | Alt + F1 | Fn + Option + F1 |
| Insert a chart on a new sheet | F11 | Fn + F11 |
| Refresh a PivotTable | Alt + F5 | Cmd + Option + F5 |
Pro Tips for Getting the Most Out of Excel Shortcuts
- Start with just five shortcuts and build from there. Trying to memorize the entire cheat sheet at once rarely sticks. Pick the shortcuts most relevant to your daily tasks, such as Ctrl+D for fill down or Ctrl+1 for Format Cells, and practice those until they become automatic before adding more.
- Use the F4 key constantly when writing formulas. Toggling between relative and absolute references with F4 (Windows) or Cmd+T (Mac) is one of the most underused shortcuts, yet it saves significant time when building formulas that need to be copied across multiple cells.
- Combine Alt key sequences for ribbon access on Windows. Pressing Alt on Windows reveals small letter labels over every ribbon command, letting you access virtually any menu option without touching your mouse, even for less common features that don’t have a dedicated shortcut.
- Customize your own shortcuts using the Quick Access Toolbar. If there’s a command you use often that doesn’t have a built-in shortcut, adding it to the Quick Access Toolbar assigns it a number you can trigger with Alt (Windows) plus that number.
- Print this cheat sheet or keep it pinned nearby. Muscle memory develops through repetition, and having a physical or digital reference nearby during your first few weeks of practice speeds up the learning curve considerably.
- Practice with a dedicated test spreadsheet. Rather than risking mistakes in an important work file, spend 10–15 minutes practicing new shortcuts in a blank spreadsheet until they feel natural.
Common Shortcut Mistakes to Avoid
- Forgetting that Mac and Windows shortcuts aren’t always identical. Many shortcuts translate directly from Ctrl to Cmd, but others, like toggling absolute references (F4 on Windows versus Cmd+T on Mac), are completely different keys, which can trip up users switching between platforms.
- Overwriting existing keyboard shortcuts with custom ones. If you’re using Excel add-ins or custom macros, double-check that a new shortcut assignment doesn’t conflict with an existing one you rely on elsewhere.
- Relying only on mouse-based Undo instead of Ctrl+Z. It’s a small habit, but consistently using Ctrl+Z (or Cmd+Z) instead of clicking the Undo icon keeps your hands on the keyboard and reinforces shortcut muscle memory over time.
- Not checking whether Function key shortcuts require Fn on your specific keyboard. Many laptops require holding the Fn key alongside F-row shortcuts like F2, F4, or F9, which can cause confusion if a shortcut doesn’t seem to work as expected.
Conclusion
Learning Excel shortcuts isn’t about memorizing every single key combination overnight, it’s about gradually replacing your most repetitive mouse actions with quick, deliberate keystrokes until they become second nature. Whether you’re navigating a massive dataset, applying consistent formatting, building formulas, or managing multiple worksheets, the shortcuts covered in this cheat sheet span nearly every core Excel task you’re likely to perform on a regular basis.
Start small, focus on the shortcuts most relevant to your specific workflow, whether that’s data entry, formula building, or formatting, and build outward from there. Over time, you’ll find that tasks which once took several clicks through ribbon menus become nearly instant, freeing up more of your time and mental energy for the actual analysis and decision-making that spreadsheets are meant to support.
Frequently Asked Questions
Not always. Many core shortcuts like Ctrl+C, Ctrl+V, and Ctrl+Z work identically in Excel Online, but some advanced shortcuts, particularly those involving PivotTables, macros, or certain formatting options, may not be available or may require different key combinations in the browser-based version.
2. Why do some of my keyboard shortcuts not work on my laptop? This usually happens when a laptop’s Function (Fn) key setting requires you to hold Fn alongside F-row keys like F2, F4, or F11 for them to register as their intended Excel shortcut rather than a system-level function like volume or brightness control.
3. Can I create my own custom keyboard shortcuts in Excel? Yes, primarily through recording a macro and assigning it a custom shortcut key, or by adding frequently used commands to the Quick Access Toolbar, which then become accessible using Alt plus a number on Windows.
4. What’s the fastest way to learn Excel shortcuts without feeling overwhelmed? Focus on five to ten shortcuts directly relevant to your most repeated daily tasks, and practice them consistently for a week or two before adding more, rather than trying to memorize an entire reference sheet at once.
5. Is there a difference between Ctrl+1 and right-clicking to access Format Cells? No, both methods open the exact same Format Cells dialog box; Ctrl+1 (or Cmd+1 on Mac) simply skips the right-click menu and gets you there faster.
6. Do these shortcuts work the same way in Google Sheets? Some do, particularly universal ones like Ctrl+B for bold or Ctrl+C/Ctrl+V for copy and paste, but many Excel-specific shortcuts, especially those involving PivotTables, Power Query, or advanced formula shortcuts, don’t have a direct equivalent in Google Sheets.
7. Why does F4 sometimes repeat my last action instead of toggling cell references? F4 serves two different purposes depending on context: while editing a formula, it toggles between relative and absolute references, but outside of formula editing mode, it repeats your last action, such as a formatting change or inserted row.
8. Are there paid tools or add-ins that offer more advanced shortcut customization? Yes, several third-party add-ins, such as ASAP Utilities (around $40 USD/₹3,300 one-time license) and various macro-based toolkits, offer expanded shortcut customization and additional productivity commands beyond what Excel provides natively, though most users find Excel’s built-in shortcuts and Quick Access Toolbar customization sufficient for everyday work.
