Excel Keyboard Shortcuts: Windows & Mac Cheat Sheet

The fastest Excel users rarely touch the mouse. These shortcuts cover everything from basic file operations to pivot tables. Shortcuts are organized by category so you can find what you need and start using it today.

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`	`⌘ ⇧ 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`	`⌘ /`

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 + ;`	`⌘ ⇧ Z`
Select current region	`Ctrl + Shift + *`	`⌃ ⇧ Space`
Select direct precedents	`Ctrl + [`	`⌃ [`
Select direct dependents	`Ctrl + ]`	`⌃ ]`
Cancel selection	`Esc`	`Esc`

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`	`⌘ 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`	`⌘ ⇧ <`

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 + R`	`⌘ ⌥ →`
Add/remove left border	`Alt + L`	`⌘ ⌥ ←`
Add/remove top border	`Alt + T`	`⌘ ⌥ ↑`
Add/remove bottom border	`Alt + B`	`⌘ ⌥ ↓`

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`	`Fn ⌃ F3`
Paste named range into formula	`F3`	`F3`
Accept function autocomplete	`Tab`	`Tab`

⚠

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 + -`	`⌥ ⌘ -`

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`	`⌃ ⇧ T`

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`	`Fn ⌘ ⇧ 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.