Excel Shortcuts — Windows & Mac
This page lists keyboard shortcuts for Microsoft Excel. The dataset is hard-coded in shortcuts.json (no live fetching) and includes ExcelJet shortcuts plus additional cross-platform items. Everything is fully filterable by shortcut name. There are currently 300 shortcuts loaded.
Press Enter in the search box to filter. Click a suggestion to auto-fill your query.
File
Shortcut
Windows
Mac
New workbook
Create a new workbook
Ctrl+N
⌘+N
Open workbook
Open an existing workbook
Ctrl+O
⌘+O
Save workbook
Save current workbook
Ctrl+S
⌘+S
Save As
Open Save As dialog
F12
⌘+Shift+S
Print
Open Print dialog
Ctrl+P
⌘+P
Close workbook
Close the active workbook window
Ctrl+W
⌘+W
Quit Excel
Exit the application
Alt+F4
⌘+Q
Open Recent
Open recent files list
Ctrl+O›R
⌘+O›R
Export PDF
Open Export dialog (PDF)
Alt+F›E
Open Recent (list)
Open recent files list
Ctrl+O›R
⌘+O›R
Ribbon
Shortcut
Windows
Mac
Toggle Ribbon
Collapse/expand Ribbon
Ctrl+F1
⌘+Option+R
General
Shortcut
Windows
Mac
Copy
Copy selection
Ctrl+C
⌘+C
Paste
Paste
Ctrl+V
⌘+V
Cut
Cut selection
Ctrl+X
⌘+X
Undo
Undo last action
Ctrl+Z
⌘+Z
Redo
Redo last action
Ctrl+Y
⌘+Shift+Z
Find
Find text
Ctrl+F
⌘+F
Replace
Find and replace
Ctrl+H
⌘+Shift+H
Insert hyperlink
Insert a link
Ctrl+K
⌘+K
Find Next
Find next match
Shift+F4
Shift+F4
Paste Special…
Open Paste Special dialog
Ctrl+Alt+V
⌘+⌥+V
Paste Special — Values
Paste values only
Ctrl+Alt+V›V
⌘+⌥+V›V
Paste Special — Formulas
Paste formulas
Ctrl+Alt+V›F
⌘+⌥+V›F
Paste Special — Formats
Paste formats
Ctrl+Alt+V›T
⌘+⌥+V›T
Paste Special — Comments/Notes
Paste comments/notes
Ctrl+Alt+V›C
⌘+⌥+V›C
Paste Special — Validation
Paste data validation
Ctrl+Alt+V›N
⌘+⌥+V›N
Paste Special — Column widths
Paste column widths
Ctrl+Alt+V›W
⌘+⌥+V›W
Paste Special — Transpose
Transpose
Ctrl+Alt+V›E
⌘+⌥+V›E
Paste Special — Add
Add operation
Ctrl+Alt+V›D
⌘+⌥+V›D
Paste Special — Subtract
Subtract operation
Ctrl+Alt+V›S
⌘+⌥+V›S
Paste Special — Multiply
Multiply operation
Ctrl+Alt+V›M
⌘+⌥+V›M
Paste Special — Divide
Divide operation
Ctrl+Alt+V›I
⌘+⌥+V›I
Paste Special — Skip blanks
Skip blanks
Ctrl+Alt+V›B
⌘+⌥+V›B
Tables and Filters
Shortcut
Windows
Mac
Toggle Filters
Add/Remove filters
Ctrl+Shift+L
⌘+Shift+F
Create Table
Convert range to table
Ctrl+T
⌘+T
Open filter dropdown
Open filter menu
Alt+↓
Option+↓
Reapply filter
Reapply current filters
Ctrl+Alt+L
Sort/Filter: Sort A to Z
Sort A to Z via Ribbon
Alt+H›S›S
Sort/Filter: Sort Z to A
Sort Z to A via Ribbon
Alt+H›S›O
Sort/Filter: Clear Filter
Clear Filter via Ribbon
Alt+H›S›C
Sort/Filter: Filter
Filter via Ribbon
Alt+H›S›F
Insert: Insert Slicer
Insert Slicer via Ribbon
Alt+N›S
Insert: Insert Table
Insert Table via Ribbon
Alt+N›T
Data: Text to Columns
Text to Columns via Ribbon
Alt+A›E
Data: Remove Duplicates
Remove Duplicates via Ribbon
Alt+A›M
Data: Flash Fill
Flash Fill via Ribbon
Alt+A›F
Data: Refresh All
Refresh All via Ribbon
Alt+A›R
Clear All Filters
Clear all filters
Alt+A›C
Sort Dialog…
Open Sort dialog
Alt+A›S›S
Filter by Selection
Filter by selected value
Alt+A›T›S
Text to Columns
Start Text to Columns
Alt+A›E
Remove Duplicates
Remove duplicates
Alt+A›M
Refresh All
Refresh all queries/pivots
Ctrl+Alt+F5
⌘+Option+F5
Insert Slicer
Insert slicer
Alt+N›S
Insert Table (Ribbon)
Insert Excel Table
Alt+N›T
Sort A to Z
Sort ascending
Alt+H›S›A
Sort Z to A
Sort descending
Alt+H›S›D
Clear Filter on Column
Clear filter from column
Alt+H›S›C
Filter (Toggle)
Toggle AutoFilter
Ctrl+Shift+L
⌘+Shift+F
Insert Sparklines — Line
Insert line sparklines
Alt+N›SL
Insert Sparklines — Column
Insert column sparklines
Alt+N›SC
Insert Screenshot
Insert screenshot
Alt+N›SC›R
Flash Fill (Data tab)
Flash Fill
Alt+A›F
Refresh (Selected)
Refresh selected query/pivot
Alt+F5
⌘+Option+F5
Connections
Workbook connections
Alt+A›O
Drag and Drop
Shortcut
Windows
Mac
Fill via drag
Copy value/formula by drag
Drag fill handle
Drag fill handle
Fill series via drag
Create incremental series
Ctrl + drag
Option + drag
Auto-fill down
Auto-fill region
Double-click fill handle
Double-click fill handle
Selection
Shortcut
Windows
Mac
Select all / region
Region / entire sheet
Ctrl+A (twice)
⌘+A (twice)
Entire row
Highlight whole row
Shift+Space
Shift+Space
Entire column
Highlight whole column
Ctrl+Space
⌃+Space
Add to selection
Add non-contiguous cells
Ctrl + Click
⌘ + Click
Current array
Select array formula range
Ctrl+or
⌘+or
Select current region
Expand to current region
Ctrl+A
⌘+A
Extend selection one cell left
Extend selection
Shift+←
Shift+←
Extend selection one cell right
Extend selection
Shift+→
Shift+→
Extend selection one cell up
Extend selection
Shift+↑
Shift+↑
Extend selection one cell down
Extend selection
Shift+↓
Shift+↓
Active Cell
Shortcut
Windows
Mac
Edit active cell
Enter edit mode
F2
Ctrl+U
Commit & move down
Enter current cell
Enter
Enter
Commit & stay
Fill selection with entry
Ctrl+Enter
⌘+Enter
Cancel edit
Cancel edit
Esc
Esc
Insert new line in cell
Line break inside cell
Alt+Enter
Option+Enter
Extend Selection
Shortcut
Windows
Mac
Extend to edge (Left)
Select to last filled cell left
Ctrl+Shift+←
⌘+Shift+←
Extend to edge (Right)
Select to last filled cell right
Ctrl+Shift+→
⌘+Shift+→
Extend to edge (Up)
Select to last filled cell up
Ctrl+Shift+↑
⌘+Shift+↑
Extend to edge (Down)
Select to last filled cell down
Ctrl+Shift+↓
⌘+Shift+↓
To A1
From active cell to A1
Ctrl+Shift+Home
⌘+Shift+Fn+←
To last used
From active cell to last used
Ctrl+Shift+End
⌘+Shift+Fn+→
Select Special
Shortcut
Windows
Mac
Go To Special — Blanks
Select blanks
Ctrl+G›Special›Blanks
⌘+G›Special›Blanks
Go To Special — Constants
Select constants
Ctrl+G›Special›Constants
⌘+G›Special›Constants
Go To Special — Constants (Numbers)
Select constants (numbers)
Ctrl+G›Special›Constants-Numbers
⌘+G›Special›Constants-Numbers
Go To Special — Constants (Text)
Select constants (text)
Ctrl+G›Special›Constants-Text
⌘+G›Special›Constants-Text
Go To Special — Constants (Logicals)
Select constants (logicals)
Ctrl+G›Special›Constants-Logicals
⌘+G›Special›Constants-Logicals
Go To Special — Constants (Errors)
Select constants (errors)
Ctrl+G›Special›Constants-Errors
⌘+G›Special›Constants-Errors
Go To Special — Formulas
Select formulas
Ctrl+G›Special›Formulas
⌘+G›Special›Formulas
Go To Special — Formulas (Numbers)
Select formulas (numbers)
Ctrl+G›Special›Formulas-Numbers
⌘+G›Special›Formulas-Numbers
Go To Special — Formulas (Text)
Select formulas (text)
Ctrl+G›Special›Formulas-Text
⌘+G›Special›Formulas-Text
Go To Special — Formulas (Logicals)
Select formulas (logicals)
Ctrl+G›Special›Formulas-Logicals
⌘+G›Special›Formulas-Logicals
Go To Special — Formulas (Errors)
Select formulas (errors)
Ctrl+G›Special›Formulas-Errors
⌘+G›Special›Formulas-Errors
Go To Special — Visible Cells Only
Select visible cells only
Ctrl+G›Special›Visible
⌘+G›Special›Visible
Go To Special — Current region
Select current region
Ctrl+G›Special›Current region
⌘+G›Special›Current region
Go To Special — Current array
Select current array
Ctrl+G›Special›Current array
⌘+G›Special›Current array
Go To Special — Objects
Select objects
Ctrl+G›Special›Objects
⌘+G›Special›Objects
Go To Special — Row differences
Select row differences
Ctrl+G›Special›Row differences
⌘+G›Special›Row differences
Go To Special — Column differences
Select column differences
Ctrl+G›Special›Column differences
⌘+G›Special›Column differences
Go To Special — Precedents (Direct only)
Select precedents (direct only)
Ctrl+G›Special›Precedents-Direct
⌘+G›Special›Precedents-Direct
Go To Special — Dependents (Direct only)
Select dependents (direct only)
Ctrl+G›Special›Dependents-Direct
⌘+G›Special›Dependents-Direct
Go To Special — Last cell
Select last cell
Ctrl+G›Special›Last cell
⌘+G›Special›Last cell
Go To Special — Comments
Select comments/notes
Ctrl+G›Special›Comments
⌘+G›Special›Comments
Go To Special — Conditional Formats
Select conditional formats
Ctrl+G›Special›Conditional formats
⌘+G›Special›Conditional formats
Go To Special — Data Validation
Select cells with validation
Ctrl+G›Special›Data validation
⌘+G›Special›Data validation
Go To Special — Same formatting
Select cells with same format
Ctrl+G›Special›Same format
⌘+G›Special›Same format
Cell edit mode
Shortcut
Windows
Mac
Start formula
Begin with =
=
=
Absolute/relative refs
Cycle $A$1 / A$1 / $A1 / A1
F4 (while editing)
⌘+T (while editing)
Evaluate selection
Evaluate part of formula
F9 (selection)
F9 (selection)
Insert Function
Open Insert Function
Shift+F3
Shift+F3
Paste Name
Paste defined name
F3
F3
Entering data
Shortcut
Windows
Mac
Insert current date
Static date
Ctrl+;
Ctrl+;
Insert current time
Static time
Ctrl+Shift+;
Ctrl+Shift+;
Fill down
Copy from above
Ctrl+D
⌘+D
Fill right
Copy from left
Ctrl+R
⌘+R
Copy value from above
Value only
Ctrl+Shift+"
⌘+Shift+"
Copy formula from above
Formula only
Ctrl+'
⌘+'
AutoSum
Insert SUM()
Alt+=
⌘+Shift+T
Repeat last action
Repeat command
F4
⌘+Y
Pick from list
Use existing entries
Alt+↓
Option+↓
Spell check
Check spelling
F7
F7
Thesaurus
Open thesaurus
Shift+F7
Shift+F7
Flash Fill
Automatically fill pattern
Ctrl+E
⌘+E
Formatting
Shortcut
Windows
Mac
Format Cells dialog
Open full formatting dialog
Ctrl+1
⌘+1
Bold
Toggle bold
Ctrl+B
⌘+B
Italic
Toggle italic
Ctrl+I
⌘+I
Underline
Toggle underline
Ctrl+U
⌘+U
Strikethrough
Toggle strikethrough
Ctrl+5
⌘+Shift+X
Increase font size
Increase font size
Ctrl+Shift+>
⌘+Shift+>
Decrease font size
Decrease font size
Ctrl+Shift+<
⌘+Shift+<
Left align
Left align
Ctrl+L
⌘+L
Center text
Center align
Ctrl+E
⌘+E
Right align
Right align
Ctrl+R
⌘+R
Wrap Text
Toggle wrap text
Alt+H›W
Merge & Center
Merge selected cells and center
Alt+H›M›C
Alignment: Top Align
Top Align via Ribbon
Alt+H›A›T
Alignment: Middle Align
Middle Align via Ribbon
Alt+H›A›M
Alignment: Bottom Align
Bottom Align via Ribbon
Alt+H›A›B
Increase Indent
Increase indent
Alt+H›6
Decrease Indent
Decrease indent
Alt+H›5
Orientation: Rotate Text Up
Rotate text up
Alt+H›FQ
Clear Formats
Clear formats
Alt+H›E›F
Borders: Outside
Apply outside border
Alt+H›B›S
Borders: No Border
Remove borders
Alt+H›B›N
Borders: Thick Box
Thick box border
Alt+H›B›T
Format Painter (Copy)
Copy formatting
Ctrl+Shift+C
⌘+Shift+C
Format Painter (Paste)
Apply copied formatting
Ctrl+Shift+V
⌘+Shift+V
Paste Values
Paste values only
Alt+H›V›V
Paste Formulas
Paste formulas
Alt+H›V›F
Paste Formatting
Paste formats
Alt+H›V›R
Paste Transpose
Paste transposed
Alt+H›V›T
Clear All
Clear all (contents & formats)
Alt+H›E›A
Clear Contents (Ribbon)
Clear values only
Alt+H›E›C
Wrap Text (Toggle)
Wrap text on/off
Alt+H›W
Decrease Decimal Places
Decrease decimals
Alt+H›9
Increase Decimal Places
Increase decimals
Alt+H›0
Number Format: General
Apply General format
Ctrl+Shift+~
Ctrl+Shift+~
Number Format: Currency
Apply Currency format
Ctrl+Shift+$
Ctrl+Shift+$
Number Format: Percent
Apply Percent format
Ctrl+Shift+%
Ctrl+Shift+%
Number Format: Date
Apply Date format
Ctrl+Shift+#
Ctrl+Shift+#
Number Format: Time
Apply Time format
Ctrl+Shift+@
Ctrl+Shift+@
Number Format: Scientific
Apply Scientific format
Ctrl+Shift+^
Ctrl+Shift+^
Number Formatting
Shortcut
Windows
Mac
General
Apply General
Ctrl+Shift+~
Ctrl+Shift+~
Number
Apply Number
Ctrl+Shift+!
Ctrl+Shift+!
Time
Apply Time
Ctrl+Shift+@
Ctrl+Shift+@
Date
Apply Date
Ctrl+Shift+#
Ctrl+Shift+#
Currency
Apply Currency
Ctrl+Shift+$
Ctrl+Shift+$
Percent
Apply Percent
Ctrl+Shift+%
Ctrl+Shift+%
Scientific
Apply Scientific
Ctrl+Shift+^
Ctrl+Shift+^
Increase decimal
Increase decimal places
Alt+H›0
Decrease decimal
Decrease decimal places
Alt+H›9
Borders
Shortcut
Windows
Mac
All Borders
all borders
Alt+H›B›A
⌘+1›Border
Outside Borders
outside borders
Alt+H›B›S
⌘+1›Border
Thick Outside Border
thick outside border
Alt+H›B›T
⌘+1›Border
No Border
no border
Alt+H›B›N
⌘+1›Border
Top Border
top border
Alt+H›B›P
⌘+1›Border
Bottom Border
bottom border
Alt+H›B›O
⌘+1›Border
Left Border
left border
Alt+H›B›L
⌘+1›Border
Right Border
right border
Alt+H›B›R
⌘+1›Border
Inside Borders
inside borders
Alt+H›B›I
⌘+1›Border
Inside Horizontal
inside horizontal
Alt+H›B›H
⌘+1›Border
Inside Vertical
inside vertical
Alt+H›B›V
⌘+1›Border
Formulas
Shortcut
Windows
Mac
Show/Hide formulas
Toggle formula view
Ctrl+`
Ctrl+`
Insert Function
Open function dialog
Shift+F3
Shift+F3
Calculate Now
Recalculate
F9
F9
Calculate Sheet
Recalc active sheet
Shift+F9
Shift+F9
Name Manager
Open Name Manager
Ctrl+F3
⌘+F3
Create Names from Selection
Create names by headers
Ctrl+Shift+F3
⌘+Shift+F3
Paste Name into formula
Paste a defined name
F3
F3
Define Name…
Define a name
Alt+M›M›D
Use in Formula…
Insert defined name
Alt+M›M›U
Error Checking…
Error checking dialog
Alt+M›X
Evaluate Formula…
Step through formula
Alt+M›V
Trace Precedents
Show precedent arrows
Alt+M›P
Trace Dependents
Show dependent arrows
Alt+M›D
Remove Arrows
Remove all arrows
Alt+M›A›A
Create from Selection
Create names from selection
Ctrl+Shift+F3
⌘+Shift+F3
Grid Operations
Shortcut
Windows
Mac
Insert row
Insert row above
Ctrl+Shift++
⌘+Shift+K
Delete row
Delete selected row
Ctrl+-
⌘+-
Insert column
Insert column left
Ctrl+Shift++
⌘+Shift+K
Delete column
Delete selected column
Ctrl+-
⌘+-
Hide row
Hide selected rows
Ctrl+9
⌘+9
Unhide rows
Unhide hidden rows
Ctrl+Shift+(
⌘+Shift+(
Hide column
Hide selected columns
Ctrl+0
⌘+0
Unhide columns
Unhide hidden columns
Ctrl+Shift+)
⌘+Shift+)
Clear contents
Delete cell contents
Delete
Delete
Insert cells dialog
Choose shift cells down/right
Ctrl+Shift+=
⌘+Shift+=
Clear: Clear All
Clear All via Ribbon
Alt+H›E›A
Clear: Clear Formats
Clear Formats via Ribbon
Alt+H›E›F
Clear: Clear Contents
Clear Contents via Ribbon
Alt+H›E›C
Clear: Clear Comments/Notes
Clear Comments/Notes via Ribbon
Alt+H›E›M
Format: Row Height…
Row Height… via Ribbon
Alt+H›O›H
Format: Column Width…
Column Width… via Ribbon
Alt+H›O›W
Format: AutoFit Row Height
AutoFit Row Height via Ribbon
Alt+H›O›A
Format: AutoFit Column Width
AutoFit Column Width via Ribbon
Alt+H›O›O
Format: Hide Rows
Hide Rows via Ribbon
Alt+H›O›R
Format: Unhide Rows
Unhide Rows via Ribbon
Alt+H›O›U
Format: Hide Columns
Hide Columns via Ribbon
Alt+H›O›C
Format: Unhide Columns
Unhide Columns via Ribbon
Alt+H›O›H
Set Row Height…
Open row height dialog
Alt+H›O›H
Set Column Width…
Open column width dialog
Alt+H›O›W
Insert Cells…
Open insert cells dialog
Ctrl+Shift+=
⌘+Shift+=
Set Print Area
Set print area
Alt+P›R›S
Clear Print Area
Clear print area
Alt+P›R›C
Pivot Tables
Shortcut
Windows
Mac
Create PivotTable
Create Pivot from range
Alt+N›V
⌘+Option+P
Refresh PivotTable
Refresh selected pivot
Alt+F5
⌘+Option+F5
Insert: Insert PivotTable
Insert PivotTable via Ribbon
Alt+N›V
Insert PivotTable (Ribbon)
Create PivotTable
Alt+N›V
⌘+Option+P
Workbook
Shortcut
Windows
Mac
New worksheet
Insert new worksheet
Shift+F11
Shift+F11
Next workbook window
Cycle windows
Ctrl+Tab
⌘+`
Previous workbook window
Cycle windows backward
Ctrl+Shift+Tab
⌘+Shift+`
Move/Copy sheet…
Move or copy worksheet
Alt+E›M
Rename sheet
Rename active worksheet
Alt+H›O›R
Delete sheet
Delete active worksheet
Alt+H›D›S
View: Freeze Panes
Freeze Panes via Ribbon
Alt+W›F
View: New Window
New Window via Ribbon
Alt+W›N
View: Arrange All
Arrange All via Ribbon
Alt+W›A
View: Zoom
Zoom via Ribbon
Alt+W›Q
Protect Workbook…
Protect workbook structure
Alt+R›P›W
Share Workbook (legacy)
Legacy share dialog
Alt+R›W
Switch Windows
Switch to next window
Alt+W›W
Close Window
Close window
Ctrl+W
⌘+W
Print Area — Set
Set print area
Alt+P›R›S
Print Area — Clear
Clear print area
Alt+P›R›C
Page Break Preview
Toggle Page Break Preview
Alt+W›I
Page Layout View
Switch to Page Layout view
Alt+W›P
Split Panes
Split the window
Alt+W›S
Zoom to Selection
Zoom to selection
Alt+W›Q›S
Arrange All
Arrange windows
Alt+W›A
Freeze Top Row
Freeze top row
Alt+W›F›R
Freeze First Column
Freeze first column
Alt+W›F›C
Margins — Normal
Set margins to Normal
Alt+P›M›N
Orientation — Landscape
Landscape orientation
Alt+P›O›L
Orientation — Portrait
Portrait orientation
Alt+P›O›P
Print Titles…
Open Print Titles dialog
Alt+P›S›P
Protect Sheet…
Protect active sheet
Alt+R›P›S
Freeze Panes
Freeze panes
Alt+W›F›F
New Window
Open a new window
Alt+W›N
Set Print Area
Set print area
Alt+P›R›S
Clear Print Area
Clear print area
Alt+P›R›C
Background (Sheet)
Set sheet background
Alt+P›B
Custom Views…
Open Custom Views
Alt+W›C
Hide Window
Hide active window
Alt+W›H
Unhide Window
Unhide a window
Alt+W›U
Dialog boxes
Shortcut
Windows
Mac
Close dialog
Dismiss current dialog
Esc
Esc
OK / Accept
Confirm dialog
Enter
Enter
Next control
Move to next field
Tab
Tab
Previous control
Move to previous field
Shift+Tab
Shift+Tab
Other
Shortcut
Windows
Mac
Open Visual Basic Editor
VBA editor
Alt+F11
⌘+Option+F11
Run macro
Run selected macro
Alt+F8
⌘+Option+F8
Insert chart on new sheet
Chart on new sheet
F11
Fn+F11
Create chart in place
Chart in current sheet
Alt+F1
Insert: Insert Chart
Insert Chart via Ribbon
Alt+N›C
New Comment
Insert threaded comment
Shift+F2
Shift+F2
Recommended Charts
Insert Recommended Charts
Alt+N›R
Change Chart Type…
Change chart type dialog
Alt+N›J›T
Insert Chart
Insert chart
Alt+N›C
Insert Slicer
Insert slicer
Alt+N›S
Track Changes (Legacy)
Legacy Track Changes dialog
Alt+R›G
Smart Lookup
Smart Lookup
Alt+R›S
Total shortcuts rendered: 300