77 Shortcuts for Zoho Sheet

Jump to: File Operations, Actions, Editing Shortcuts, Formatting Shortcuts, Navigate, Shortcuts for Objects (Images,charts,buttons etc), Selection, Formula related shortcuts

1. File Operations

Ctrl+N

New File

Command+O

Open file

Command+Shift+S

Save As File

Command+P

Print File

2. Actions

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

3. Editing Shortcuts

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

4. Formatting Shortcuts

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

5. Navigate

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

6. Shortcuts for Objects (Images,charts,buttons etc)

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

7. Selection

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

8. Formula related shortcuts

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

Created by rank17 on 3/4/2017. Last updated by guest on 3/4/2017

 

0 Comments for 'Zoho Sheet '   

 
Email me replies   
icon

Zoho Sheet Shortcuts

Advertising for Consideration:

Ads for Consideration:

Related:

Please kindly review and accept Terms of Use and Cookie & Policy Policy