Entering Data I
Enter and move down
⇧↵
Enter and move up
TAB
Enter and move right
⇧TAB
Enter and move left
^↵
Enter and stay in same cell
^;
Insert current date
^⇧;
Insert current time
Entering Data II
^↵
Enter same data in multiple cells
^D
Fill down from cell above
^R
Fill right from cell left
^'
Copy formula from cell above
^⇧'
Copy value from cell above
⌘K
Add hyperlink
⌥DOWN
Display autocomplete list
Row / Column Operations I
^I
Insert rows / columns
^-
Delete rows / columns
^-
Delete cells
^0
Hide columns
^9
Hide rows
^⇧9
Unhide rows
^⇧0
Unhide columns
Row / Column Operations II
⌘⇧K
Group rows or columns
⌘⇧J
Ungroup rows or columns
^8
Hide or show outline symbols
⌘⌥=
Zoom in
⌘⌥-
Zoom out
General I
⌘/
Open help
⌘Z
Undo last action
⌘Y
Redo last action
⌘C
Copy cells
⌘X
Cut cells
⌘V
Paste
⌘^V
Paste special
⌘F
Find and replace
^H
Find and replace (replace selected)
General II
⌘G
Find next match
⌘⇧G
Find previous match
⌥F1
Create embedded chart
⌘⇧F
Toggle autofilter
⌥DOWN
Activate filter
^T
Insert table
⇧SPACE
Select table row
^SPACE
Select table column
⌘A
Select table
Navigation I
RIGHT
Move one cell right
LEFT
Move one cell left
UP
Move one cell up
DOWN
Move one cell down
⌥PAGEDOWN
Move one screen right
⌥PAGEUP
Move one screen left
Navigation II
PAGEUP
Move one screen up
PAGEDOWN
Move one screen down
HOME
Move to beginning of row
⌘END
Move to last cell in worksheet
^HOME
Move to first cell in worksheet
END
Turn end mode on
Selection
⇧SPACE
Select entire row
^SPACE
Select entire column
⌘A
Select entire worksheet
^⌥RIGHT
Move right between non-adjacent selections
^⌥LEFT
Move left between non-adjacent selections
⇧F8
Toggle add to selection mode
ESC
Cancel selection
Active Cell
⇧BACKSPACE
Select active cell only
⌘BACKSPACE
Show the active cell on worksheet
^.
Move active cell clockwise in selection
Move active cell down in selection
⇧↵
Move active cell up in selection
TAB
Move active cell right in a selection
⇧TAB
Move active cell left in a selection
Extend Selection
⇧RIGHT
Extend selection one cell right
⇧LEFT
Extend selection one cell left
⇧UP
Extend selection one cell up
⇧DOWN
Extend selection one cell down
^⇧LEFT
Extend selection to last cell left
⇧PAGEUP
Extend selection up one screen
⇧PAGEDOWN
Extend selection down one screen
⇧HOME
Extend selection to start of row
^⇧HOME
Extend selection to first cell in worksheet
^⇧END
Extend selection to last cell in worksheet
F8
Toggle extend selection mode
Formatting
⌘1
Format anything
^⇧F
Display format cells with font tab selected
⌘B
Toggle bold
⌘I
Toggle italic
⌘U
Toggle underscore
⌘⇧X
Toggle strikethrough
⌘E
Align center
⌘L
Align left
⌘R
Align right
^⌥TAB
Indent
^⌥⇧TAB
Remove indent
⌘⇧.
Increase font size
⌘⇧,
Decrease font size
Select Special
^G
Display Go To dialog box
^⇧SPACE
Select current region around active cell
⌘A
Select current region
^/
Select current array
^\
Select row differences
^⇧\
Select column differences
^[
Select direct precedents
^⇧[
Select all precedents
^]
Select direct dependents
^⇧]
Select all dependents
⌥;
Select visible cells only
Ribbon
⌘⌥R
Expand or collapse ribbon
TAB
Move to next ribbon control
SPACE
Activate or open selected ribbon control
Confirm ribbon control change
Cell Edit Mode
^U
Edit the active cell
⇧F2
Insert or edit comment
ESC
Cancel entry
^⌥↵
Start new line in same cell
Number Formatting
^⇧-
Apply general format
^⇧4
Apply currency format
^⇧5
Apply percentage format
^⇧6
Apply scientific format
^⇧3
Apply date format
^⇧2
Apply time format
^⇧1
Apply number format
Borders
⌘⌥0
Add border outline
⌘⌥DOWN
Toggle border bottom
⌘⌥UP
Toggle border top
⌘⌥⇧-
Remove borders
Formulas
⇧F3
Open insert function
^`
Toggle formulas on and off
^⇧A
Insert function arguments
^⇧↵
Enter array formula
F9
Evaluate part of a formula
^⇧U
Expand / collapse formula bar
^A
Display function arguments dialog
Pivot Tables
⌘A
Select entire pivot table
SPACE
Toggle pivot table field checkbox
⌘⇧K
Group pivot table items
⌘⇧J
Ungroup pivot table items
^-
Hide pivot table item
⌘⌥P
Open pivot table wizard
