Shortcuts Zoho Sheet for MacOS

MacOS

We present to your attention the shortcuts for the Zoho Sheet for MacOS which is used on the operating system MacOS, in this hotkeys description 77 of the most popular and important shortcuts are offered. You can also add your changes on our portal if you consider the data insufficiently complete or add a new program from the very beginning.

File Operations

MacOS	Description Edit Cancel Save & submit
Ctrl+N	New File
Command+O	Open file
Command+Shift+S	Save As File
Command+P	Print File

Actions

MacOS	Description Edit Cancel Save & submit
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

Editing Shortcuts

MacOS	Description Edit Cancel Save & submit
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

Formatting Shortcuts

MacOS	Description Edit Cancel Save & submit
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

Navigate

MacOS	Description Edit Cancel Save & submit
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

Shortcuts for Objects (Images,charts,buttons etc)

MacOS	Description Edit Cancel Save & submit
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

Selection

MacOS	Description Edit Cancel Save & submit
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

MacOS	Description Edit Cancel Save & submit
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