Ctrl + N
|
File Operations
New File
|
Command + O
|
File Operations
Open file
|
Command + Shift + S
|
File Operations
Save As File
|
Command + P
|
File Operations
Print File
|
Command + Z
|
Actions
Undo last action
|
Command + Y
|
Actions
Redo last action
|
F4 / Command + Y / Option + Return
|
Actions
Repeat last action
|
Command + Shift + L
|
Actions
Filter
|
Command + R
|
Actions
Fill to The Right
|
Command + D
|
Actions
Fill Down
|
Shift + F2
|
Actions
Add / Edit cell note
|
Command + K
|
Actions
Add / Edit Hyperlink
|
Option + F11
|
Actions
Open VBA Editor
|
Option + F8
|
Actions
Run Macros / View Macros List
|
Shift + F11
|
Actions
Insert a new worksheet
|
Command + Shift + +
|
Actions
Insert Columns
|
Command + Option + +
|
Actions
Insert Rows
|
Command + X
|
Actions
Cut
|
Command + C
|
Actions
Copy
|
Command + V
|
Actions
Paste
|
Command + Shift + 1
|
Actions
Format Cells
|
Command + F / F3
|
Actions
Find within spreadsheet
|
Command + H
|
Actions
Replace
|
Command + F3
|
Actions
Names Ranges
|
Command + Shift + Q
|
Actions
Toggle Auto Completion On / Off
|
Option + Arrow Down
|
Actions
Display the auto suggest list (Pick from List)
|
Command + Shift + ;;
|
Actions
Insert the current time in cell
|
Command + ;
|
Actions
Insert the current date in cell
|
Command + Return
|
Editing Shortcuts
Insert Line Break in Cell
|
Del
|
Editing Shortcuts
Delete one character to left while typing in a cell
|
Delete
|
Editing Shortcuts
Delete one character to right/left while typing in a cell
|
Command + Shift + F
|
Editing Shortcuts
Focus Formula Field
|
Esc
|
Editing Shortcuts
Cancel cell entry
|
F2
|
Editing Shortcuts
Edit active cell
|
Command + B / Command + Shift + 2
|
Formatting Shortcuts
Bold toggle for selection
|
Command + I / Command + Shift + 3
|
Formatting Shortcuts
Italic toggle for selection
|
Command + Shift + 5
|
Formatting Shortcuts
Strikethrough toggle for selection
|
Command + U / Command + Shift + 4
|
Formatting Shortcuts
Underline toggle for selection
|
Command + Arrow Down
|
Navigate
Data Region Down
|
Command + Arrow Up
|
Navigate
Data Region Up
|
Command + Shift + N
|
Navigate
Focus Name Box
|
Option + Right Arrow
|
Navigate
Move to next worksheet in a spreadsheet
|
Option + Left Arrow
|
Navigate
Move to previous worksheet in a spreadsheet
|
Command + G
|
Navigate
Go to cell command
|
Command + End
|
Navigate
Go to last cell in data region
|
Command + Home
|
Navigate
Go to first cell in data region
|
PgDn
|
Navigate
Down one screen
|
PgUp
|
Navigate
Up one screen
|
Tab
|
Navigate
Move to next cell in row
|
Shift + Tab
|
Navigate
Move to previous cell in row
|
Command + Left Arrow / Command + Right Arrow
|
Navigate
Select Data Region to the Left / to the Right
|
Tab
|
Shortcuts for Objects (Images,charts,buttons etc)
Navigate to the next object
|
Shift + Tab
|
Shortcuts for Objects (Images,charts,buttons etc)
Navigate to the previous object
|
F2
|
Shortcuts for Objects (Images,charts,buttons etc)
Edit mode
|
Esc
|
Shortcuts for Objects (Images,charts,buttons etc)
Return the focus to the active cell
|
Esc
|
Shortcuts for Objects (Images,charts,buttons etc)
Cancel dragging the object
|
Command + Click
|
Shortcuts for Objects (Images,charts,buttons etc)
Select/Focus the object
|
Arrow Keys
|
Shortcuts for Objects (Images,charts,buttons etc)
Move the selected object in the desired direction
|
Command + Arrow Keys
|
Shortcuts for Objects (Images,charts,buttons etc)
Snap the the object's left/top with the adjacent cell
|
Command + Shift + Arrow Keys
|
Shortcuts for Objects (Images,charts,buttons etc)
Snap the the object's right/bottom with the adjacent cell
|
Command + Shift + Arrow Left / Command + Shift + Arrow Right
|
Selection
Select Data Region to the Left/ to the Right
|
Command + Shift + Arrow Up / Command + Shift + Arrow Down
|
Selection
Select Data Region Up/down
|
Command + Shift + Home
|
Selection
Select from current cell to the first cell A1
|
Command + Shift + End
|
Selection
Select from current cell to the last cell in the data region
|
Shift + Home
|
Selection
Select from current cell to the first cell in the same row
|
Shift + End
|
Selection
Select from current cell to the last cell in the same row
|
Command + A
|
Selection
Select whole spreadsheet
|
Command + Spacebar
|
Selection
Select column
|
Shift + Spacebar
|
Selection
Select row
|
Command + Shift + U
|
Formula related shortcuts
Toggle Expand and Collapse of Formula Bar
|
Command + Shift + Return
|
Formula related shortcuts
Insert Array Formula on a range of cells
|
Command + /
|
Formula related shortcuts
Select the range of array formula cells surrounding a cell
|
=
|
Formula related shortcuts
Start a formula
|
F9
|
Formula related shortcuts
Recalculate Formulas
|
F4
|
Formula related shortcuts
Toggle absolute and relative references
|
Option + =
|
Formula related shortcuts
Auto Sum
|
Shift + F3
|
Formula related shortcuts
Show Function Dialog Box
|