Description
Windows Shortcut
Mac Shortcut
New File
Ctrl + N ( not supported in chrome and safari )
Ctrl + N
Open File
Ctrl + O
Cmd + O
Save As File
Ctrl + Shift + S
Cmd + Shift + S
Print File
Ctrl + P
Cmd + P
Undo last action
Ctrl + Z
Cmd + Z
Redo last action
Ctrl + Y
Cmd + Y
Repeat last action
F4 (or) Ctrl + Y (or) Alt + Enter
F4 (or) Cmd + Y (or) Alt + Enter
Insert Rows
Ctrl + Alt + Plus
Ctrl + Alt + Plus
Insert Columns
Ctrl + Shift + Plus
Ctrl + Shift + Plus
Insert a new worksheet
Shift + F11
Run Macros / View Macros List
Alt + F8
Alt + F8
Open VBA Editor
Alt + F11
Alt + F11
Add / Edit Hyperlink
Ctrl + K
Cmd + K
Add / Edit cell note
Shift + F2
Shift + F2
Fill Down
Ctrl + D
Cmd + D
Fill to The Right
Ctrl + R
Cmd + R
Filter
Ctrl + Shift + L
Cmd + Shift + L
Format Cells
Ctrl + Shift + 1
Cmd + Shift + 1
Find within spreadsheet
Ctrl + F or F3
Cmd + F
Names Ranges
Ctrl + F3
Cmd + F3
Insert the current date in cell
Ctrl + ;
Cmd + ;
Insert the current time in cell
Ctrl + Shift + ;
Cmd + Shift + ;
Display the auto suggest list (Pick from List)
Alt + Down
Alt + Down
Toggle Auto Completion On / Off
Ctrl + Shift + Q
Ctrl + Shift + Q
Move to next cell in row
Tab
Tab
Move to previous cell in row
Shift + Tab
Shift + Tab
Up one screen
Page Up
Page Up
Down one screen
Page Down
Page Down
Go to first cell in data region
Ctrl + Home
Ctrl + Home
Go to last cell in data region
Ctrl + End
Ctrl + End
Go to cell command
Ctrl + G
Cmd + G
Data Region Left
Ctrl + Left
Cmd + Left
Data Region Right
Ctrl + Right
Cmd + Right
Data Region Down
Ctrl + Down
Cmd + Down
Data Region Up
Ctrl + Up
Cmd + Up
Focus Name Box
Ctrl + Shift + N
Cmd + Shift + N
Move to next worksheet in a spreadsheet
Alt + Right
Alt + Right
Move to previous worksheet in a spreadsheet
Alt + Left
Alt + Left
Edit active cell
F2
F2 (or) Ctrl+ U
Cancel cell entry
Esc Key
Esc Key
Focus Formula Field
Ctrl + Shift + F
Cmd + Shift + F
Delete selected cell / cell range
Delete
Delete
Delete one character to right while typing in a cell
Delete
Delete
Delete one character to left while typing in a cell
Backspace
Delete
Insert Line Break in Cell
Ctrl + Enter
Alt + Enter
Bold toggle for selection
Ctrl + B (or) Ctrl + Shift + 2
Cmd + B (or) Ctrl + Shift + 2
Italic toggle for selection
Ctrl + I (or) Ctrl + Shift + 3
Cmd + I (or) Ctrl + Shift + 3
Underline toggle for selection
Ctrl + U (or) Ctrl + Shift + 4
Cmd + U (or) Ctrl + Shift + 4
Strikethrough toggle for selection
Ctrl + Shift + 5
Ctrl + Shift + 5
Select whole spreadsheet
Ctrl + A
Cmd + A
Select column
Ctrl + Space
Ctrl + Space
Select row
Shift + Space
Shift + Space
Select from current cell to the first cell A1
Ctrl + Shift + Home
Ctrl + Shift + Home
Select from current cell to the last cell in the data region
Ctrl + Shift + End
Ctrl + Shift + End
Select from current cell to the first cell in the same row
Shift + Home
Shift + Home
Select from current cell to the last cell in the same row
Shift + End
Shift + End
Select Data Region to the Left
Ctrl + Shift + Left
Cmd + Shift + Left
Select Data Region to the Right
Ctrl + Shift + Right
Cmd + Shift + Right
Select Data Region Down
Ctrl + Shift + Down
Cmd + Shift + Down
Select Data Region Up
Ctrl + Shift + Up
Cmd + Shift + Up
Formula related shortcuts
Recalculate Formulas
F9
F9
Toggle absolute and relative references
F4
F4
Show Function Dialog Box
Shift + F3
Shift + F3
Toggle Expand and Collapse of Formula Bar
Ctrl + Shift + U
Cmd + Shift + U
Insert Array Formula on a range of cells
Ctrl + Shift + Enter
Ctrl + Shift + Enter
Select the range of array formula cells surrounding a cell
Ctrl + /
Ctrl + /
Select/Focus the object
Ctrl + Click
Cmd + Click
Move the selected object in the desired direction
Arrow keys
Arrow Keys
Snap the the object's left/top with the adjacent cell
Ctrl + Arrow keys
Cmd + Arrow Keys
Snap the the object's right/bottom with the adjacent cell
Ctrl + Shift + Arrow keys
Cmd + Shift + Arrow Keys
Navigate to the next object
Tab
Tab
Navigate to the previous object
Shift + Tab
Shift + Tab
Return the focus to the active cell
Esc
Esc
Cancel dragging the object
Esc
Esc
Shortcuts for Objects (Buttons, Images, Charts, etc)