Exceljet

Quick, clean, and to the point

222 Excel keyboard shortcuts for PC and Mac

Windows shortcuts in dark gray on the left, Mac shortcuts in white on the right. See also: The 54 Excel shortcuts you really should know and Excel shortcuts on the Mac.

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
Repeat last action
F4
⌘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 right one screen
AltShiftPgDn
Fn⇧⌘↓
Extend selection left one screen
AltShiftPgUp
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↓
⌥↓
Flash fill
CtrlE

Formatting

Format (almost) anything
Ctrl1
⌘1
Display Format Cells with Font tab selected
CtrlShiftF
⌃⇧F
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
Fn⌃F3
Define name using row and column labels
CtrlShiftF3
Fn⌃⇧F3
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
fn⇧F11
Go to next worksheet
CtrlPgDn
Fn⌃↓
Go to previous worksheet
CtrlPgUp
Fn⌃↑
Move to next pane
F6
FnF6
Move to previous pane
ShiftF6
Fn⇧F6
Go to next workbook
CtrlTab
⌃Tab
Go to previous workbook
CtrlShiftTab
⌃⇧Tab
Minimize current workbook window
CtrlF9
⌘M
Maximize current workbook window
CtrlF10
fn⌃F10
Select adjacent worksheets
ShiftClick
⇧Click
Select non-adjacent worksheets
CtrlClick
⌘Click
Toggle scroll lock
ScrLk
Fn⇧F14

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
FnF7
Open Thesaurus dialog box
ShiftF7
Fn⇧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!
These tutorials are fantastic. People like me learn faster by following along with the steps in the video. -Tim
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course

Excel video training

Quick, clean, and to the point.

Learn more