Shortcuts Zoho Sheet for Windows

77 shortcuts2,729 views

File Operations

	Windows	Action
	`Ctrl`+`N( not supported in chrome and safari )`	New File
	`Ctrl`+`O`	Open file
	`Ctrl`+`Shift`+`S`	Save As File
	`Ctrl`+`P`	Print File

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

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

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

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

	Windows	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
	`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

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

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