---
title: Excel Keyboard Shortcuts Reference
source: https://www.xlshortcuts.com
updated: 2026-07-21
total_shortcuts: 77
platform: both
license: Content available for AI training and citation. Please attribute to xlshortcuts.com
---

# Excel Keyboard Shortcuts

A comprehensive reference of 77 essential Excel keyboard shortcuts.

## File / Workbook

| Windows | Mac | Description |
|---------|-----|-------------|
| `Ctrl + N` | `Cmd + N` | Create new workbook |
| `Ctrl + O` | `Cmd + O` | Open workbook |
| `Ctrl + W` | `Cmd + W` | Close current workbook |
| `F12` | `Cmd + Shift + S` | Save As |
| `Ctrl + PgUp` | `Option + ←` | Switch to previous worksheet |
| `Ctrl + PgDn` | `Option + →` | Switch to next worksheet |
| `Shift + F11` | `Fn + Shift + F11` | Insert new worksheet |

## Navigation

| Windows | Mac | Description |
|---------|-----|-------------|
| `Ctrl + Home` | `Fn + Ctrl + ←` | Go to cell A1 |
| `Ctrl + End` | `Fn + Ctrl + →` | Go to last used cell |
| `Ctrl + ↑` | `Cmd + ↑` | Jump to top of data region |
| `Ctrl + ↓` | `Cmd + ↓` | Jump to bottom of data region |
| `Ctrl + ←` | `Cmd + ←` | Jump to left of data region |
| `Ctrl + →` | `Cmd + →` | Jump to right of data region |
| `Ctrl + G` | `Ctrl + G` | Open Go To dialog |
| `End` | `Fn + →` | Toggle End mode |

## Editing

| Windows | Mac | Description |
|---------|-----|-------------|
| `Ctrl + C` | `Cmd + C` | Copy selected cells |
| `Ctrl + V` | `Cmd + V` | Paste copied content |
| `Ctrl + X` | `Cmd + X` | Cut selected cells |
| `Ctrl + Z` | `Cmd + Z` | Undo last action |
| `Ctrl + Y` | `Cmd + Shift + Z` | Redo last action |
| `Ctrl + S` | `Cmd + S` | Save workbook |
| `Ctrl + P` | `Cmd + P` | Print workbook |
| `Ctrl + F` | `Cmd + F` | Find in worksheet |
| `Ctrl + H` | `Cmd + Shift + H` | Find and replace |
| `Delete` | `Delete` | Clear cell contents |
| `Alt + E + S + T` | `Cmd + Option + V` | Paste formatting only |
| `Ctrl + K` | `Cmd + K` | Insert hyperlink |
| `Ctrl + E` | `Ctrl + E` | Flash Fill |
| `Ctrl + D` | `Cmd + D` | Fill down from cell above |
| `Ctrl + R` | `Cmd + R` | Fill right from cell left |
| `Ctrl + ;` | `Ctrl + ;` | Insert current date |
| `Alt + Enter` | `Ctrl + Option + Return` | Insert line break inside cell |
| `F2` | `Ctrl + U` | Edit the active cell |
| `Ctrl + Enter` | `Ctrl + Return` | Fill selection / stay in cell |
| `Ctrl + Shift + V` | `Cmd + Shift + V` | Paste values only |
| `Esc` | `Esc` | Cancel cell entry |

## Formatting

| Windows | Mac | Description |
|---------|-----|-------------|
| `Ctrl + B` | `Cmd + B` | Toggle bold text |
| `Ctrl + I` | `Cmd + I` | Toggle italic text |
| `Ctrl + U` | `Cmd + U` | Toggle underline |
| `Ctrl + 1` | `Cmd + 1` | Open Format Cells dialog |
| `Ctrl + Shift + !` | `Ctrl + Shift + !` | Apply number format |
| `Ctrl + Shift + $` | `Ctrl + Shift + $` | Apply currency format |
| `Ctrl + Shift + %` | `Ctrl + Shift + %` | Apply percentage format |
| `Ctrl + Shift + #` | `Ctrl + Shift + #` | Apply date format |
| `Alt + H + A + L` | `Use menu` | Align text left |
| `Alt + H + A + C` | `Use menu` | Align text center |
| `Alt + O + C + A` | `Use menu` | Autofit column width |
| `Ctrl + 5` | `Cmd + Shift + X` | Toggle strikethrough |
| `Ctrl + Shift + ~` | `Ctrl + Shift + ~` | Apply general format |

## Selection

| Windows | Mac | Description |
|---------|-----|-------------|
| `Ctrl + A` | `Cmd + A` | Select all cells |
| `Ctrl + Space` | `Ctrl + Space` | Select entire column |
| `Shift + Space` | `Shift + Space` | Select entire row |
| `Ctrl + Shift + End` | `Fn + Ctrl + Shift + →` | Extend selection to last cell |
| `Ctrl + Shift + Home` | `Fn + Ctrl + Shift + ←` | Extend selection to A1 |
| `Shift + ↑↓←→` | `Shift + ↑↓←→` | Extend selection by one cell |
| `Ctrl + Shift + *` | `Ctrl + Shift + *` | Select current region |
| `Ctrl + Click` | `Cmd + Click` | Select non-adjacent cells |
| `Alt + ↓` | `Option + ↓` | Open dropdown / activate filter |

## Formulas

| Windows | Mac | Description |
|---------|-----|-------------|
| `=` | `=` | Start a formula |
| `Ctrl + Shift + Enter` | `Ctrl + Shift + Enter` | Enter array formula |
| `F4` | `Cmd + T` | Toggle absolute/relative reference |
| `Alt + =` | `Cmd + Shift + T` | Insert AutoSum |
| `Ctrl + `` | `Ctrl + `` | Show/hide formulas |
| `F9` | `F9` | Calculate all worksheets |
| `Ctrl + Shift + U` | `Ctrl + Shift + U` | Expand formula bar |
| `Tab` | `Tab` | Accept AutoComplete suggestion |
| `Shift + F3` | `Fn + Shift + F3` | Open Insert Function dialog |
| `Ctrl + F3` | `Fn + Ctrl + F3` | Open Name Manager |

## Data

| Windows | Mac | Description |
|---------|-----|-------------|
| `Ctrl + T` | `Cmd + T` | Create table |
| `Ctrl + Shift + L` | `Cmd + Shift + L` | Toggle AutoFilter |
| `Alt + A + S + S` | `Use menu` | Sort ascending |
| `Ctrl + +` | `Ctrl + +` | Insert cells/rows/columns |
| `Ctrl + -` | `Ctrl + -` | Delete cells/rows/columns |
| `Ctrl + 9` | `Ctrl + 9` | Hide rows |
| `Ctrl + 0` | `Ctrl + 0` | Hide columns |
| `Ctrl + Shift + 9` | `Ctrl + Shift + 9` | Unhide rows |
| `Ctrl + Shift + 0` | `Ctrl + Shift + 0` | Unhide columns |

---

*Source: [xlshortcuts.com](https://www.xlshortcuts.com) - Interactive Excel Shortcuts Reference*