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