File Operations

Shortcut Windows Mac Web
Create new workbook CtrlN N CtrlN
Open workbook CtrlO O CtrlO
Save workbook CtrlS S CtrlS
Save as F12 ShiftS F12
Print file CtrlP P CtrlP
Print preview CtrlF2 P
Close current workbook CtrlW W CtrlW
Close Excel AltF4 Q

Basic Editing

Shortcut Windows Mac Web
Undo last action CtrlZ Z CtrlZ
Redo last action CtrlY Y CtrlY
Copy selected cells CtrlC C CtrlC
Cut selected cells CtrlX X CtrlX
Paste content CtrlV V CtrlV
Paste special dialog box CtrlAltV CtrlV
Find CtrlF F CtrlF
Find and replace CtrlH H CtrlH
Find next match ShiftF4
Find previous match CtrlShiftF4
Repeat last action F4 Y

Navigation

Shortcut Windows Mac Web
Move to next cell Tab Tab Tab
Move to previous cell ShiftTab ShiftTab ShiftTab
Move to edge of data upward Ctrl Ctrl
Move to edge of data downward Ctrl Ctrl
Move to edge of data left Ctrl Ctrl
Move to edge of data right Ctrl Ctrl
Go to cell A1 CtrlHome Home CtrlHome
Go to last cell CtrlEnd End CtrlEnd
Move one screen up PgUp PgUp PgUp
Move one screen down PgDn PgDn PgDn
Move one screen right AltPgDn OptionPgDn
Move one screen left AltPgUp OptionPgUp
Go back to hyperlink CtrlGEnter GEnter

Selection

Shortcut Windows Mac Web
Select entire column CtrlSpace Space CtrlSpace
Select entire row ShiftSpace ShiftSpace ShiftSpace
Select all cells CtrlA A CtrlA
Extend selection up one cell Shift Shift Shift
Extend selection down one cell Shift Shift Shift
Extend selection left one cell Shift Shift Shift
Extend selection right one cell Shift Shift Shift
Add adjacent cells to selection ShiftClick ShiftClick ShiftClick
Add non-adjacent cells to selection CtrlClick Click CtrlClick
Cancel selection Esc Esc Esc
Select array F5AltSA
Select dependents F5AltSDL
Select blank cells F5AltSK
Select column differences F5AltSM
Select precedents F5AltSPL
Select similar formatting F5AltSTE
Select similar validation F5AltSVE
Select row differences F5AltSW

Formatting

Shortcut Windows Mac Web
Format cells dialog Ctrl1 1
Toggle bold CtrlB B CtrlB
Toggle italic CtrlI I CtrlI
Toggle underline CtrlU U CtrlU
Toggle strikethrough Ctrl5 5
Align center AltHAC
Align left AltHAL
Align right AltHAR
Increase font size AltHFG
Decrease font size AltHFK
Add border outline CtrlShift7 Option0
Remove borders CtrlShift_

Number Formatting

Shortcut Windows Mac Web
Apply general format CtrlShift~ Shift~
Apply number format CtrlShift1 Shift1
Apply currency format CtrlShift4 Shift$
Apply percentage format CtrlShift5 Shift5
Apply date format CtrlShift# Shift#
Apply time format CtrlShift@ Shift@
Apply scientific format CtrlShift^ Shift^

Data Entry

Shortcut Windows Mac Web
Edit active cell F2 F2 F2
Insert current date Ctrl; ;
Insert current time CtrlShift; Shift;
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" Shift"
Add hyperlink CtrlK K
Flash fill CtrlE E
Complete entry in cell CtrlEnter Enter CtrlEnter
Insert line break in cell AltEnter OptionEnter

Grid Operations

Shortcut Windows Mac Web
Insert rows/columns CtrlShift+ Shift+
Delete rows/columns Ctrl- -
Hide columns Ctrl0 0
Hide rows Ctrl9 9
Unhide columns CtrlShift0 Shift0
Unhide rows CtrlShift9 Shift9
Group rows or columns AltShift OptionShift
Ungroup rows or columns AltShift OptionShift
Zoom in CtrlAlt+ Option+
Zoom out CtrlAlt- Option-

Workbook Management

Shortcut Windows Mac Web
Insert new worksheet ShiftF11 ShiftF11
Go to next worksheet CtrlPgDn FnPgDn
Go to previous worksheet CtrlPgUp FnPgUp
Move to next workbook CtrlTab `
Move to previous workbook CtrlShiftTab Shift`
Toggle full screen CtrlShiftF1 ShiftF1
Toggle scroll lock ScrLk

Advanced Features

Shortcut Windows Mac Web
Insert pivot table AltNV
Create embedded chart AltF1
Create chart in sheet F11 F11
Text to columns AltAE
Insert table CtrlT T
Toggle filter CtrlShiftL ShiftF
Insert or edit comment ShiftF2 ShiftF2
Open Visual Basic Editor AltF11 OptionF11
Show formulas Ctrl` `
Calculate all worksheets F9 F9
Calculate active worksheet ShiftF9 ShiftF9

Ribbon Navigation

Charts and Graphs

Conditional Formatting

Paste Special

Shortcut Windows Mac Web
Skip blanks CtrlAltVB
Paste comments CtrlAltVC
Paste with addition CtrlAltVD
Paste with division CtrlAltVI
Paste with multiplication CtrlAltVM
Paste data validation CtrlAltVN
Paste with subtraction CtrlAltVS

Data Analysis

Formula Functions

Shortcut Windows Mac Web
Calculate average AltHUA
Count numbers AltHUC
Find minimum value AltHUI
Find maximum value AltHUM
Remove formula arrows AltMAA
Trace dependents AltMD
Trace precedents AltMP
Calculate all workbooks CtrlAltF9 OptionF9

Display Options

Shortcut Windows Mac Web
Freeze panes AltWFF
Page break preview AltWI
Normal view AltWL
Open zoom dialog AltWQ
Toggle gridlines AltWVG
Show/hide formulas Ctrl` `
Show/hide objects Ctrl6 6
Expand/collapse ribbon CtrlF1 F1