77 Shortcuts for Zoho Sheet (MacOS)  [edit]

minusplus1. File Operations
Ctrl+N New File
Command+O Open file
Command+Shift+S Save As File
Command+P Print File

▲ up

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

▲ up

minusplus3. Editing Shortcuts
Command+Return Insert Line Break in Cell
Del Delete one character to left while typing in a cell
Delete Delete one character to right/left while typing in a cell
Command+Shift+F Focus Formula Field
Esc Cancel cell entry
F2 Edit active cell

▲ up

minusplus4. Formatting Shortcuts
Command+B/Command+Shift+2 Bold toggle for selection
Command+I/Command+Shift+3 Italic toggle for selection
Command+Shift+5 Strikethrough toggle for selection
Command+U/Command+Shift+4 Underline toggle for selection

▲ up

minusplus5. Navigate
Command+Arrow Down Data Region Down
Command+Arrow Up Data Region Up
Command+Shift+N Focus Name Box
Option+Right Arrow Move to next worksheet in a spreadsheet
Option +Left Arrow Move to previous worksheet in a spreadsheet
Command+G Go to cell command
Command+End Go to last cell in data region
Command+Home Go to first cell in data region
PgDn Down one screen
PgUp Up one screen
Tab Move to next cell in row
Shift+Tab Move to previous cell in row
Command+Left Arrow/ Command+Right Arrow 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
Command+Click Select/Focus the object
Arrow Keys Move the selected object in the desired direction
Command+Arrow Keys Snap the the object's left/top with the adjacent cell
Command+Shift+Arrow Keys Snap the the object's right/bottom with the adjacent cell

▲ up

minusplus7. Selection
Command+Shift+Arrow Left/Command+Shift+Arrow Right Select Data Region to the Left/ to the Right
Command+Shift+Arrow Up/Command+Shift+Arrow Down Select Data Region Up/down
Command+Shift+Home Select from current cell to the first cell A1
Command+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
Command +A Select whole spreadsheet
Command+Spacebar Select column
Shift+Spacebar Select row

▲ up

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

▲ up


Uploaded by rank17, updated on 3/4/2017