macOS – Zoho Sheet Shortcut Keys
macOS – Zoho Sheet Shortcut Keys
Zoho Sheet Shortcut Keys for macOS
Ctrl+N – New File
Command+O – Open file
Command+Shift+S – Save As File
Command+P – Print File
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
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
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
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
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
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
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