Shortcuts Zoho Sheet for MacOS

77 shortcuts2,544 views

File Operations

	macOS	Action
	`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

	macOS	Action
	`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

	macOS	Action
	`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

	macOS	Action
	`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

	macOS	Action
	`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

	macOS	Action
	`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	Action
	`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