shortcutskeyboardefficiencybeginner
Excel Keyboard Shortcuts: Windows & Mac Cheat Sheet
Complete Excel keyboard shortcuts for Windows and Mac. Navigate, format, and enter data faster without touching the mouse.
The fastest Excel users rarely touch the mouse. Shortcuts below are grouped by task, Windows and Mac side by side.
File
| Action | Windows | Mac |
|---|
| New workbook | Ctrl + N | ⌘ N |
| Open workbook | Ctrl + O | ⌘ O |
| Save | Ctrl + S | ⌘ S |
| Save As | F12 | ⌘ ⇧ S |
| Print | Ctrl + P | ⌘ P |
| Close workbook | Ctrl + W | ⌘ W |
| Close Excel | Alt + F4 | ⌘ Q |
General
| Action | Windows | Mac |
|---|
| Undo | Ctrl + Z | ⌘ Z |
| Redo | Ctrl + Y | ⌘ Y |
| Repeat last action | F4 | ⌘ Y |
| Copy | Ctrl + C | ⌘ C |
| Cut | Ctrl + X | ⌘ X |
| Paste | Ctrl + V | ⌘ V |
| Paste Special | Ctrl + Alt + V | ⌘ ⌃ V |
| Paste values only | Ctrl + Shift + V | — |
| Find | Ctrl + F | ⌘ F |
| Find and Replace | Ctrl + H | ⌃ H |
| Find next | Shift + F4 | ⌘ G |
| Find previous | Ctrl + Shift + F4 | ⌘ ⇧ G |
| Create embedded chart | Alt + F1 | Fn ⌥ F1 |
| Create chart on new sheet | F11 | Fn F11 |
| Check spelling | F7 | Fn F7 |
| Open Options | Alt + F + T | ⌘ , |
| Open Help | F1 | ⌘ / |
Available in: Excel for Microsoft 365 only — Ctrl + Shift + V for paste values is not in Excel 2019 or 2021, and Excel for Mac has no built-in equivalent. Mac users can add Paste Values to the Quick Access Toolbar and trigger it with ⌥ plus its position number.
Navigation
| Action | Windows | Mac |
|---|
| Move one cell right | → | → |
| Move one cell left | ← | ← |
| Move one cell up | ↑ | ↑ |
| Move one cell down | ↓ | ↓ |
| Move to edge of data region (right) | Ctrl + → | ⌘ → |
| Move to edge of data region (left) | Ctrl + ← | ⌘ ← |
| Move to edge of data region (up) | Ctrl + ↑ | ⌘ ↑ |
| Move to edge of data region (down) | Ctrl + ↓ | ⌘ ↓ |
| Move to beginning of row | Home | Fn ← |
| Move to cell A1 | Ctrl + Home | Fn ⌃ ← |
| Move to last used cell | Ctrl + End | Fn ⌃ → |
| Move one screen down | Page Down | Fn ↓ |
| Move one screen up | Page Up | Fn ↑ |
| Move one screen right | Alt + Page Down | Fn ⌥ ↓ |
| Move one screen left | Alt + Page Up | Fn ⌥ ↑ |
| Go to next worksheet | Ctrl + Page Down | ⌥ → |
| Go to previous worksheet | Ctrl + Page Up | ⌥ ← |
| Go To dialog | Ctrl + G | ⌃ G |
✓Ctrl + Arrow is the fastest way to jump to the last filled cell in any direction. Combine it with Shift to select the whole range in one keystroke.
Selection
| Action | Windows | Mac |
|---|
| Select entire row | Shift + Space | ⇧ Space |
| Select entire column | Ctrl + Space | ⌃ Space |
| Select entire worksheet | Ctrl + A | ⌘ A |
| Add adjacent cells to selection | Shift + Click | ⇧ Click |
| Add non-adjacent cells to selection | Ctrl + Click | ⌘ Click |
| Extend selection right | Shift + → | ⇧ → |
| Extend selection left | Shift + ← | ⇧ ← |
| Extend selection up | Shift + ↑ | ⇧ ↑ |
| Extend selection down | Shift + ↓ | ⇧ ↓ |
| Extend selection to last cell right | Ctrl + Shift + → | ⌘ ⇧ → |
| Extend selection to last cell left | Ctrl + Shift + ← | ⌘ ⇧ ← |
| Extend selection to last cell up | Ctrl + Shift + ↑ | ⌘ ⇧ ↑ |
| Extend selection to last cell down | Ctrl + Shift + ↓ | ⌘ ⇧ ↓ |
| Extend selection to first cell | Ctrl + Shift + Home | Fn ⌃ ⇧ ← |
| Extend selection to last cell | Ctrl + Shift + End | Fn ⌃ ⇧ → |
| Extend selection up one screen | Shift + Page Up | Fn ⇧ ↑ |
| Extend selection down one screen | Shift + Page Down | Fn ⇧ ↓ |
| Extend to start of row | Shift + Home | Fn ⇧ ← |
| Select visible cells only | Alt + ; | ⌘ ⇧ * |
| Select current region | Ctrl + Shift + * | — |
| Select direct precedents | Ctrl + [ | ⌃ ⇧ [ |
| Select direct dependents | Ctrl + ] | ⌃ ] |
| Cancel selection | Esc | Esc |
⚠Ctrl + A does not select the whole sheet when the active cell sits inside a block of data. The first press selects the current region, the second press selects the region plus its summary rows, and the third selects the sheet. Inside an Excel Table it selects the table body first. Click an empty cell away from your data if you want the entire sheet in one keystroke.
Entering Data
| Action | Windows | Mac |
|---|
| Confirm and move down | Enter | Return |
| Confirm and move up | Shift + Enter | ⇧ Return |
| Confirm and move right | Tab | Tab |
| Confirm and move left | Shift + Tab | ⇧ Tab |
| Confirm and stay in cell | Ctrl + Enter | ⌃ Return |
| Enter same data in multiple cells | Ctrl + Enter | ⌃ Return |
| Insert current date | Ctrl + ; | ⌃ ; |
| Insert current time | Ctrl + Shift + : | ⌘ ; |
| Fill down | Ctrl + D | ⌘ D |
| Fill right | Ctrl + R | ⌘ R |
| Copy formula from cell above | Ctrl + ' | ⌃ ' |
| Copy value from cell above | Ctrl + Shift + " | ⌃ ⇧ " |
| Add hyperlink | Ctrl + K | ⌘ K |
| Flash fill | Ctrl + E | ⌃ E |
| Show AutoComplete list | Alt + ↓ | ⌃ ⌥ ↓ |
| Insert line break in cell | Alt + Enter | ⌃ ⌥ Return |
Cell Editing
| Action | Windows | Mac |
|---|
| Edit active cell | F2 | ⌃ U |
| Cancel entry | Esc | Esc |
| Delete character left of cursor | Backspace | Delete |
| Delete character right of cursor | Delete | Fn Delete |
| Delete to end of line | Ctrl + Delete | Fn ⌃ Delete |
| Move one word right | Ctrl + → | ⌥ → |
| Move one word left | Ctrl + ← | ⌥ ← |
| Select one word right | Ctrl + Shift + → | ⇧ ⌥ → |
| Select one word left | Ctrl + Shift + ← | ⇧ ⌥ ← |
| Select to beginning of cell | Shift + Home | Fn ⇧ ← |
| Select to end of cell | Shift + End | Fn ⇧ → |
Formatting
| Action | Windows | Mac |
|---|
| Open Format Cells dialog | Ctrl + 1 | ⌘ 1 |
| Bold | Ctrl + B | ⌘ B |
| Italic | Ctrl + I | ⌘ I |
| Underline | Ctrl + U | ⌘ U |
| Strikethrough | Ctrl + 5 | ⌘ ⇧ X |
| Align center | Alt + H, A, C | ⌘ E |
| Align left | Alt + H, A, L | ⌘ L |
| Align right | Alt + H, A, R | — |
| Indent | Alt + H, 6 | ⌃ ⌥ Tab |
| Remove indent | Alt + H, 5 | ⌃ ⌥ ⇧ Tab |
| Increase font size | Alt + H, F, G | ⌘ ⇧ > |
| Decrease font size | Alt + H, F, K | ⌘ ⇧ < |
Excel for Mac has no align-right shortcut. ⌘ R is Fill Right — pressing it with a selection copies the leftmost column across, which is not what you want.
Number Formatting
| Action | Windows | Mac |
|---|
| General format | Ctrl + Shift + ~ | ⌃ ⇧ ~ |
| Currency format | Ctrl + Shift + $ | ⌃ ⇧ $ |
| Percentage format | Ctrl + Shift + % | ⌃ ⇧ % |
| Scientific format | Ctrl + Shift + ^ | ⌃ ⇧ ^ |
| Date format | Ctrl + Shift + # | ⌃ ⇧ # |
| Time format | Ctrl + Shift + @ | ⌃ ⇧ @ |
| Number format (2 decimal places) | Ctrl + Shift + ! | ⌃ ⇧ ! |
Borders
| Action | Windows | Mac |
|---|
| Add outline border | Ctrl + Shift + & | ⌘ ⌥ 0 |
| Remove borders | Ctrl + Shift + _ | ⌘ ⌥ - |
| Add/remove right border | Alt + H, B | ⌘ ⌥ → |
| Add/remove left border | Alt + H, B | ⌘ ⌥ ← |
| Add/remove top border | Alt + H, B | ⌘ ⌥ ↑ |
| Add/remove bottom border | Alt + H, B | ⌘ ⌥ ↓ |
Single-edge borders are a Mac-only shortcut. On Windows, Alt + H, B opens the Borders gallery and you pick the edge from there.
Formulas
| Action | Windows | Mac |
|---|
| Toggle absolute/relative reference | F4 | ⌘ T |
| Insert function (Function Wizard) | Shift + F3 | Fn ⇧ F3 |
| AutoSum | Alt + = | ⌘ ⇧ T |
| Toggle formula view | Ctrl + ` | ⌃ ` |
| Insert function arguments | Ctrl + Shift + A | ⌃ ⇧ A |
| Enter array formula | Ctrl + Shift + Enter | ⌃ ⇧ Return |
| Evaluate part of formula | F9 (in formula bar) | Fn F9 |
| Calculate all worksheets | F9 | Fn F9 |
| Calculate active worksheet | Shift + F9 | Fn ⇧ F9 |
| Force recalculate all | Ctrl + Alt + F9 | — |
| Expand/collapse formula bar | Ctrl + Shift + U | ⌃ ⇧ U |
| Open Name Manager | Ctrl + F3 | — |
| Define a name | Alt + M, M, D | Fn ⌘ F3 |
| Paste named range into formula | F3 | — |
| Accept function autocomplete | Tab | Tab |
On Mac, ⌘ T does two different jobs depending on where you are. In the formula bar with a reference selected, it cycles absolute and relative anchoring. In the grid, it creates a table.
⚠When you press F9 inside the formula bar to evaluate a partial formula, Excel replaces that portion with its calculated value. Press Esc to cancel without committing — otherwise the formula is permanently replaced with the hardcoded result.
Rows, Columns & Cells
| Action | Windows | Mac |
|---|
| Insert row/column/cell | Ctrl + Shift + + | ⌃ ⇧ = |
| Delete row/column/cell | Ctrl + - | ⌘ - |
| Delete cell contents | Delete | Fn Delete |
| Hide rows | Ctrl + 9 | ⌃ 9 |
| Unhide rows | Ctrl + Shift + 9 | ⌃ ⇧ 9 |
| Hide columns | Ctrl + 0 | ⌃ 0 |
| Unhide columns | Ctrl + Shift + 0 | ⌃ ⇧ 0 |
| Group rows or columns | Alt + Shift + → | ⌘ ⇧ K |
| Ungroup rows or columns | Alt + Shift + ← | ⌘ ⇧ J |
| Zoom in | Ctrl + Alt + = | — |
| Zoom out | Ctrl + Alt + - | — |
⚠Ctrl + Shift + 0 fails on most Windows machines. Windows reserves that combination for switching keyboard input language, so it never reaches Excel. Either unhide columns from the ribbon (Alt + H, O, U, L) or disable the input-language shortcut in Windows keyboard settings.
Tables & Filters
| Action | Windows | Mac |
|---|
| Insert table | Ctrl + T | ⌘ T |
| Toggle AutoFilter | Ctrl + Shift + L | ⌘ ⇧ F |
| Open filter dropdown | Alt + ↓ | ⌥ ↓ |
| Select table row | Shift + Space | ⇧ Space |
| Select table column | Ctrl + Space | ⌃ Space |
| Select entire table | Ctrl + A | ⌘ A |
| Toggle total row | Ctrl + Shift + T | — |
Ctrl + L also opens the Create Table dialog on Windows if Ctrl + T is taken by something else on your machine.
Workbook & Worksheets
| Action | Windows | Mac |
|---|
| Insert new worksheet | Shift + F11 | Fn ⇧ F11 |
| Go to next worksheet | Ctrl + Page Down | ⌥ → |
| Go to previous worksheet | Ctrl + Page Up | ⌥ ← |
| Go to next workbook | Ctrl + Tab | ⌘ ` |
| Go to previous workbook | Ctrl + Shift + Tab | ⌘ ⇧ ` |
| Select adjacent worksheets | Shift + Click | ⇧ Click |
| Select non-adjacent worksheets | Ctrl + Click | ⌘ Click |
| Minimize workbook window | Ctrl + F9 | ⌘ M |
| Toggle full screen | Ctrl + Shift + F1 | ⌃ ⌘ F |
Pivot Tables
| Action | Windows | Mac |
|---|
| Select entire pivot table | Ctrl + A | ⌘ A |
| Toggle field checkbox | Space | Space |
| Group pivot table items | Alt + Shift + → | ⌘ ⇧ K |
| Ungroup pivot table items | Alt + Shift + ← | ⌘ ⇧ J |
| Open pivot table wizard | Alt + D, P | ⌘ ⌥ P |
Other
| Action | Windows | Mac |
|---|
| Insert/edit note | Shift + F2 | Fn ⇧ F2 |
| Insert threaded comment | Ctrl + Shift + F2 | — |
| Open Macro dialog | Alt + F8 | Fn ⌥ F8 |
| Open VBA Editor | Alt + F11 | Fn ⌥ F11 |
| Display right-click menu | Shift + F10 | Fn ⇧ F10 |
| Expand or collapse ribbon | Ctrl + F1 | ⌘ ⌥ R |
✓The single highest-ROI shortcut for most users: Ctrl + Shift + Arrow to select a full column or row of data instantly. Once that's muscle memory, everything else gets faster.