Microsoft Excel Keyboard Shortcuts

56 shortcuts across 8 categories · Windows & Mac

Become an Excel power user with these keyboard shortcuts. From formula editing to data manipulation and formatting, these hotkeys will dramatically speed up your spreadsheet workflow.

General

Action	Windows	Mac
Create new workbook	`Ctrl`+`N`	`Cmd`+`N`
Open workbook	`Ctrl`+`O`	`Cmd`+`O`
Save workbook	`Ctrl`+`S`	`Cmd`+`S`
Print	`Ctrl`+`P`	`Cmd`+`P`
Close workbook	`Ctrl`+`W`	`Cmd`+`W`
Undo	`Ctrl`+`Z`	`Cmd`+`Z`
Redo	`Ctrl`+`Y`	`Cmd`+`Y`

Navigation

Action	Windows	Mac
Go to cell A1	`Ctrl`+`Home`	`Ctrl`+`Fn`+`Left`
Go to last used cell	`Ctrl`+`End`	`Ctrl`+`Fn`+`Right`
Move to edge of data region	`Ctrl`+`Arrow`	`Cmd`+`Arrow`
Go to specific cell	`Ctrl`+`G`	`Ctrl`+`G`
Move to next worksheet	`Ctrl`+`Page Down`	`Ctrl`+`Page Down`
Move to previous worksheet	`Ctrl`+`Page Up`	`Ctrl`+`Page Up`
Switch between open workbooks	`Ctrl`+`Tab`	`Ctrl`+`Tab`

Selection

Action	Windows	Mac
Select entire row	`Shift`+`Space`	`Shift`+`Space`
Select entire column	`Ctrl`+`Space`	`Ctrl`+`Space`
Select all cells	`Ctrl`+`A`	`Cmd`+`A`
Extend selection to edge	`Ctrl`+`Shift`+`Arrow`	`Cmd`+`Shift`+`Arrow`
Select to last used cell	`Ctrl`+`Shift`+`End`	`Ctrl`+`Shift`+`End`
Add non-adjacent cells	`Ctrl`+`Click`	`Cmd`+`Click`

Formulas

Action	Windows	Mac
Start formula	`= (equals)`	`= (equals)`
AutoSum	`Alt`+`=`	`Cmd`+`Shift`+`T`
Insert function	`Shift`+`F3`	`Shift`+`Fn`+`F3`
Toggle absolute/relative reference	`F4`	`Cmd`+`T`
Enter formula as array	`Ctrl`+`Shift`+`Enter`	`Cmd`+`Shift`+`Enter`
Show all formulas	`Ctrl`+`	`Ctrl`+`
Calculate all worksheets	`F9`	`Fn`+`F9`

Editing

Action	Windows	Mac
Edit active cell	`F2`	`Fn`+`F2`
Copy	`Ctrl`+`C`	`Cmd`+`C`
Cut	`Ctrl`+`X`	`Cmd`+`X`
Paste	`Ctrl`+`V`	`Cmd`+`V`
Paste Special	`Ctrl`+`Alt`+`V`	`Cmd`+`Ctrl`+`V`
Fill down	`Ctrl`+`D`	`Cmd`+`D`
Fill right	`Ctrl`+`R`	`Cmd`+`R`
Delete cell contents	`Delete`	`Delete`
Insert current date	`Ctrl`+`;`	`Ctrl`+`;`
Insert current time	`Ctrl`+`Shift`+`;`	`Cmd`+`;`

Formatting

Action	Windows	Mac
Bold	`Ctrl`+`B`	`Cmd`+`B`
Italic	`Ctrl`+`I`	`Cmd`+`I`
Underline	`Ctrl`+`U`	`Cmd`+`U`
Format as currency	`Ctrl`+`Shift`+`$`	`Ctrl`+`Shift`+`$`
Format as percentage	`Ctrl`+`Shift`+`%`	`Ctrl`+`Shift`+`%`
Format as number	`Ctrl`+`Shift`+`!`	`Ctrl`+`Shift`+`!`
Format as date	`Ctrl`+`Shift`+`#`	`Ctrl`+`Shift`+`#`
Open Format Cells dialog	`Ctrl`+`1`	`Cmd`+`1`

Rows & Columns

Action	Windows	Mac
Insert row or column	`Ctrl`+`Shift`++++	`Ctrl`+`Shift`++++
Delete row or column	`Ctrl`+`-`	`Ctrl`+`-`
Hide selected rows	`Ctrl`+`9`	`Ctrl`+`9`
Unhide selected rows	`Ctrl`+`Shift`+`9`	`Ctrl`+`Shift`+`9`
Hide selected columns	`Ctrl`+`0`	`Ctrl`+`0`
Group rows/columns	`Alt`+`Shift`+`Right`	`Cmd`+`Shift`+`K`

Data

Action	Windows	Mac
Apply or toggle AutoFilter	`Ctrl`+`Shift`+`L`	`Cmd`+`Shift`+`F`
Create chart from selection	`Alt`+`F1`	`Fn`+`Option`+`F1`
Create table	`Ctrl`+`T`	`Ctrl`+`T`
Flash Fill	`Ctrl`+`E`	`Ctrl`+`E`
Sort ascending	`Alt`+`A, S, A`	`Cmd`+`Shift`+`R`

Go beyond shortcuts. Let AI do the work.

FreedomAI integrates directly into Microsoft Excel to take work off your plate. Not just hotkeys — real collaborative intelligence.

Get Early Access

More Microsoft 365 Shortcuts