Excel Shortcut
Back
Create New Workbook
Ctrl + N
or
⌘ + N
Open Workbook
Ctrl + O
or
⌘ + O
Save Workbook
Ctrl + S
or
⌘ + S
Save As
F12
or
⌘ + ⇧S
Print File
Ctrl + P
or
⌘ + P
Open Print Preview Window
Ctrl + F2
or
Close current workbook
Close Current Workbook
Ctrl + F4
or
⌘ + W
Close Excel
Alt + F4
or
⌘ + Q
Expand Or Collapse Ribbon
Ctrl + F1
or
⌘ + ⌥R
Activate Access Keys
Alt +
or
Move to next ribbon control
Move To Next Ribbon Control
Tab
or
Tab
Activate Or Open Selected Control
Space
or
Space
Confirm Control Change
Enter
or
Return
Get Help On Selected Control
F1
or
General
Open Help
F1
or
⌘ + /
Undo Last Action
Ctrl + Z
or
⌘ + Z
Redo Last Action
Ctrl + Y
or
⌘ + Y
Copy Selected Cells
Ctrl + C
or
⌘ + C
Repeat Last Action
F4
or
⌘ + Y
Cut Selected Cells
Ctrl + X
or
⌘ + X
Paste Content From Clipboard
Ctrl + V
or
⌘ + V
Display The Paste Special Dialog Box
Ctrl + Alt + V
or
⌃⌘ + V
Display Find And Replace
Ctrl + F
or
⌘ + F
Display Find And Replace, Replace Selected
Ctrl + H
or
⌃H
Find Next Match
Shift + F4
or
⌘ + G
Find Previous Match
Ctrl + Shift + F4
or
⌘ + ⇧G
Create Embedded Chart
Alt + F1
or
Fn + ⌥F1
Create Chart In New Worksheet
F11
or
Fn + F11
Toggle Autofilter
Ctrl + Shift + L
or
⌘ + ⇧F
Activate Filter
Alt + ↓
or
⌥↓
Insert Table
Ctrl + T
or
⌃T
Select Table Row
Shift + Space
or
⇧Space
Select Table Column
Ctrl + Space
or
⌃Space
Select Table
Ctrl + A
or
⌘ + A
Drag And Cut
drag
or
drag
Drag And Copy
Ctrl + drag
or
⌥drag
Drag And Insert
Shift + drag
or
⇧drag
Drag And Insert Copy
Ctrl + Shift + drag
or
⌥⇧drag
Drag To Worksheet
Alt + drag
or
⌘ + drag
Drag To Duplicate Worksheet
Ctrl + drag
or
⌥drag
Move One Cell Right
→
or
→
Move One Cell Left
←
or
←
Move One Cell Up
↑
or
↑
Move One Cell Down
↓
or
↓
Move One Screen Right
Alt + PgDn
or
Fn + ⌥↓
Move One Screen Left
Alt + PgUp
or
Fn + ⌥↑
Move One Screen Up
PgUp
or
Fn + ↑
Move One Screen Down
PgDn
or
Fn + ↓
Move To Right Edge Of Data Region
Ctrl + →
or
⌃→
Move To Left Edge Of Data Region
Ctrl + ←
or
⌃←
Move To Top Edge Of Data Region
Ctrl + ↑
or
⌃↑
Move To Bottom Edge Of Data Region
Ctrl + ↓
or
⌃↓
Move To Beginning Of Row
Home
or
Fn + ←
Move To Last Cell In Worksheet
Ctrl + End
or
Fn + ⌃→
Move To First Cell In Worksheet
Ctrl + Home
or
Fn + ⌃←
Turn End Mode On
End
or
Fn + →
Select Entire Row
Shift + Space
or
⇧Space
Select Entire Column
Ctrl + Space
or
⌃Space
Select Entire Worksheet
Ctrl + A
or
⌘ + A
Add Adjacent Cells To Selection
Shift + Click
or
⇧Click
Add Non-Adjacent Cells To Selection
Ctrl + Click
or
⌘ + Click
Same Selection In Next Column
⌥Tab
or
Same selection in previous column
Same Selection In Previous Column
⌥⇧Tab
or
Move right between non-adjacent selections
Move Right Between Non-Adjacent Selections
Ctrl + Alt + →
or
⌃⌥→
Move Left Between Non-Adjacent Selections
Ctrl + Alt + ←
or
⌃⌥←
Toggle Add To Selection Mode
Shift + F8
or
Fn + ⇧F8
Cancel Selection
Esc
or
Esc
Select Active Cell Only
Shift + Backspace
or
⇧Delete
Show The Active Cell On Worksheet
Ctrl + Backspace
or
⌘ + Delete
Move Active Cell Clockwise In Selection
Ctrl + .
or
⌃.
Move Active Cell Down In Selection
Enter
or
Return
Move Active Cell Up In Selection
Shift + Enter
or
⇧Return
Move Active Cell Right In A Selection
Tab
or
Tab
Move Active Cell Left In A Selection
Shift + Tab
or
⇧Tab
Extend Selection By One Cell Right
Shift + →
or
⇧→
Extend Selection By One Cell Left
Shift + ←
or
⇧←
Extend Selection By One Cell Up
Shift + ↑
or
⇧↑
Extend Selection By One Cell Down
Shift + ↓
or
⇧↓
Extend The Selection To The Last Cell Right
Ctrl + Shift + →
or
⌃⇧→
Extend The Selection To The Last Cell Left
Ctrl + Shift + ←
or
⌃⇧←
Extend The Selection To The Last Cell Up
Ctrl + Shift + ↑
or
⌃⇧↑
Extend The Selection To The Last Cell Down
Ctrl + Shift + ↓
or
⌃⇧↓
Extend Selection Up One Screen
Shift + PgUp
or
Fn + ⇧↑
Extend Selection Down One Screen
Shift + PgDn
or
Fn + ⇧↓
Extend Selection Right One Screen
Alt + Shift + PgDn
or
Fn + ⇧⌘ + ↓
Extend Selection Left One Screen
Alt + Shift + PgUp
or
Fn + ⇧⌘ + ↑
Extend Selection To Start Of Row
Shift + Home
or
Fn + ⇧←
Extend Selection To First Cell In Worksheet
Ctrl + Shift + Home
or
Fn + ⌃⇧←
Extend Selection To Last Cell In Worksheet
Ctrl + Shift + End
or
Fn + ⌃⇧→
Toggle Extend Selection Mode
F8
or
Fn + F8
Display 'Go To' Dialog Box
Ctrl + G
or
⌃G
Select Cells With Comments
Ctrl + Shift + O
or
Fn + ⌃⇧O
Select Current Region Around Active Cell
Ctrl + Shift + *
or
⇧⌃Space
Select Current Region
Ctrl + A
or
⌘ + A
Select Current Array
Ctrl + /
or
⌃/
Select Row Differences
Ctrl + \
or
⌃\
Select Column Differences
Ctrl + Shift + |
or
⌃⇧|
Select Direct Precedents
Ctrl + [
or
⌃[
Select All Precedents
Ctrl + Shift + {
or
⌃⇧{
Select Direct Dependents
Ctrl + ]
or
⌃]
Select All Dependents
Ctrl + Shift + }
or
⌃⇧}
Select Visible Cells Only
Alt + ;
or
⌘ + ⇧Z
Edit The Active Cell
F2
or
⌃U
Insert Or Edit Comment
Shift + F2
or
Fn + ⇧F2
Cancel Entry
Esc
or
Esc
Select One Character Right
Shift + →
or
⇧→
Select One Character Left
Shift + ←
or
⇧←
Move One Word Right
Ctrl + →
or
⌃→
Move One Word Left
Ctrl + ←
or
⌃←
Select One Word Right
Ctrl + Shift + →
or
⌃⇧→
Select One Word Left
Ctrl + Shift + ←
or
⌃⇧←
Select To Beginning Of Cell
Shift + Home
or
Fn + ⇧←
Select To End Of Cell
Shift + End
or
Fn + ⇧→
Delete To End Of Line
Ctrl + Delete
or
⌃Delete
Delete Character To The Left Of Cursor
Backspace
or
Delete
Delete Character To The Right Of Cursor
Delete
or
Fn + Delete
Start A New Line In The Same Cell
Alt + Enter
or
⌃⌥Return
Enter And Move Down
Enter
or
Return
Enter And Move Up
Shift + Enter
or
⇧Return
Enter And Move Right
Tab
or
Tab
Enter And Move Left
Shift + Tab
or
⇧Tab
Complete Entry And Stay In Same Cell
Ctrl + Enter
or
⌃Return
Enter Same Data In Multiple Cells
Ctrl + Enter
or
⌃Return
Insert Current Date
Ctrl + ;
or
⌃;
Insert Current Time
Ctrl + Shift + :
or
⌃⇧:
Fill Down From Cell Above
Ctrl + D
or
⌃D
Fill Right From Cell Left
Ctrl + R
or
⌃R
Copy Formula From Cell Above
Ctrl + '
or
⌃'
Copy Value From Cell Above
Ctrl + Shift + "
or
⌃⇧"
Add Hyperlink
Ctrl + K
or
⌘ + K
Display Autocomplete List
Alt + ↓
or
⌥↓
Flash Fill
Ctrl + E
or
Formatting
Format (Almost) Anything
Ctrl + 1
or
⌘ + 1
Display Format Cells With Font Tab Selected
Ctrl + Shift + F
or
⌃⇧F
Apply Or Remove Bold Formatting
Ctrl + B
or
⌘ + B
Apply Or Remove Italic Formatting
Ctrl + I
or
⌘ + I
Apply Or Remove Underscoring
Ctrl + U
or
⌘ + U
Apply Or Remove Strikethrough Formatting
Ctrl + 5
or
⌘ + ⇧X
Add Or Remove The Shadow Font Style
⌘⇧W
or
Add or remove the outline font style
Add Or Remove The Outline Font Style
⌘⇧D
or
Align center
Align Center
Alt + HAC
or
⌘ + E
Align Left
Alt + HAL
or
⌘ + L
Align Right
Alt + HAR
or
⌘ + R
Indent
Alt + H6
or
⌃⌥Tab
Remove Indent
Alt + H5
or
⌃⌥⇧Tab
Increase Font Size One Step
Alt + HFG
or
⌘ + ⇧>
Decrease Font Size One Step
Alt + HFK
or
⌘ + ⇧<
Apply General Format
Ctrl + Shift + ~
or
⌃⇧~
Apply Currency Format
Ctrl + Shift + $
or
⌃⇧$
Apply Percentage Format
Ctrl + Shift + %
or
⌃⇧%
Apply Scientific Format
Ctrl + Shift + ^
or
⌃⇧^
Apply Date Format
Ctrl + Shift + #
or
⌃⇧#
Apply Time Format
Ctrl + Shift + @
or
⌃⇧@
Apply Number Format
Ctrl + Shift + !
or
⌃⇧!
Add Border Outline
Ctrl + Shift + &
or
⌘ + ⌥0
Add Or Remove Border Right
Alt + R
or
⌘ + ⌥→
Add Or Remove Border Left
Alt + L
or
⌘ + ⌥←
Add Or Remove Border Top
Alt + T
or
⌘ + ⌥↑
Add Or Remove Border Bottom
Alt + B
or
⌘ + ⌥↓
Add Or Remove Border Upward Diagonal
Alt + D
or
Add or remove border horizontal interior
Add Or Remove Border Horizontal Interior
Alt + H
or
Add or remove border vertical interior
Add Or Remove Border Vertical Interior
Alt + V
or
Remove borders
Remove Borders
Ctrl + Shift + _
or
⌘ + ⌥_
Toggle Absolute And Relative References
F4
or
⌘ + T
Open The Insert Function Dialog Box
Shift + F3
or
Fn + ⇧F3
Autosum Selected Cells
Alt + =
or
⌘ + ⇧T
Toggle Formulas On And Off
Ctrl + `
or
⌃`
Insert Function Arguments
Ctrl + Shift + A
or
⌃⇧A
Enter Array Formula
Ctrl + Shift + Enter
or
⌃⇧Return
Calculate Worksheets
F9
or
Fn + F9
Calculate Active Worksheet
Shift + F9
or
Fn + ⇧F9
Force Calculate All Worksheets
Ctrl + Alt + F9
or
Evaluate part of a formula
Evaluate Part Of A Formula
F9
or
Fn + F9
Expand Or Collapse The Formula Bar
Ctrl + Shift + U
or
⌃⇧U
Display Function Arguments Dialog Box
Ctrl + A
or
⌃A
Define Name
Ctrl + F3
or
Fn + ⌃F3
Define Name Using Row And Column Labels
Ctrl + Shift + F3
or
Fn + ⌃⇧F3
Paste Name Into Formula
F3
or
Accept function with autocomplete
Accept Function With Autocomplete
Tab
or
↓Tab
Display Insert Dialog Box
Ctrl + Shift + +
or
⌃I
Insert Rows
Ctrl + Shift + +
or
⌃I
Insert Columns
Ctrl + Shift + +
or
⌃I
Display Delete Dialog Box
Ctrl + -
or
⌃-
Delete Rows
Ctrl + -
or
⌃-
Delete Columns
Ctrl + -
or
⌃-
Delete Cells
Ctrl + -
or
⌃-
Delete Contents Of Selected Cells
Delete
or
Fn + Delete
Hide Columns
Ctrl + 0
or
⌃0
Hide Rows
Ctrl + 9
or
⌃9
Unhide Rows
Ctrl + Shift + 9
or
⌃⇧9
Unhide Columns
Ctrl + Shift + 0
or
⌃⇧0
Group Rows Or Columns
Alt + Shift + →
or
⌘ + ⇧K
Ungroup Rows Or Columns
Alt + Shift + ←
or
⌘ + ⇧J
Open Group Dialog Box
Alt + Shift + →
or
⌘ + ⇧K
Open Ungroup Dialog Box
Alt + Shift + ←
or
⌘ + ⇧J
Hide Or Show Outline Symbols
Ctrl + 8
or
⌃8
Select Entire Pivot Table
Ctrl + A
or
⌘ + A
Toggle Pivot Table Field Checkbox
Space
or
Space
Group Pivot Table Items
Alt + Shift + →
or
⌘ + ⇧K
Ungroup Pivot Table Items
Alt + Shift + ←
or
⌘ + ⇧J
Hide Pivot Table Item
Ctrl + -
or
Ctrl-
Create Pivot Chart On Same Worksheet
Alt + F1
or
Create pivot chart on new worksheet
Create Pivot Chart On New Worksheet
F11
or
Fn + F11
Open Pivot Table Wizard
Alt + DP
or
⌘ + ⌥P
Insert New Worksheet
Shift + F11
or
Fn + ⇧F11
Go To Next Worksheet
Ctrl + PgDn
or
Fn + ⌃↓
Go To Previous Worksheet
Ctrl + PgUp
or
Fn + ⌃↑
Move To Next Pane
F6
or
Fn + F6
Move To Previous Pane
Shift + F6
or
Fn + ⇧F6
Go To Next Workbook
Ctrl + Tab
or
⌃Tab
Go To Previous Workbook
Ctrl + Shift + Tab
or
⌃⇧Tab
Minimize Current Workbook Window
Ctrl + F9
or
⌘ + M
Maximize Current Workbook Window
Ctrl + F10
or
Fn + ⌃F10
Select Adjacent Worksheets
Shift + Click
or
⇧Click
Select Non-Adjacent Worksheets
Ctrl + Click
or
⌘ + Click
Toggle Scroll Lock
ScrLk
or
Fn + ⇧F14
Move To Next Control
Tab
or
Tab
Move To Previous Control
Shift + Tab
or
⇧Tab
Move To Next Tab
Ctrl + Tab
or
⌃Tab
Move To Previous Tab
Ctrl + Shift + Tab
or
⌃⇧Tab
Accept And Apply
Enter
or
Return
Check And Uncheck Box
Space
or
Space
Cancel And Close The Dialog Box
Esc
or
Esc
Open Spelling Dialog Box
F7
or
Fn + F7
Open Thesaurus Dialog Box
Shift + F7
or
Fn + ⇧F7
Open Macro Dialog Box
Alt + F8
or
Fn + ⌥F8
Open Vba Editor
Alt + F11
or
Fn + ⌥F11
Duplicate Object
Ctrl + D
or
⌘ + D
Snap To Grid
Alt +
or
⌘ +
Hide Or Show Objects
Ctrl + 6
or
⌃6
Display Modify Cell Style Dialog Box
Alt + '
or
⌘ + ⇧L
Display Shortcut Menu
Shift + F10
or
Fn + ⇧F10
Display Control Menu
Alt + Space
or
?
--> -->