tableDesktop version

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, PgUp, PgDn. When pressing these keys in MyOffice Spreadsheet application, hold down the Fn key simultaneously.

Actions with contents

Keyboard shortcut

Command or action

Ctrl+X

Shift+Delete

Cut

Ctrl+C

Ctrl+Insert

Copy

Ctrl+V

Shift+Insert

Paste

Ctrl+Alt+V

Paste values and format

Ctrl+S

Save

F12 (Microsoft Windows)

Ctrl+Shift+S (Linux)

Save as

Ctrl+Z

Cancel the last action

Ctrl+Y

Repeat the result of the last action

Ctrl+Alt+Shift+V

Open the clipboard history

Backspace

Delete one character to the left of the cursor

Delete

Delete one character to the right of the cursor

Ctrl+Backspace

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

Ctrl+Delete

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

Alt+Enter

Begin a new paragraph

Ctrl+Shift+Space

Insert a non-breaking space

Ctrl+Shift+

Insert a non-breaking hyphen

Ctrl+Num –

Insert an en dash

Ctrl+Alt+Num –

Insert an em dash

F9

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

Alt+F7

Find a word with a spelling mistake

Contents formatting

Keyboard shortcut

Command or action

Ctrl+B

Bold

Ctrl+I

Italic

Ctrl+U

Underline

Ctrl+Shift+=

Superscript

Ctrl+=

Subscript

Ctrl+Shift+A

All caps

Ctrl+Shift+C

Copy formatting

Ctrl+Shift+V

Apply formatting

Ctrl+L

Align text to the left

Ctrl+E

Center the text

Ctrl+R

Align text to the right

Ctrl+J

Justify the text

Move within the workspace

Keyboard shortcut

Command or action

Page Up

Move one screen up

Page Down

Move one screen down

Ctrl+Home

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

Ctrl+End

Go to the last cell in the workspace

Actions with cells, columns, and rows

Keyboard shortcut

Command or action

F2

Go to the cell editing mode

Alt+A

Insert a row up

Alt+B

Insert a row down

Alt+L

Insert a column to the left

Alt+R

Insert a column to the right

Ctrl+Alt+M

Combine cells

Alt+Shift+M

Divide cells

Ctrl+

Delete a row or column

Select cells, columns, and rows

Keyboard shortcut

Command or action

Up Arrow

Select a cell above

Down Arrow

Select a cell below

Tab or Right Arrow

Select the next cell

Left Arrow

Select the previous cell

Home

Select the cell in the beginning of the row

End

Select the cell at the end of the row

Shift+Space

Select a row

Ctrl+Space

Select a column

Сtrl+Shift+Home

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

Ctrl+Shift+End

Create a selection area from the selected cell to the last cell in the workspace

Ctrl+A

Select all cells of workspace on the sheet

Shift+Up Arrow

Expand the selection by one cell upwards

Shift+Down Arrow

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 edit mode, select the cell by double-clicking or pressing F2.

Keyboard shortcut

Command or action

Shift+Left Arrow

Select one character to the left of the cursor

Shift+Right Arrow

Select one character to the right of the cursor

Ctrl+Shift+Left Arrow

Select one word to the left of the cursor

Ctrl+Shift+Right Arrow

Select one word to the right of the cursor

Shift+Home

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

Shift+End

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

Ctrl+Shift+Up Arrow

Expand the selection till the beginning of the paragraph

Ctrl+Shift+Down Arrow

Expand the selection till the end of the paragraph

Shift+Up Arrow

Expand the selection by one line upwards

Shift+Down Arrow

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 edit mode, select the cell by double-clicking or pressing F2.

Keyboard shortcut

Command or action

Left Arrow

Move one character to the left

Right Arrow

Move one character to the right

Ctrl+Left Arrow

Move one word to the left

Ctrl+Right Arrow

Move one word to the right

Up Arrow

Move one row up

Down Arrow

Move one row down

Ctrl+Up Arrow

Move to the beginning of the previous paragraph

Ctrl+Down Arrow

Move to the beginning of the next paragraph

Other keyboard shortcuts

Keyboard shortcut

Command or action

Ctrl+N

Create a file

Ctrl+O

Open a file

Ctrl+Shift+O

Open a file in the Cloud

Ctrl+P

Open the preview, print settings and print window

Ctrl+0 (zero)

Set the actual page size (100%)

Ctrl+K

Insert a link

Ctrl+F

Open the Find and Replace pane

Shift+F3

Open the function pane

Ctrl+/

Open the Quick actions box

F1

Open the Help

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

Close the active window of the application

Was this helpful?
Yes
No
Previous
Demonstrate new features
Next
Language