Excel Shortcuts Cheat Sheet — Windows + Mac, All Versions

Excel keyboard shortcuts for Windows and Mac — the ones power users actually run daily. Win = Windows shortcut; Mac = macOS equivalent.

The Mac modifier swap

Most Excel shortcuts work with Ctrl on Windows and ⌘ on Mac. Where they differ significantly, both are listed.

Action	Windows	Mac
Extend selection by one cell	Shift + arrow	⇧ + arrow
Extend to edge of data	Ctrl + Shift + arrow	⌘ + ⇧ + arrow
Select entire row	Shift + Space	⇧ + Space
Select entire column	Ctrl + Space	⌃ + Space
Select all (current region first; then all)	Ctrl + A	⌘ + A
Select non-adjacent cells	Ctrl + click	⌘ + click
Select to last used cell	Ctrl + Shift + End	⌘ + ⇧ + fn + →
Toggle Extend Selection mode	F8	fn + F8

Action	Windows	Mac
Edit selected cell	F2	⌃ + U or fn + F2
Confirm + move down	Enter	↩
Confirm + stay in cell	Ctrl + Enter	⌃ + ↩
Confirm + move right	Tab	⇥
Cancel edit	Esc	⎋
Cut / Copy / Paste	Ctrl + X/C/V	⌘ + X/C/V
Paste Special	Ctrl + Alt + V	⌃ + ⌘ + V
Undo / Redo	Ctrl + Z / Y	⌘ + Z / ⌘ + ⇧ + Z
Find / Replace	Ctrl + F / H	⌘ + F / ⌃ + H
Repeat last action	F4 or Ctrl + Y	⌘ + Y
Delete cell contents	Delete	⌫
Insert today's date	Ctrl + ;	⌃ + ;
Insert current time	Ctrl + Shift + :	⌃ + ⇧ + :
Fill down	Ctrl + D	⌃ + D
Fill right	Ctrl + R	⌃ + R
Insert hyperlink	Ctrl + K	⌘ + K
Show formulas in cells	Ctrl + `	⌃ + `
Toggle absolute reference ($A$1 vs A1)	F4 (in formula bar)	⌘ + T (in formula bar)

Action	Windows	Mac
AutoSum	Alt + =	⌘ + ⇧ + T
Function Wizard	Shift + F3	fn + ⇧ + F3
Define Name (Name Manager)	Ctrl + F3	fn + ⌃ + F3
Recalculate workbook	F9	fn + F9
Recalculate active sheet	Shift + F9	fn + ⇧ + F9
Toggle absolute / relative reference	F4	⌘ + T
Insert function arguments	Ctrl + Shift + A	⌃ + ⇧ + A
Trace precedents	Ctrl + [	⌃ + [
Trace dependents	Ctrl + ]	⌃ + ]

Working with Excel data programmatically? Convert spreadsheets to JSON: CSV to JSON. Convert JSON exports back to spreadsheet rows: JSON to CSV.