---
title: "Microsoft Excel keyboard shortcuts — the full list"
description: "80 Microsoft Excel keyboard shortcuts, grouped by what they do. Windows, macOS and Linux, with the Mac equivalents where they differ."
url: https://atoneplace.net/shortcuts/excel/
site: "At One Place"
---

# Microsoft Excel keyboard shortcuts

**Microsoft Excel keyboard shortcuts: 80 shortcuts**

Windows, macOS and Linux

Microsoft Excel is the desktop spreadsheet. Its Windows and Mac builds diverge more than any other Office app: several Mac bindings keep the Control key instead of moving to Command, and a handful — absolute references, AutoSum, strikethrough, borders — are different keys entirely, so the Mac form is spelled out wherever it is not a plain Ctrl to Command swap.

## Navigation

| Shortcut | What it does |
| --- | --- |
| Ctrl/⌘ + Arrow key | Jump to the edge of the data region |
| Home | Move to the beginning of the row |
| Ctrl + Home | Move to the beginning of the worksheet — On macOS: ⌃ + Home |
| Ctrl + End | Move to the last used cell on the worksheet — On macOS: ⌃ + End |
| Page Down | Move one screen down |
| Page Up | Move one screen up |
| Alt + Page Down | Move one screen to the right — On macOS: ⌥ + Page Down |
| Alt + Page Up | Move one screen to the left — On macOS: ⌥ + Page Up |
| F5 | Open the Go To dialog — On macOS: ⌃ + G |
| Ctrl/⌘ + F | Open the Find dialog |

## Selection

| Shortcut | What it does |
| --- | --- |
| Shift + Arrow key | Extend the selection by one cell |
| Ctrl/⌘ + Shift + Arrow key | Extend the selection to the last non-blank cell |
| Ctrl + Shift + Home | Extend the selection to the start of the worksheet — On macOS: ⌃ + ⇧ + Home |
| Ctrl + Shift + End | Extend the selection to the last used cell — On macOS: ⌃ + ⇧ + End |
| Ctrl + Spacebar | Select the entire column — On macOS: ⌃ + Space |
| Shift + Spacebar | Select the entire row |
| Ctrl/⌘ + A | Select the current region, then the whole worksheet |
| F8 | Turn extend-selection mode on or off |
| Shift + F8 | Add a non-adjacent range to the selection |
| Ctrl + Shift + Spacebar | Select every object on the worksheet — On macOS: ⌘ + ⇧ + Space |

## Editing and data entry

| Shortcut | What it does |
| --- | --- |
| F2 | Edit the active cell |
| Enter | Confirm the entry and move down |
| Shift + Enter | Confirm the entry and move up |
| Tab | Confirm the entry and move right |
| Shift + Tab | Confirm the entry and move left |
| Alt + Enter | Start a new line inside the same cell — On macOS: ⌥ + Return |
| Ctrl/⌘ + Enter | Fill every selected cell with the current entry |
| Esc | Cancel the cell entry |
| Delete | Clear the contents of the selected cells |
| Ctrl/⌘ + D | Fill down from the cell above |
| Ctrl/⌘ + R | Fill right from the cell to the left |
| Ctrl + E | Run Flash Fill — Not available in Excel for Mac |
| Ctrl/⌘ + Z | Undo the last action |
| Ctrl/⌘ + Y | Redo the last action |

## Formatting

| Shortcut | What it does |
| --- | --- |
| Ctrl/⌘ + 1 | Open the Format Cells dialog |
| Ctrl/⌘ + B | Apply or remove bold |
| Ctrl/⌘ + I | Apply or remove italic |
| Ctrl/⌘ + U | Apply or remove underline |
| Ctrl + 5 | Apply or remove strikethrough — On macOS: ⌘ + ⇧ + X |
| Ctrl + Shift + $ | Apply the Currency format — On macOS: ⌃ + ⇧ + $ |
| Ctrl + Shift + % | Apply the Percentage format — On macOS: ⌃ + ⇧ + % |
| Ctrl + Shift + ~ | Apply the General number format — On macOS: ⌃ + ⇧ + ~ |
| Ctrl + Shift + # | Apply the Date format — On macOS: ⌃ + ⇧ + # |
| Ctrl + Shift + ! | Apply the Number format with two decimals — On macOS: ⌃ + ⇧ + ! |
| Ctrl + Shift + & | Apply an outline border — On macOS: ⌘ + ⌥ + 0 |
| Ctrl + Shift + _ | Remove the outline border — On macOS: ⌘ + ⌥ + - |

## Formulas and functions

| Shortcut | What it does |
| --- | --- |
| F4 | Cycle absolute and relative references — On macOS: ⌘ + T |
| Alt + = | Insert an AutoSum formula — On macOS: ⌘ + ⇧ + T |
| Ctrl + ` | Show formulas instead of results — On macOS: ⌃ + ` |
| Ctrl + Shift + Enter | Enter the formula as a legacy array formula — On macOS: ⌘ + ⇧ + Return |
| Ctrl + ' | Copy the formula from the cell above — On macOS: ⌃ + ' |
| Ctrl + Shift + " | Copy the value from the cell above — On macOS: ⌃ + ⇧ + " |
| F9 | Recalculate every open workbook |
| Shift + F9 | Recalculate the active worksheet |
| Shift + F3 | Open the Insert Function dialog — On macOS this opens the Formula Builder |
| Ctrl + ; | Enter the current date |
| Ctrl + Shift + : | Enter the current time — On macOS: ⌘ + ; |
| Ctrl/⌘ + K | Insert a hyperlink |

## Rows, columns and sheets

| Shortcut | What it does |
| --- | --- |
| Ctrl + Shift + + | Open the Insert cells dialog — On macOS: ⌃ + ⇧ + = |
| Ctrl + - | Open the Delete cells dialog — On macOS: ⌘ + - |
| Ctrl + 9 | Hide the selected rows — On macOS: ⌃ + 9 |
| Ctrl + 0 | Hide the selected columns — On macOS: ⌃ + 0 |
| Ctrl + Shift + ( | Unhide the selected rows — On macOS: ⌃ + ⇧ + ( |
| Ctrl + Shift + ) | Unhide the selected columns — On macOS: ⌃ + ⇧ + ) |
| Shift + F11 | Insert a new worksheet |
| Ctrl + Page Down | Go to the next worksheet |
| Ctrl + Page Up | Go to the previous worksheet |
| Ctrl + 8 | Show or hide outline symbols — On macOS: ⌃ + 8 |

## Data and analysis

| Shortcut | What it does |
| --- | --- |
| Ctrl + Shift + L | Turn AutoFilter on or off — On macOS: ⌘ + ⇧ + F |
| Alt + Down Arrow | Open the filter or validation drop-down for the cell — On macOS: ⌥ + ↓ |
| Ctrl + Q | Show Quick Analysis options for the selection — Not available in Excel for Mac |
| Ctrl + Shift + G | Open the Workbook Statistics dialog |
| F11 | Chart the selected data on a new sheet |
| Alt + F11 | Open the Visual Basic Editor — On macOS: ⌥ + F11 |

## File and view

| Shortcut | What it does |
| --- | --- |
| Ctrl/⌘ + S | Save the workbook |
| Ctrl/⌘ + O | Open a workbook |
| Ctrl/⌘ + N | Create a new blank workbook |
| Ctrl/⌘ + P | Print the workbook |
| Ctrl/⌘ + W | Close the active workbook window |
| Ctrl + F1 | Show or hide the ribbon — On macOS: ⌘ + ⌥ + R |

## Common questions

### How many keyboard shortcuts does Microsoft Excel have?

This page lists 80 shortcuts across 8 groups, covering the ones people actually use day to day rather than every binding the application defines.

### Are Microsoft Excel shortcuts the same on Mac and Windows?

Mostly. The usual difference is that Ctrl on Windows becomes ⌘ on macOS, which is why the shortcuts here are written as "Ctrl/⌘". Where a binding genuinely differs beyond that swap, it is spelled out separately.

## Related pages

- [Windows 11 shortcuts](https://atoneplace.net/shortcuts/windows/)
- [macOS shortcuts](https://atoneplace.net/shortcuts/macos/)
- [Microsoft Word shortcuts](https://atoneplace.net/shortcuts/word/)
- [Visual Studio Code shortcuts](https://atoneplace.net/shortcuts/vscode/)
- [Google Chrome shortcuts](https://atoneplace.net/shortcuts/chrome/)
- [Adobe Photoshop shortcuts](https://atoneplace.net/shortcuts/photoshop/)
- [Microsoft PowerPoint shortcuts](https://atoneplace.net/shortcuts/powerpoint/)
- [Google Sheets shortcuts](https://atoneplace.net/shortcuts/google-sheets/)
- [Gmail shortcuts](https://atoneplace.net/shortcuts/gmail/)
- [Microsoft Outlook shortcuts](https://atoneplace.net/shortcuts/outlook/)
- [Vim shortcuts](https://atoneplace.net/shortcuts/vim/)
- [Figma shortcuts](https://atoneplace.net/shortcuts/figma/)

## Sources

- Official vendor product documentation — At One Place (/about/)