Microsoft Excel

Industry-leading spreadsheet software for data analysis, calculations, and visualization with powerful formulas and pivot tables

141 shortcuts

MacWindows

Frequently Used

Action	Shortcut
Open workbook	`⌘+O`
Create new workbook	`⌘+N`
Save workbook	`⌘+S`
Close workbook	`⌘+W`
Print	`⌘+P`
Cut	`⌘+X`
Copy	`⌘+C`
Paste	`⌘+V`
Paste special	`⌃+⌘+V`
Undo	`⌘+Z`
Redo	`⌘+Y`
Find	`⌘+F`
Find and replace	`⌃+H`
Open workbook	`⌃+O`
Create new workbook	`⌃+N`
Save workbook	`⌃+S`
Close workbook	`⌃+W`
Print	`⌃+P`
Cut	`⌃+X`
Copy	`⌃+C`
Paste	`⌃+V`
Paste special	`⌃+⌥+V`
Undo	`⌃+Z`
Redo	`⌃+Y`
Find	`⌃+F`
Find and replace	`⌃+H`

Cell Formatting

Action	Shortcut
Bold	`⌘+B`
Italic	`⌘+I`
Underline	`⌘+U`
Strikethrough	`⌘+⇧+X`
Format cells dialog	`⌘+1`
General number format	`⌃+⇧+~`
Currency format	`⌃+⇧+$`
Percentage format	`⌃+⇧+%`
Date format	`⌃+⇧+#`
Time format	`⌃+⇧+@`
Number format	`⌃+⇧+!`
Bold	`⌃+B`
Italic	`⌃+I`
Underline	`⌃+U`
Strikethrough	`⌃+5`
Format cells dialog	`⌃+1`
General number format	`⌃+⇧+~`
Currency format	`⌃+⇧+$`
Percentage format	`⌃+⇧+%`
Date format	`⌃+⇧+#`
Time format	`⌃+⇧+@`
Number format	`⌃+⇧+!`

Action	Shortcut
Move to cell A1	`⌃+Home`
Move to last used cell	`⌃+End`
Move to next sheet	`⌃PageDown`
Move to previous sheet	`⌃PageUp`
Go to cell	`⌃+G`
Move to edge of data region	`⌘Arrow`
Scroll to active cell	`⌃+Delete`
Move to cell A1	`⌃+Home`
Move to last used cell	`⌃+End`
Move to next sheet	`⌃PageDown`
Move to previous sheet	`⌃PageUp`
Go to cell	`⌃+G`
Move to edge of data region	`⌃Arrow`
Scroll to active cell	`⌃+Backspace`

Selection

Action	Shortcut
Select all	`⌘+A`
Select entire column	`⌃+Space`
Select entire row	`⇧+Space`
Extend selection to edge	`⌘+⇧Arrow`
Add to selection	`⇧Click`
Select non-adjacent cells	`⌘Click`
Select current region	`⌃+⇧+*`
Select all	`⌃+A`
Select entire column	`⌃+Space`
Select entire row	`⇧+Space`
Extend selection to edge	`⌃+⇧Arrow`
Add to selection	`⇧Click`
Select non-adjacent cells	`⌃Click`
Select current region	`⌃+⇧+*`

Editing

Action	Shortcut
Edit active cell	`F2`
Cancel cell entry	`Esc`
Delete cell contents	`Delete`
Fill down	`⌘+D`
Fill right	`⌘+R`
Insert cells	`⌃+⇧+=`
Delete cells	`⌘+-`
Insert row	`⌃+⇧++`
Delete row	`⌃+-`
Edit active cell	`F2`
Cancel cell entry	`Esc`
Delete cell contents	`Delete`
Fill down	`⌃+D`
Fill right	`⌃+R`
Insert cells	`⌃+⇧++`
Delete cells	`⌃+-`
Insert row	`⌃+⇧++`
Delete row	`⌃+-`

Formulas

Action	Shortcut
Start formula	`=`
AutoSum	`⌘+⇧+T`
Insert function	`⇧+F3`
Array formula	`⌃+⇧+↩`
Calculate all workbooks	`⌃+⌥+F9`
Calculate active sheet	`⇧+F9`
Toggle formula view	⌃+`
Toggle absolute/relative reference	`⌘+T`
Name a range	`⌘+⇧+F3`
Start formula	`=`
AutoSum	`⌥+=`
Insert function	`⇧+F3`
Array formula	`⌃+⇧+Enter`
Calculate all workbooks	`F9`
Calculate active sheet	`⇧+F9`
Toggle formula view	⌃+`
Toggle absolute/relative reference	`F4`
Name a range	`⌃+F3`

Data

Action	Shortcut
Toggle AutoFilter	`⌘+⇧+F`
Group rows/columns	`⌘+⇧+K`
Ungroup rows/columns	`⌘+⇧+J`
Hide rows	`⌃+9`
Unhide rows	`⌃+⇧+9`
Hide columns	`⌃+0`
Unhide columns	`⌃+⇧+0`
Toggle AutoFilter	`⌃+⇧+L`
Group rows/columns	`⌥+⇧+→`
Ungroup rows/columns	`⌥+⇧+←`
Hide rows	`⌃+9`
Unhide rows	`⌃+⇧+9`
Hide columns	`⌃+0`
Unhide columns	`⌃+⇧+0`

Workbook

Action	Shortcut
Insert new worksheet	`⇧+F11`
Delete worksheet	`⌘+Delete`
Rename worksheet	`DoubleclickTab`
Move to next workbook	⌘+`
Insert new worksheet	`⇧+F11`
Delete worksheet	`⌥+H+D+S`
Rename worksheet	`⌥+H+O+R`
Move to next workbook	`⌃+Tab`

Action	Shortcut
Open Home tab	`⌥+H`
Open Insert tab	`⌥+N`
Open Page Layout tab	`⌥+P`
Open Formulas tab	`⌥+M`
Open Data tab	`⌥+A`
Open Review tab	`⌥+R`
Open View tab	`⌥+W`