Zoho Sheet (MacOS)

Actions

Open VBA Editor

`Option` + `F11`

All hotkeys for Zoho Sheet (MacOS)

File Operations New File	`Ctrl` + `N`
File Operations Open file	`Command` + `O`
File Operations Save As File	`Command` + `Shift` + `S`
File Operations Print File	`Command` + `P`
Actions Undo last action	`Command` + `Z`
Actions Redo last action	`Command` + `Y`
Actions Repeat last action	`F4` / `Command` + `Y` / `Option` + `Return`
Actions Filter	`Command` + `Shift` + `L`
Actions Fill to The Right	`Command` + `R`
Actions Fill Down	`Command` + `D`
Actions Add / Edit cell note	`Shift` + `F2`
Actions Add / Edit Hyperlink	`Command` + `K`
Actions Open VBA Editor	`Option` + `F11`
Actions Run Macros / View Macros List	`Option` + `F8`
Actions Insert a new worksheet	`Shift` + `F11`
Actions Insert Columns	`Command` + `Shift` + `+`
Actions Insert Rows	`Command` + `Option` + `+`
Actions Cut	`Command` + `X`
Actions Copy	`Command` + `C`
Actions Paste	`Command` + `V`
Actions Format Cells	`Command` + `Shift` + `1`
Actions Find within spreadsheet	`Command` + `F` / `F3`
Actions Replace	`Command` + `H`
Actions Names Ranges	`Command` + `F3`
Actions Toggle Auto Completion On / Off	`Command` + `Shift` + `Q`
Actions Display the auto suggest list (Pick from List)	`Option` + `Arrow Down`
Actions Insert the current time in cell	`Command` + `Shift` + `;;`
Actions Insert the current date in cell	`Command` + `;`
Editing Shortcuts Insert Line Break in Cell	`Command` + `Return`
Editing Shortcuts Delete one character to left while typing in a cell	`Del`
Editing Shortcuts Delete one character to right/left while typing in a cell	`Delete`
Editing Shortcuts Focus Formula Field	`Command` + `Shift` + `F`
Editing Shortcuts Cancel cell entry	`Esc`
Editing Shortcuts Edit active cell	`F2`
Formatting Shortcuts Bold toggle for selection	`Command` + `B` / `Command` + `Shift` + `2`
Formatting Shortcuts Italic toggle for selection	`Command` + `I` / `Command` + `Shift` + `3`
Formatting Shortcuts Strikethrough toggle for selection	`Command` + `Shift` + `5`
Formatting Shortcuts Underline toggle for selection	`Command` + `U` / `Command` + `Shift` + `4`
Navigate Data Region Down	`Command` + `Arrow Down`
Navigate Data Region Up	`Command` + `Arrow Up`
Navigate Focus Name Box	`Command` + `Shift` + `N`
Navigate Move to next worksheet in a spreadsheet	`Option` + `Right Arrow`
Navigate Move to previous worksheet in a spreadsheet	`Option` + `Left Arrow`
Navigate Go to cell command	`Command` + `G`
Navigate Go to last cell in data region	`Command` + `End`
Navigate Go to first cell in data region	`Command` + `Home`
Navigate Down one screen	`PgDn`
Navigate Up one screen	`PgUp`
Navigate Move to next cell in row	`Tab`
Navigate Move to previous cell in row	`Shift` + `Tab`
Navigate Select Data Region to the Left / to the Right	`Command` + `Left Arrow` / `Command` + `Right Arrow`
Shortcuts for Objects (Images,charts,buttons etc) Navigate to the next object	`Tab`
Shortcuts for Objects (Images,charts,buttons etc) Navigate to the previous object	`Shift` + `Tab`
Shortcuts for Objects (Images,charts,buttons etc) Edit mode	`F2`
Shortcuts for Objects (Images,charts,buttons etc) Return the focus to the active cell	`Esc`
Shortcuts for Objects (Images,charts,buttons etc) Cancel dragging the object	`Esc`
Shortcuts for Objects (Images,charts,buttons etc) Select/Focus the object	`Command` + `Click`
Shortcuts for Objects (Images,charts,buttons etc) Move the selected object in the desired direction	`Arrow Keys`
Shortcuts for Objects (Images,charts,buttons etc) Snap the the object's left/top with the adjacent cell	`Command` + `Arrow Keys`
Shortcuts for Objects (Images,charts,buttons etc) Snap the the object's right/bottom with the adjacent cell	`Command` + `Shift` + `Arrow Keys`
Selection Select Data Region to the Left/ to the Right	`Command` + `Shift` + `Arrow Left` / `Command` + `Shift` + `Arrow Right`
Selection Select Data Region Up/down	`Command` + `Shift` + `Arrow Up` / `Command` + `Shift` + `Arrow Down`
Selection Select from current cell to the first cell A1	`Command` + `Shift` + `Home`
Selection Select from current cell to the last cell in the data region	`Command` + `Shift` + `End`
Selection Select from current cell to the first cell in the same row	`Shift` + `Home`
Selection Select from current cell to the last cell in the same row	`Shift` + `End`
Selection Select whole spreadsheet	`Command` + `A`
Selection Select column	`Command` + `Spacebar`
Selection Select row	`Shift` + `Spacebar`
Formula related shortcuts Toggle Expand and Collapse of Formula Bar	`Command` + `Shift` + `U`
Formula related shortcuts Insert Array Formula on a range of cells	`Command` + `Shift` + `Return`
Formula related shortcuts Select the range of array formula cells surrounding a cell	`Command` + `/`
Formula related shortcuts Start a formula	`=`
Formula related shortcuts Recalculate Formulas	`F9`
Formula related shortcuts Toggle absolute and relative references	`F4`
Formula related shortcuts Auto Sum	`Option` + `=`
Formula related shortcuts Show Function Dialog Box	`Shift` + `F3`

Similar combinations for other applications

Microsoft Excel 2016 (MacOS)

Open Visual Basic

Frequently used shortcuts

`Option` + `F11`

Microsoft Excel 2016 (MacOS)

Open Visual Basic

The following table provides the function key shortcuts for Excel 2016 for Mac*

`Option` + `F11`

Zoho Sheet (MacOS)

Actions

Open VBA Editor

Option + F11

All hotkeys for Zoho Sheet (MacOS)

File Operations

New File

Ctrl + N

File Operations

Open file

Command + O

File Operations

Save As File

Command + Shift + S

File Operations

Print File

Command + P

Actions

Undo last action

Command + Z

Actions

Redo last action

Command + Y

Actions

Repeat last action

F4 / Command + Y / Option + Return

Actions

Filter

Command + Shift + L

Actions

Fill to The Right

Command + R

Actions

Fill Down

Command + D

Actions

Add / Edit cell note

Shift + F2

Actions

Add / Edit Hyperlink

Command + K

Actions

Open VBA Editor

Option + F11

Actions

Run Macros / View Macros List

Option + F8

Actions

Insert a new worksheet

Shift + F11

Actions

Insert Columns

Command + Shift + +

Actions

Insert Rows

Command + Option + +

Actions

Cut

Command + X

Actions

Copy

Command + C

Actions

Paste

Command + V

Actions

Format Cells

Command + Shift + 1

Actions

Find within spreadsheet

Command + F / F3

Actions

Replace

Command + H

Actions

Names Ranges

Command + F3

Actions

Toggle Auto Completion On / Off

Command + Shift + Q

`Option` + `F11`

`Ctrl` + `N`

`Command` + `O`

`Command` + `Shift` + `S`

`Command` + `P`

`Command` + `Z`

`Command` + `Y`

`F4` / `Command` + `Y` / `Option` + `Return`

`Command` + `Shift` + `L`

`Command` + `R`

`Command` + `D`

`Shift` + `F2`

`Command` + `K`

`Option` + `F11`

`Option` + `F8`

`Shift` + `F11`

`Command` + `Shift` + `+`

`Command` + `Option` + `+`

`Command` + `X`

`Command` + `C`

`Command` + `V`

`Command` + `Shift` + `1`

`Command` + `F` / `F3`

`Command` + `H`

`Command` + `F3`

`Command` + `Shift` + `Q`

`Option` + `Arrow Down`

`Command` + `Shift` + `;;`

`Command` + `;`

`Command` + `Return`

`Del`

`Delete`

`Command` + `Shift` + `F`

`Esc`

`F2`

`Command` + `B` / `Command` + `Shift` + `2`

`Command` + `I` / `Command` + `Shift` + `3`

`Command` + `Shift` + `5`

`Command` + `U` / `Command` + `Shift` + `4`

`Command` + `Arrow Down`

`Command` + `Arrow Up`

`Command` + `Shift` + `N`

`Option` + `Right Arrow`

`Option` + `Left Arrow`

`Command` + `G`

`Command` + `End`

`Command` + `Home`

`PgDn`

`PgUp`