Exceljet

Quick, clean, and to the point

222 Excel shortcuts for Windows and Mac

Windows shortcuts on the left, Mac shortcuts on the right.
See also: 30 Excel Shortcuts in 12 minutes 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
CtrlW
⌘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 options
AltFT
⌘,
Open help
F1
⌘/
Undo last action
CtrlZ
⌘Z
Redo last action
CtrlY
⌘Y
Copy selected cells
CtrlC
⌘C
Repeat last action
F4
⌘Y
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

Tables and Filters

Insert table
⌃T
⌘T
Toggle Autofilter
CtrlShiftL
⌘⇧F
Activate filter
Alt↓
⌥↓
Select table row
ShiftSpace
⇧Space
Select table column
CtrlSpace
⌃Space
Select table
CtrlA
⌘A
Clear slicer filter
AltC
⌥C
Toggle table total row
CtrlShiftT
⌃⇧T

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→
Go back to hyperlink
CtrlGEnter
⌃GReturn

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
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
Fn⌃Delete
Delete character to the left of cursor
Backspace
Delete
Delete character to the right of cursor
Delete
FnDelete
Insert line break in 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
⌃E

Formatting

Format (almost) anything
Ctrl1
⌘1
Display Format Cells with Font tab selected
CtrlShiftF
⌃⇧F
Toggle bold formatting
CtrlB
⌘B
Toggle italic formatting
CtrlI
⌘I
Toggle underline formatting
CtrlU
⌘U
Toggle strikethrough formatting
Ctrl5
⌘⇧X
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
Open the Name Manager
CtrlF3
Fn⌃F3
Define name using row and column labels
CtrlShiftF3
Fn⌃⇧F3
Select name box
AltF3
Paste name into formula
F3
F3
Accept function with autocomplete
Tab
Tab

Grid Operations

Display Insert Dialog box
CtrlShift+
⌘⇧+
Insert rows
CtrlShift+
⌘⇧+
Insert columns
CtrlShift+
⌘⇧+
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
Zoom in
CtrlAlt+
⌥⌘+
Zoom out
CtrlAlt-
⌥⌘-
Zoom scroll
Ctrlscroll
^scroll

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
⌘`
Go to previous workbook
CtrlShiftTab
⌘⇧`
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
Toggle full screen
CtrlShiftF1
⌃⌘F

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

Check spelling
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 right-click menu
ShiftF10
Fn⇧F10
Insert or edit note
ShiftF2
Fn⇧F2
Insert threaded comment
CtrlShiftF2
Fn⌘⇧F2
Delete comment
ShiftF10D
fnShiftF10
Display control menu
AltSpace

Formulas | Functions | Videos | Shortcuts | Training