#File
Shortcut Windows Mac
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
Shortcut Windows Mac
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
Shortcut Windows Mac
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 values CtrlShiftV ⌘⇧V
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 previous match CtrlShiftF4 ⌘⇧G
Find next match ShiftF4 ⌘G
Create embedded chart AltF1 Fn⌥F1
Create chart in new worksheet F11 FnF11
#Tables and Filters
Shortcut Windows Mac
Insert table CtrlT ⌘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
Open Custom Sort dialog box AltHSU ⌘⇧R
#Drag and Drop
Shortcut Windows Mac
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
Shortcut Windows Mac
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
Shortcut Windows Mac
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
Shortcut Windows Mac
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
Shortcut Windows Mac
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
Shortcut Windows Mac
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
Shortcut Windows Mac
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
Shortcut Windows Mac
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
Shortcut Windows Mac
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
Shortcut Windows Mac
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
Shortcut Windows Mac
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
Shortcut Windows Mac
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
Accept function with autocomplete Tab Tab
Paste name into formula F3 F3
#Grid Operations
Shortcut Windows Mac
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
Shortcut Windows Mac
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
Shortcut Windows Mac
Insert new worksheet ShiftF11 fn⇧F11
Go to next worksheet CtrlPgDn ⌥→
Go to previous worksheet CtrlPgUp ⌥←
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
Shortcut Windows Mac
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
Shortcut Windows Mac
Check spelling F7 FnF7
Open Thesaurus dialog box ShiftF7 Fn⇧F7
Open Macro dialog box AltF8 Fn⌥F8
Open Power Query Editor AltF12 Fn⌥F12
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 fn⇧F10
Display control menu AltSpace