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
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
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 content from clipboard CtrlV V
Paste values CtrlShiftV VV
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 FnF1
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
#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
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
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 FnF8
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 FnO
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 FnDelete
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
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! !
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_ _
Shortcut Windows Mac
Toggle absolute and relative references F4 T
Open the Insert Function Dialog Box ShiftF3 FnF3
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 FnF9
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 FnF3
Define name using row and column labels CtrlShiftF3 FnF3
Select name box AltF3
Paste name into formula F3 F3
Accept function with autocomplete Tab Tab
#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
Shortcut Windows Mac
Insert new worksheet ShiftF11 fnF11
Go to next worksheet CtrlPgDn Fn
Go to previous worksheet CtrlPgUp Fn
Move to next pane F6 FnF6
Move to previous pane ShiftF6 FnF6
Go to next workbook CtrlTab `
Go to previous workbook CtrlShiftTab `
Minimize current workbook window CtrlF9 M
Maximize current workbook window CtrlF10 fnF10
Select adjacent worksheets ShiftClick Click
Select non-adjacent worksheets CtrlClick Click
Toggle scroll lock ScrLk FnF14
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
Shortcut Windows Mac
Check spelling F7 FnF7
Open Thesaurus dialog box ShiftF7 FnF7
Open Macro dialog box AltF8 FnF8
Open VBA Editor AltF11 FnF11
Open Power Query Editor AltF12 FnF12
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 FnF10
Insert or edit note ShiftF2 FnF2
Insert threaded comment CtrlShiftF2 FnF2
Delete comment ShiftF10D fnF10
Display control menu AltSpace