77 Shortcuts for Zoho Sheet (Windows)  [edit]

minimize Hide all  maximize Show all

minusplus1. File Operations
Ctrl+N( not supported in chrome and safari ) New File
Ctrl+O Open file
Ctrl+Shift+S Save As File
Ctrl+P Print File

▲ up

minusplus2. Actions
Ctrl+Z Undo last action
Ctrl+Y Redo last action
F4 (or) Ctrl+Y (or) Alt+Enter Repeat last action
Ctrl+Shift+ L Filter
Ctrl+R Fill to The Right
Ctrl+D Fill Down
Shift+F2 Add / Edit cell note
Ctrl+K Add / Edit Hyperlink
Alt +F11 Open VBA Editor
Alt+F8 Run Macros / View Macros List
Shift+F11 Insert a new worksheet
Ctrl+Shift+Plus Insert Columns
Ctrl+Alt+Plus Insert Rows
Ctrl+X Cut
Ctrl+C Copy
Ctrl+V Paste
Ctrl+Shift+ 1 Format Cells
Ctrl+F or F3 Find within spreadsheet
Ctrl+H Replace
Ctrl+F3 Names Ranges
Ctrl+Shift+Q Toggle Auto Completion On / Off
Alt+Arrow Down Display the auto suggest list (Pick from List)
Ctrl+Shift+ ; Insert the current time in cell
Ctrl+; Insert the current date in cell

▲ up

minusplus3. Editing
Ctrl+Enter Insert Line Break in Cell
Backspace Delete one character to left while typing in a cell
Delete Delete one character to right/left while typing in a cell
Ctrl+Shift+F Focus Formula Field
Esc key Cancel cell entry
F2 Edit active cell

▲ up

minusplus4. Formatting
Ctrl+B (or) Ctrl+Shift+2 Bold toggle for selection
Ctrl+I (or) Ctrl+Shift+ 3 Italic toggle for selection
Ctrl+Shift+5 Strikethrough toggle for selection
Ctrl+U (or) Ctrl+Shift+4 Underline toggle for selection

▲ up

minusplus5. Navigate
Ctrl+Arrow Down Data Region Down
Ctrl+Arrow Up Data Region Up
Ctrl+Shift+N Focus Name Box
Alt+Arrow Right Move to next worksheet in a spreadsheet
Alt +Arrow Left Move to previous worksheet in a spreadsheet
Ctrl+ G Go to cell command
Ctrl+End Go to last cell in data region
Ctrl+Home Go to first cell in data region
Page Down Down one screen
Page Up Up one screen
Tab Move to next cell in row
Shift+Tab Move to previous cell in row
Ctrl+Arrow Left/ Ctrl+Arrow Right Select Data Region to the Left / to the Right

▲ up

minusplus6. Shortcuts for Objects (Images,charts,buttons etc)
Tab Navigate to the next object
Shift+Tab Navigate to the previous object
F2 Edit mode
Esc Return the focus to the active cell
Esc Cancel dragging the object
Ctrl +Click Select/Focus the object
Arrow Keys Move the selected object in the desired direction
Ctrl+Arrow Keys Snap the the object's left/top with the adjacent cell
Ctrl+Shift+Arrow Keys Snap the the object's right/bottom with the adjacent cell

▲ up

minusplus7. Selection
Ctrl+Shift+Arrow Left/Ctrl+Shift+ Arrow Right Select Data Region to the Left/ to the Right
Ctrl+Shift+Arrow Up/Ctrl+Shift+Arrow Down Select Data Region Up/down
Ctrl+Shift+Home Select from current cell to the first cell A1
Ctrl+Shift+End Select from current cell to the last cell in the data region
Shift+Home Select from current cell to the first cell in the same row
Shift+End Select from current cell to the last cell in the same row
Ctrl +A Select whole spreadsheet
Ctrl+Space Select column
Shift+Space Select row

▲ up

minusplus8. Formula related shortcuts
Ctrl+Shift+U Toggle Expand and Collapse of Formula Bar
Ctrl+Shift+Enter Insert Array Formula on a range of cells
Ctrl+/ Select the range of array formula cells surrounding a cell
= Start a formula
F9 Recalculate Formulas
F4 Toggle absolute and relative references
Alt+ = Auto Sum
Shift+F3 Show Function Dialog Box

▲ up


Uploaded by SarthakMenpara, updated on 3/3/2017