File

Create new workbook

CtrlN
⌘N
Open workbook
CtrlO
⌘O
Save workbook
CtrlS
⌘S
Save as
F12
⌘⇧S
Print file
CtrlP
⌘P
Open print preview window
CtrlF2
Close current workbook
CtrlF4
⌘W
Close Excel
AltF4
⌘Q

Ribbon
Expand or collapse ribbon
CtrlF1
⌘⌥R
Activate access keys
Alt
Move to next ribbon control
Tab
Tab
Activate or open selected control
Space
Space
Confirm control change
Enter
Return
Get help on selected control
F1

General
Open help
F1
⌘/
Undo last action
CtrlZ
⌘Z
Redo last action
CtrlY
⌘Y
Copy selected cells
CtrlC
⌘C
Cut selected cells
CtrlX
⌘X
Paste content from clipboard
CtrlV
⌘V
Display the Paste Special dialog box
CtrlAltV
⌃⌘V
Display find and replace
CtrlF
⌘F
Display find and replace, replace selected
CtrlH
⌃H
Find next match
ShiftF4
⌘G
Find previous match
CtrlShiftF4
⌘⇧G
Create embedded chart
AltF1
Fn⌥F1
Create chart in new worksheet
F11
FnF11
Toggle Autofilter
CtrlShiftL
⌘⇧F
Activate filter
Alt↓
⌥↓
Insert table
CtrlT
⌃T
Select table row
ShiftSpace
⇧Space
Select table column
CtrlSpace
⌃Space
Select table
CtrlA
⌘A

Drag and Drop

Drag and cut
drag
drag
Drag and copy
Ctrldrag
⌥drag
Drag and insert
Shiftdrag
⇧drag
Drag and insert copy
CtrlShiftdrag
⌥⇧drag
Drag to worksheet
Altdrag
⌘drag
Drag to duplicate worksheet
Ctrldrag
⌥drag

Navigation
Move one cell right
→
→
Move one cell left
←
←
Move one cell up
↑
↑
Move one cell down
↓
↓
Move one screen right
AltPgDn
Fn⌥↑
Move one screen left
AltPgUp
Fn⌥↓
Move one screen up
PgUp
Fn↑
Move one screen down
PgDn
Fn↓
Move to right edge of data region
Ctrl→
⌃→
Move to left edge of data region
Ctrl←
⌃←
Move to top edge of data region
Ctrl↑
⌃↑
Move to bottom edge of data region
Ctrl↓
⌃↓
Move to beginning of row
Home
Fn←
Move to last cell in worksheet
CtrlEnd
Fn⌃→
Move to first cell in worksheet
CtrlHome
Fn⌃←
Turn End mode on
End
Fn→

Selection
Select entire row
ShiftSpace
⇧Space
Select entire column
CtrlSpace
⌃Space
Select entire worksheet
CtrlA
⌘A
Add adjacent cells to selection
ShiftClick
⇧Click
Add non-adjacent cells to selection
CtrlClick
⌘Click
Same selection in next column
⌥Tab
Same selection in previous column
⌥⇧Tab
Move right between non-adjacent selections
CtrlAlt→
⌃⌥→
Move left between non-adjacent selections
CtrlAlt←
⌃⌥←
Toggle add to selection mode
ShiftF8
Fn⇧F8
Cancel selection
Esc
Esc

Active Cell
Select active cell only
ShiftBackspace
⇧Delete
Show the active cell on worksheet
CtrlBackspace
⌘Delete
Move active cell clockwise in selection
Ctrl.
⌃.
Move active cell down in selection
Enter
Return
Move active cell up in selection
ShiftEnter
⇧Return
Move active cell right in a selection
Tab
Tab
Move active cell left in a selection
ShiftTab
⇧Tab

Extend Selection
Extend selection by one cell right
Shift→
⇧→
Extend selection by one cell left
Shift←
⇧←
Extend selection by one cell up
Shift↑
⇧↑
Extend selection by one cell down
Shift↓
⇧↓
Extend the selection to the last cell right
CtrlShift→
⌃⇧→
Extend the selection to the last cell left
CtrlShift←
⌃⇧←
Extend the selection to the last cell up
CtrlShift↑
⌃⇧↑
Extend the selection to the last cell down
CtrlShift↓
⌃⇧↓
Extend selection up one screen
ShiftPgUp
Fn⇧↑
Extend selection down one screen
ShiftPgDn
Fn⇧↓
Extend selection to start of row
ShiftHome
Fn⇧←
Extend selection to first cell in worksheet
CtrlShiftHome
Fn⌃⇧←
Extend selection to last cell in worksheet
CtrlShiftEnd
Fn⌃⇧→
Toggle extend selection mode
F8
FnF8

Select Special
Display 'Go To' dialog box
CtrlG
⌃G
Select cells with comments
CtrlShiftO
Fn⌃⇧O
Select current region around active cell
CtrlShift*
⇧⌃Space
Select current region
CtrlA
⌘A
Select current array
Ctrl/
⌃/
Select row differences
Ctrl\
⌃\
Select column differences
CtrlShift|
⌃⇧|
Select direct precedents
Ctrl[
⌃[
Select all precedents
CtrlShift{
⌃⇧{
Select direct dependents
Ctrl]
⌃]
Select all dependents
CtrlShift}
⌃⇧}
Select visible cells only
Alt;
⌘⇧Z

Cell edit mode

Edit the active cell
F2
⌃U
Insert or edit comment
ShiftF2
Fn⇧F2
Cancel entry
Esc
Esc
Select one character right
Shift→
⇧→
Select one character left
Shift←
⇧←
Move one word right
Ctrl→
⌃→
Move one word left
Ctrl←
⌃←
Select one word right
CtrlShift→
⌃⇧→
Select one word left
CtrlShift←
⌃⇧←
Select to beginning of cell
ShiftHome
Fn⇧←
Select to end of cell
ShiftEnd
Fn⇧→
Delete to end of line
CtrlDelete
⌃Delete
Delete character to the left of cursor
Backspace
Delete
Delete character to the right of cursor
Delete
FnDelete
Start a new line in the same cell
AltEnter
⌃⌥Return

Entering data
Enter and move down
Enter
Return
Enter and move up
ShiftEnter
⇧Return
Enter and move right
Tab
Tab
Enter and move left
ShiftTab
⇧Tab
Complete entry and stay in same cell
CtrlEnter
⌃Return
Enter same data in multiple cells
CtrlEnter
⌃Return
Insert current date
Ctrl;
⌃;
Insert current time
CtrlShift:
⌃⇧:
Fill down from cell above
CtrlD
⌃D
Fill right from cell left
CtrlR
⌃R
Copy formula from cell above
Ctrl'
⌃'
Copy value from cell above
CtrlShift"
⌃⇧"
Add hyperlink
CtrlK
⌘K
Display AutoComplete list
Alt↓
⌥↓

Formatting
Format (almost) anything
Ctrl1
⌘1
Display Format Cells with Font tab selected
CtrlShiftF
Apply format again
F4
⌃Y
Apply or remove bold formatting
CtrlB
⌘B
Apply or remove italic formatting
CtrlI
⌘I
Apply or remove underscoring
CtrlU
⌘U
Apply or remove strikethrough formatting
Ctrl5
⌘⇧X
Add or remove the shadow font style

⌘⇧W
Add or remove the outline font style

⌘⇧D
Align center
AltHAC
⌘E
Align left
AltHAL
⌘L
Align right
AltHAR
⌘R
Indent
AltH6
⌃⌥Tab
Remove indent
AltH5
⌃⌥⇧Tab
Increase font size one step
AltHFG
⌘⇧>
Decrease font size one step
AltHFK
⌘⇧<

Number Formatting
Apply general format
CtrlShift~
⌃⇧~
Apply currency format
CtrlShift$
⌃⇧$
Apply percentage format
CtrlShift%
⌃⇧%
Apply scientific format
CtrlShift^
⌃⇧^
Apply date format
CtrlShift#
⌃⇧#
Apply time format
CtrlShift@
⌃⇧@
Apply number format
CtrlShift!
⌃⇧!

Borders
Add border outline
CtrlShift&
⌘⌥0
Add or remove border right
AltR
⌘⌥→
Add or remove border left
AltL
⌘⌥←
Add or remove border top
AltT
⌘⌥↑
Add or remove border bottom
AltB
⌘⌥↓
Add or remove border upward diagonal
AltD
Add or remove border horizontal interior
AltH
Add or remove border vertical interior
AltV
Remove borders
CtrlShift_
⌘⌥_

Formulas
Toggle absolute and relative references
F4
⌘T
Open the Insert Function Dialog Box
ShiftF3
Fn⇧F3
Autosum selected cells
Alt=
⌘⇧T
Toggle formulas on and off
Ctrl`
⌃`
Insert function arguments
CtrlShiftA
⌃⇧A
Enter array formula
CtrlShiftEnter
⌃⇧Return
Calculate worksheets
F9
FnF9
Calculate active worksheet
ShiftF9
Fn⇧F9
Force calculate all worksheets
CtrlAltF9
Evaluate part of a formula
F9
FnF9
Expand or collapse the formula bar
CtrlShiftU
⌃⇧U
Display function arguments dialog box
CtrlA
⌃A
Define name
CtrlF3
⌃L
Define name using row and column labels
CtrlShiftF3
⌃ShiftF3
Paste name into formula
F3
Accept function with autocomplete
Tab
↓Tab

Grid Operations
Display Insert Dialog box
CtrlShift+
⌃I
Insert rows
CtrlShift+
⌃I
Insert columns
CtrlShift+
⌃I
Display Delete dialog box
Ctrl-
⌃-
Delete rows
Ctrl-
⌃-
Delete columns
Ctrl-
⌃-
Delete cells
Ctrl-
⌃-
Delete contents of selected cells
Delete
FnDelete
Hide columns
Ctrl0
⌃0
Hide rows
Ctrl9
⌃9
Unhide rows
CtrlShift9
⌃⇧9
Unhide columns
CtrlShift0
⌃⇧0
Group rows or columns
AltShift→
⌘⇧K
Ungroup rows or columns
AltShift←
⌘⇧J
Open Group Dialog Box
AltShift→
⌘⇧K
Open Ungroup Dialog Box
AltShift←
⌘⇧J
Hide or show outline symbols
Ctrl8
⌃8

Pivot Tables
Select entire pivot table
CtrlA
⌘A
Toggle pivot table field checkbox
Space
Space
Group pivot table items
AltShift→
⌘⇧K
Ungroup pivot table items
AltShift←
⌘⇧J
Hide pivot table item
Ctrl-
Ctrl-
Create pivot chart on same worksheet
AltF1
Create pivot chart on new worksheet
F11
FnF11
Open pivot table wizard
AltDP
⌘⌥P

Workbook
Insert new worksheet
ShiftF11
⇧F11
Go to next worksheet
CtrlPgDn
Fn⌃↓
Go to previous worksheet
CtrlPgUp
Fn⌃↑
Move to next pane
F6
F6
Move to previous pane
ShiftF6
⇧F6
Go to next workbook
CtrlTab
⌃Tab
Go to previous workbook
CtrlShiftTab
⌃⇧Tab
Minimize current workbook window
CtrlF9
⌘M
Maximize current workbook window
CtrlF10
Select adjacent worksheets
ShiftClick
⇧Click
Select non-adjacent worksheets
CtrlClick
⌘Click
Dialog boxes
Move to next control
Tab
Tab
Move to previous control
ShiftTab
⇧Tab
Move to next tab
CtrlTab
⌃Tab
Move to previous tab
CtrlShiftTab
⌃⇧Tab
Accept and apply
Enter
Return
Check and uncheck box
Space
Space
Cancel and close the dialog box
Esc
Esc

Other
Open Spelling dialog box
F7
F7
Open Thesaurus dialog box
ShiftF7
⇧F7
Open Macro dialog box
AltF8
Fn⌥F8
Open VBA Editor
AltF11
Fn⌥F11
Duplicate object
CtrlD
⌘D
Snap to grid
Alt
⌘
Hide or show objects
Ctrl6
⌃6
Display Modify Cell Style dialog box
Alt'
⌘⇧L
Display shortcut menu
ShiftF10
Fn⇧F10
Display control menu
AltSpace
?
Can we ask you a favor? Can you please share this page if it's useful to you? Thanks!