Excel Keyboard Shortcuts Reference
Comprehensive shortcut guide for Windows and macOS users
Basic Navigation
Action
Windows
Mac
Move right
Tab
Tab
Move left
Shift + Tab
Shift + Tab
Move down
Enter
Return
Move up
Shift + Enter
Shift + Return
Go to row start
Home
Fn + Left Arrow
Go to A1
Ctrl + Home
Cmd + Fn + Left
Jump to last used cell
Ctrl + End
Cmd + Fn + Right
Switch worksheets
Ctrl + Page Up/Down
Fn + Cmd + Up/Down
Open Go To dialog
Ctrl + G
Cmd + G
Selecting Cells
Action
Windows
Mac
Select full row
Shift + Space
Shift + Space
Select full column
Ctrl + Space
Ctrl + Space
Select entire sheet
Ctrl + A
Cmd + A
Expand selection
Shift + Arrow
Shift + Arrow
Select to edge of data
Ctrl + Shift + Arrow
Cmd + Shift + Arrow
Select current region
Ctrl + Shift + *
Cmd + Shift + *
Select visible only
Alt + ;
Cmd + Shift + Z
Editing Data
Action
Windows
Mac
Edit active cell
F2
Ctrl + U
Copy selection
Ctrl + C
Cmd + C
Paste content
Ctrl + V
Cmd + V
Cut selection
Ctrl + X
Cmd + X
Undo change
Ctrl + Z
Cmd + Z
Redo change
Ctrl + Y
Cmd + Shift + Z
Fill downward
Ctrl + D
Cmd + D
Fill rightward
Ctrl + R
Cmd + R
Insert new row
Ctrl + Shift + +
Ctrl + Shift + +
Delete row
Ctrl + -
Ctrl + -
Insert line in cell
Alt + Enter
Control + Option + Return
Cell Formatting
Action
Windows
Mac
Open format dialog
Ctrl + 1
Cmd + 1
Apply bold
Ctrl + B
Cmd + B
Apply italic
Ctrl + I
Cmd + I
Underline text
Ctrl + U
Cmd + U
General number format
Ctrl + Shift + ~
Cmd + Shift + ~
Currency format
Ctrl + Shift + $
Cmd + Shift + $
Percentage format
Ctrl + Shift + %
Cmd + Shift + %
Date format
Ctrl + Shift + #
Cmd + Shift + #
Time format
Ctrl + Shift + @
Cmd + Shift + @
Add border
Alt + H + B
Control + Option + 0
Working with Formulas
Action
Windows
Mac
Insert function
Shift + F3
Shift + F3
AutoSum
Alt + =
Cmd + Shift + T
Show or hide formulas
Ctrl + `
Cmd + `
Recalculate worksheet
Shift + F9
Shift + F9
Recalculate all
F9
F9
Toggle absolute reference
F4
Cmd + T
Data & Tables
Action
Windows
Mac
Create table
Ctrl + T
Cmd + T
Toggle filters
Ctrl + Shift + L
Cmd + Shift + F
Sort dialog
Alt + D + S
Cmd + Shift + R
Refresh data
Alt + F5
Cmd + Option + R
Remove duplicates
Alt + A + M
Cmd + Option + E
Open data validation
Alt + D + L
Cmd + Option + V
Workbook Management
Action
Windows
Mac
New workbook
Ctrl + N
Cmd + N
Open workbook
Ctrl + O
Cmd + O
Save workbook
Ctrl + S
Cmd + S
Close workbook
Ctrl + W
Cmd + W
Print workbook
Ctrl + P
Cmd + P
Insert worksheet
Shift + F11
Shift + Fn + F11
Rename worksheet
Alt + H + O + R
Option + Shift + R
Charts
Action
Windows
Mac
Insert chart quickly
Alt + F1
Cmd + Option + F1
Create chart sheet
F11
Fn + F11
Navigate chart elements
Arrow keys
Arrow keys
Pivot Tables
Action
Windows
Mac
Create pivot table
Alt + N + V
Cmd + Option + P
Refresh pivot table
Alt + F5
Cmd + Option + R
Comments & Notes
Action
Windows
Mac
Insert comment
Shift + F2
Shift + F2
Edit note/comment
Shift + F2
Shift + F2
View & Window Controls
Action
Windows
Mac
Freeze panes
Alt + W + F + F
Cmd + Option + R
Zoom dialog
Alt + W + Q
Cmd + Option + 0
Toggle ribbon
Ctrl + F1
Cmd + Option + R
Alt Shortcuts – Home Tab
Action
Windows
Mac
Open Home tab
Alt + H
N/A
Paste options
Alt + H + V
N/A
Paste values
Alt + H + V + V
N/A
Paste formulas
Alt + H + V + F
N/A
Cut selection
Alt + H + X
N/A
Copy selection
Alt + H + C
N/A
Format painter
Alt + H + F + P
N/A
Increase font size
Alt + H + G + I
N/A
Decrease font size
Alt + H + G + D
N/A
Bold text
Alt + H + 1
N/A
Italic text
Alt + H + 2
N/A
Underline text
Alt + H + 3
N/A
Bottom border
Alt + H + B + O
N/A
All borders
Alt + H + B + A
N/A
Fill color
Alt + H + H
N/A
Font color
Alt + H + F + C
N/A
Wrap text
Alt + H + W
N/A
Merge & center
Alt + H + M + C
N/A
Align left
Alt + H + A + L
N/A
Align center
Alt + H + A + C
N/A
Align right
Alt + H + A + R
N/A
Increase decimal
Alt + H + 0
N/A
Decrease decimal
Alt + H + 9
N/A
Conditional formatting
Alt + H + L
N/A
Format as table
Alt + H + T
N/A
Cell styles
Alt + H + J
N/A
Insert cells
Alt + H + I + C
N/A
Delete cells
Alt + H + D + C
N/A
AutoSum
Alt + H + U + S
N/A
Sort & filter menu
Alt + H + S
N/A
Alt Shortcuts – Insert Tab
Action
Windows
Mac
Open Insert tab
Alt + N
N/A
Insert pivot table
Alt + N + V
N/A
Insert table
Alt + N + T
N/A
Insert recommended charts
Alt + N + R
N/A
Insert column chart
Alt + N + C
N/A
Insert line chart
Alt + N + N
N/A
Insert pie chart
Alt + N + Q
N/A
Insert bar chart
Alt + N + B
N/A
Insert area chart
Alt + N + A
N/A
Insert scatter chart
Alt + N + D
N/A
Insert map chart
Alt + N + M
N/A
Insert sparklines
Alt + N + S
N/A
Insert hyperlink
Alt + N + I
N/A
Insert text box
Alt + N + X
N/A
Insert header & footer
Alt + N + H
N/A
Insert wordart
Alt + N + W
N/A
Insert shapes
Alt + N + S + H
N/A
Insert icon
Alt + N + Y
N/A
Insert screenshot
Alt + N + C + S
N/A
Insert equation
Alt + N + E
N/A
Alt Shortcuts – Page Layout Tab
Action
Windows
Mac
Open Page Layout tab
Alt + P
N/A
Margins
Alt + P + M
N/A
Orientation
Alt + P + O
N/A
Page size
Alt + P + S
N/A
Print area
Alt + P + R
N/A
Breaks
Alt + P + B
N/A
Background
Alt + P + G
N/A
Print titles
Alt + P + T
N/A
Themes
Alt + P + H
N/A
Colors
Alt + P + C
N/A
Fonts
Alt + P + F
N/A
Effects
Alt + P + E
N/A
Scale to fit width
Alt + P + W
N/A
Scale to fit height
Alt + P + H
N/A
Sheet options gridlines
Alt + P + G + V
N/A
Sheet options headings
Alt + P + H + V
N/A
Alt Shortcuts – Formulas Tab
Action
Windows
Mac
Open Formulas tab
Alt + M
N/A
Insert function
Alt + M + F
N/A
AutoSum
Alt + M + U
N/A
Recently used functions
Alt + M + R
N/A
Financial functions
Alt + M + F + N
N/A
Logical functions
Alt + M + L
N/A
Text functions
Alt + M + T
N/A
Date & time functions
Alt + M + D
N/A
Lookup & reference
Alt + M + L + U
N/A
Math & trig
Alt + M + M
N/A
Define name
Alt + M + D
N/A
Name manager
Alt + M + N
N/A
Trace precedents
Alt + M + P
N/A
Trace dependents
Alt + M + D + D
N/A
Evaluate formula
Alt + M + V
N/A
Calculation options
Alt + M + C
N/A
Alt Shortcuts – Data Tab
Action
Windows
Mac
Open Data tab
Alt + A
N/A
Refresh all
Alt + A + R + A
N/A
Sort ascending
Alt + A + S + A
N/A
Sort descending
Alt + A + S + D
N/A
Custom sort
Alt + A + S + S
N/A
Filter
Alt + A + T
N/A
Clear filter
Alt + A + C
N/A
Text to columns
Alt + A + E
N/A
Remove duplicates
Alt + A + M
N/A
Data validation
Alt + A + V
N/A
What-if analysis
Alt + A + W
N/A
Goal seek
Alt + A + W + G
N/A
Subtotal
Alt + A + B
N/A
Group rows
Alt + A + G
N/A
Ungroup rows
Alt + A + U
N/A
Alt Shortcuts – Review Tab
Action
Windows
Mac
Open Review tab
Alt + R
N/A
Spelling check
Alt + R + S
N/A
Add comment
Alt + R + C
N/A
Delete comment
Alt + R + D
N/A
Show comments
Alt + R + H
N/A
Protect sheet
Alt + R + P + S
N/A
Protect workbook
Alt + R + P + W
N/A
Track changes
Alt + R + G
N/A
Translate
Alt + R + T
N/A
Alt Shortcuts – View Tab
Action
Windows
Mac
Open View tab
Alt + W
N/A
Normal view
Alt + W + L
N/A
Page layout view
Alt + W + P
N/A
Page break preview
Alt + W + I
N/A
Zoom
Alt + W + Q
N/A
Freeze panes
Alt + W + F
N/A
Split window
Alt + W + S
N/A
Hide gridlines
Alt + W + V + G
N/A
Hide headings
Alt + W + V + H
N/A
New window
Alt + W + N
N/A
Arrange all
Alt + W + A
N/A