Purchase
How can we help you?

Keyboard shortcuts

Application: Spreadsheet Desktop version macOS

If there are keyboard shortcuts assigned to any command in the application, they are indicated in the Command menu next to the command names.

On laptops, some keys are multifunctional. For example, F1-F12, Home, End, Page Up, Page Down. When you press these keys in the MyOffice Spreadsheet application, it is necessary to hold Fn key down simultaneously.

Edit the content

Keyboard shortcut

Description

Windows, Linux

macOS

Ctrl+X

Shift+Delete

command Cmd+X

Cut

Ctrl+C

Ctrl+Insert

command_grey Cmd+C

Copy

Ctrl+V

Shift+Insert

command Cmd+V

Paste

Ctrl+Alt+V

alt_grey Option+command_grey Cmd+V

Paste values and format

Ctrl+S

command Cmd+S

Save

F12 (Windows)

Ctrl+Shift+S (Linux)

shift_grey Shift+command_grey Cmd+S

Save as

Ctrl+Z

Alt+Backspace

command Cmd+Z

Undo the last action

Ctrl+Y

Ctrl+Shift+Z

Shift+Alt+Backspace

command_grey Cmd+Y

Redo the result of the undone action

Ctrl+Alt+Shift+V (Windows)

Win+V (Linux)

alt Option+shift Shift+command Cmd+V

Open the clipboard history

Backspace

Delete

Delete one character to the left of the cursor

Delete

Fn+Delete

Delete one character to the right of the cursor

Ctrl+Backspace

command_grey Cmd+Delete

alt_grey Option+Delete

Delete part of a word or the entire word to the left of the cursor

Ctrl+Delete

command Cmd+Fn+Delete

alt Option+Fn+Delete

Delete part of a word or the entire word to the right of the cursor

Alt+Enter

alt_grey Option+enter_grey Enter

Begin a new paragraph

Ctrl+Shift+Space

alt Option+shift Shift+Space

Insert a non‑breaking space

Ctrl+Shift+–

command_grey Cmd+shift_grey Shift+–

Insert a non‑breaking hyphen

Ctrl+Num–

alt Option+–

Insert an en dash

Ctrl+Alt+Num–

alt_grey Option+shift_grey Shift+–

Insert an em dash

Format content

Keyboard shortcut

Description

Windows, Linux

macOS

Ctrl+B

command Cmd+B

Bold

Ctrl+I

command_grey Cmd+I

Italic

Ctrl+U

command Cmd+U

Underline

Ctrl+Shift+=

shift_grey Shift+command_grey Cmd+=

Superscript

Ctrl+=

command Cmd+=

Subscript

Ctrl+Shift+A

shift_grey Shift+command_grey Cmd+A

All caps

Ctrl+Shift+C

shift Shift+command Cmd+C

Copy formatting

Ctrl+Shift+V

shift_grey Shift+command_grey Cmd+V

Apply formatting

Ctrl+L

command Cmd+L

Align the cell content to the left

Ctrl+E

command_grey Cmd+E

Center the cell content

Ctrl+R

command Cmd+R

Align the cell content to the right

Ctrl+J

command_grey Cmd+J

Justify the cell content

Move within the workspace

Keyboard shortcut

Description

Windows, Linux

macOS

Page Up

Fn+↑

Move one screen up

Page Down

Fn+↓

Move one screen down

Ctrl+Home

Fn+command Cmd+←

Go to the first cell in the workspace (A1 cell)

Ctrl+End

Fn+command_grey Cmd+→

Go to the last cell in the workspace

Ctrl+↑

command_grey Cmd+↑

Go to the first cell of the column

Ctrl+↓

command_grey Cmd+↓

Go to the last cell of the column in the workspace

Ctrl+←

command_grey Cmd+←

Go to the first cell of the row

Ctrl+→

command_grey Cmd+→

Go to the last cell of the row in the workspace

Actions with cells, columns, and rows

Keyboard shortcut

Description

Windows, Linux

macOS

F2

Fn+F2

Switch to cell editing mode

Alt+A

alt_grey Option+A

Insert a row above

Alt+B

alt Option+B

Insert a row below

Alt+L

alt_grey Option+L

Insert a column to the left

Alt+R

alt Option+R

Insert a column to the right

Ctrl+Alt+M

alt_grey Option+command_grey Cmd+M

Merge cells

Alt+Shift+M

alt Option+shift Shift+M

Unmerge cells

Ctrl+ —

command_grey Cmd+ —

Delete a row or column

Select cells, columns, and rows

Keyboard shortcut

Description

Windows, Linux

macOS

↑

↑

Select a cell above

↓

↓

Select a cell below

Tab or →

tab_symbol Tab or →

Select the next cell

←

←

Select the previous cell

Home

Fn+←

Select the cell in the beginning of the row

End

Fn+→

Select the cell at the end of the row

Shift+Space

shift Shift+Space

Select a row

Ctrl+Space

shift_grey Shift+command_grey Cmd+Space

Select a column

Ctrl+Shift+Home

shift Shift+Fn+command Cmd+←

Create a selection area from the selected cell to the first cell in the workspace (A1 cell)

Ctrl+Shift+End

shift_grey Shift+Fn+command_grey Cmd+→

Select an area from the selected cell to the last cell in the workspace

Ctrl+Shift+↑

shift_grey Shift+command_grey Cmd+↑

Select an area from the selected cell to the first cell in the column

Ctrl+Shift+↓

shift_grey Shift+command_grey Cmd+↓

Select an area from the selected cell to the last cell of the column in the workspace

Ctrl+Shift+←

shift_grey Shift+command_grey Cmd+←

Select an area from the selected cell to the first cell in the row

Ctrl+Shift+→

shift_grey Shift+command_grey Cmd+→

Select an area from the selected cell to the last cell of the row in the workspace

Ctrl+A

command Cmd+A

Select all cells of workspace on the sheet

Ctrl+Left mouse button

command Cmd+Left mouse button

Multiple row or column selection

Shift+↑

shift_grey Shift+↑

Expand the selection by one cell upwards

Shift+↓

shift Shift+↓

Expand the selection by one cell downwards

Select text in the active cell

The keyboard shortcuts listed in the table below are used when you edit data in a cell.

To switch to the edit mode, do one of the following:

•Select a cell by double-clicking.

•When working on Windows or Linux, press F2. When working on macOS, press Fn+F2.

Keyboard shortcut

Description

Windows, Linux

macOS

Shift+←

shift Shift+←

Select one character to the left of the cursor

Shift+→

shift_grey Shift+→

Select one character to the right of the cursor

Ctrl+Shift+←

shift Shift+command Cmd+←

Select one word to the left of the cursor

Ctrl+Shift+→

shift_grey Shift+command_grey Cmd+→

Select one word to the right of the cursor

Shift+Home

Fn+shift Shift+←

Select the content from the cursor to the beginning of the line

Shift+End

Fn+shift_grey Shift+→

Select the content from the cursor to the end of the line

Ctrl+Shift+↑

shift Shift+ctrl Ctrl+command Cmd+↑

Expand the selection till the beginning of the paragraph

Ctrl+Shift+↓

shift_grey Shift+ctrl_grey Ctrl+command_grey Cmd+↓

Extend the selection to the end of the paragraph

Shift+↑

shift Shift+↑

Expand the selection by one line upwards

Shift+↓

shift_grey Shift+↓

Expand the selection by one line downwards

Left double-click

Select a word

Left triple-click

Select a paragraph

Left-click and move the cursor up

Select the text located above the cursor

Left-click and move the cursor down

Select the text located below the cursor

Move within text in the active cell

The keyboard shortcuts listed in the table below are used when you edit data in a cell.

To switch to the edit mode, do one of the following:

•Select a cell by double-clicking.

•When working on Windows or Linux, press F2. When working on macOS, press Fn+F2.

Keyboard shortcut

Description

Windows, Linux

macOS

←

←

Move one character to the left

→

→

Move one character to the right

Ctrl+←

command Cmd+←

Move one word to the left

Ctrl+→

command_grey Cmd+→

Move one word to the right

↑

↑

Move one line up

↓

↓

Move one line down

Ctrl+↑

command Cmd+↑

Move to the beginning of the previous paragraph

Ctrl+↓

command_grey Cmd+↓

Move to the beginning of the next paragraph

Work with formulas and functions

Keyboard shortcut

Description

Windows, Linux

macOS

Alt+F9

alt Option+F9

Replace the formula (entirely or partially) with its calculated value

Alt+=

alt_grey Option+=

Quick insertion of the SUM function with automatic determination of arguments

F9

F9

Recalculate formulas in the entire document

Shift+F9

shift Shift+F9

Recalculate formulas on the sheet

Ctrl+Shift+F9

shift_grey Shift+command_grey Cmd+F9

Force calculate formulas

Ctrl+Shift+F5

shift Shift+command Cmd+F5

Update references to data in external documents

Other keyboard shortcuts

Keyboard shortcut

Description

Windows, Linux

macOS

Ctrl+N

command Cmd+N

Create a file

Ctrl+O

command_grey Cmd+O

Open a file

Ctrl+Shift+O

shift Shift+command Cmd+O

Open a file in the Cloud

Ctrl+P

command_grey Cmd+P

Open the preview, print settings and print window

Ctrl+0 (zero)

command Cmd+0 (zero)

Set the actual page size (100%)

Ctrl+K

command_grey Cmd+K

Insert a link

Ctrl+Shift+V

shift Shift+command Cmd+V

Insert a link from the clipboard

Ctrl+Shift+1

shift_grey Shift+command_grey Cmd+1

Split the number into digit groups

Ctrl+F

Ctrl+H

command Cmd+F

Open the find and replace pane

Ctrl+T

command Cmd+T

Open the window to create a table

Shift+F3

shift Shift+F3

Open the function pane

Ctrl+/

command_grey Cmd+/

Open the Quick actions box

F1

Fn+F1

Open the Help

Right-click

Right-click

Open the context menu of the selected element

Alt+Space

–

Open the context menu of the active window of the application

Alt+F4

command Cmd+Q

Close the active window of the application
Was this helpful?
Yes
No
Previous
Supported file formats
Next
Language