Excel Keyboard Shortcuts Mac
Insert auto sum formula
command + shift + T
Edit active cell
control + U
fn + F2
Move to last used cell
command + arrow
Format cells menu
command + &
undo
command + Z
redo
command + Y
Create a table
control + T
Ribbon --> Home
option H
Ribbon --> Insert
option N
Fill colour
option H H
Data validation
option A V
Ribbon --> Data
option A
Ribbon --> Page Layout
option P
view gridlines
option P V G
Open excel preferences
command + comma (,)
Save
command + S
Increase decimals
option 1
Decrease decimals
option 2
move to different sheet
option + arrow L/R
zoom in/out
control + scroll down/up
fill right
command + R
italic
command + I
font size
option H F S
bold
command + B
underline
command + U
borders
option H B
year formatting (actual vs forecasted)
number custom 0"A" and 0"F"
paste special
command + option + V
(alt H V S)
format row/column width
option H O
repeat last action
fn + F4
format number with 2 decimals and thousand separator
control + shift + 1
format number into %
control + shift + 5
font colour
option H F C
freeze panes
option W F
Ribbon --> View
option W
page up / down
fn + arrow U/D
select entire row
shift + spacebar
select entire column
control + spacebar
Ribbon --> Formulas
option M
namebox
option M M
align center text
option H A C
conditional formatting
option H L
(un)lock cell references ($)
fn + F4
be able to select a cell while writing a formula in a cell
fn + F2
move to beginning/end of in-cell text
fn + arrow L/R
move pc windows
control + arrow L/R
insert row/column
command + shift + plus (+)
navigational column
enter a space next to each heading
trace precedents
option M P
remove tracing precedent arrows
option M A
row grouping
shift + option + arrow R
open grouped rows
option A J
close grouped rows
option A H 1
page break preview
option W I
normal view
option W L
edit page setup for printing
option P S P
trace dependents
option M D
add worksheet
fn + shift + F11
select all adjacent cells
command + A
fill down
command + D
find & replace
control + H
exit/enter full page
fn + F
delete row/column
command + minus (-)
strikethrough
command + shift + X
erase all
option H E
insert image
option N P 1
data table
option A W
zoom to selection
option W G
zoom to 100%
option W J
enter same value in selection of cells
control + enter
go to
fn + F5
control + G
show formulas
option M H
collapse ribbon
command + option + R
Ribbon --> Developer
option L
combo box
option L C O
pivot table
option N V
sparklines
option N Y 5
save as
fn + F12
insert comment
fn + shift + F2
insert link
option N I