Shortcuts Zoho Sheet for Windows

We present to your attention the shortcuts for the Zoho Sheet for Windows which is used on the operating system Windows, 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

Windows Description Edit Cancel Save & submit
Ctrl+N( not supported in chrome and safari ) New File
Ctrl+O Open file
Ctrl+Shift+S Save As File
Ctrl+P Print File

Actions

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

Editing

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

Formatting

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

Shortcuts for Objects (Images,charts,buttons etc)

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

Selection

Windows Description Edit Cancel Save & submit
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 Description Edit Cancel Save & submit
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
~~~ The end. Thank you for watching. Add page to bookmarks CTRL + D ~~~
Date of change: 25.01.2019
Page views: 61
*Some of the keys listed may not work in older versions of the program