Keyboard shortcuts

Ctrl+X

Shift+Delete

 Cmd+X

Cut

Ctrl+C

Ctrl+Insert

 Cmd+C

Copy

Ctrl+V

Shift+Insert

 Cmd+V

Paste

Ctrl+Alt+V

 Option+ Cmd+V

Paste values and format

Ctrl+S

 Cmd+S

Save

F12 (Windows)

Ctrl+Shift+S (Linux)

 Shift+ Cmd+S

Save as

Ctrl+Z

Alt+Backspace

 Cmd+Z

Undo the last action

Ctrl+Y

Ctrl+Shift+Z

Shift+Alt+Backspace

 Cmd+Y

Redo the result of the undone action

Ctrl+Alt+Shift+V (Windows)

Win+V (Linux)

 Option+ Shift+ 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

 Cmd+Delete

 Option+Delete

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

Ctrl+Delete

 Cmd+Fn+Delete

 Option+Fn+Delete

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

Alt+Enter

 Option+ Enter

Begin a new paragraph

Ctrl+Shift+Space

 Option+ Shift+Space

Insert a non‑breaking space

Ctrl+Shift+–

 Cmd+ Shift+–

Insert a non‑breaking hyphen

Ctrl+Num–

 Option+–

Insert an en dash

Ctrl+Alt+Num–

 Option+ Shift+–

Insert an em dash

Ctrl+B

 Cmd+B

Bold

Ctrl+I

 Cmd+I

Italic

Ctrl+U

 Cmd+U

Underline

Ctrl+Shift+=

 Shift+ Cmd+=

Superscript

Ctrl+=

 Cmd+=

Subscript

Ctrl+Shift+A

 Shift+ Cmd+A

All caps

Ctrl+Shift+C

 Shift+ Cmd+C

Copy formatting

Ctrl+Shift+V

 Shift+ Cmd+V

Apply formatting

Ctrl+L

 Cmd+L

Align the cell content to the left

Ctrl+E

 Cmd+E

Center the cell content

Ctrl+R

 Cmd+R

Align the cell content to the right

Ctrl+J

 Cmd+J

Justify the cell content

Page Up

Fn+↑

Move one screen up

Page Down

Fn+↓

Move one screen down

Ctrl+Home

Fn+ Cmd+←

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

Ctrl+End

Fn+ Cmd+→

Go to the last cell in the workspace

Ctrl+↑

 Cmd+↑

Go to the first cell of the column

Ctrl+↓

 Cmd+↓

Go to the last cell of the column in the workspace

Ctrl+←

 Cmd+←

Go to the first cell of the row

Ctrl+→

 Cmd+→

Go to the last cell of the row in the workspace

F2

Fn+F2

Switch to cell editing mode

Alt+A

 Option+A

Insert a row above

Alt+B

 Option+B

Insert a row below

Alt+L

 Option+L

Insert a column to the left

Alt+R

 Option+R

Insert a column to the right

Ctrl+Alt+M

 Option+ Cmd+M

Merge cells

Alt+Shift+M

 Option+ Shift+M

Unmerge cells

Ctrl+ —

 Cmd+ —

Delete a row or column

↑

↑

Select a cell above

↓

↓

Select a cell below

Tab or →

 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+Space

Select a row

Ctrl+Space

 Shift+ Cmd+Space

Select a column

Ctrl+Shift+Home

 Shift+Fn+ Cmd+←

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

Ctrl+Shift+End

 Shift+Fn+ Cmd+→

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

Ctrl+Shift+↑

 Shift+ Cmd+↑

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

Ctrl+Shift+↓

 Shift+ Cmd+↓

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

Ctrl+Shift+←

 Shift+ Cmd+←

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

Ctrl+Shift+→

 Shift+ Cmd+→

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

Ctrl+A

 Cmd+A

Select all cells of workspace on the sheet

Ctrl+Left mouse button

 Cmd+Left mouse button

Multiple row or column selection

Shift+↑

 Shift+↑

Expand the selection by one cell upwards

Shift+↓

 Shift+↓

Expand the selection by one cell downwards

Shift+←

 Shift+←

Select one character to the left of the cursor

Shift+→

 Shift+→

Select one character to the right of the cursor

Ctrl+Shift+←

 Shift+ Cmd+←

Select one word to the left of the cursor

Ctrl+Shift+→

 Shift+ Cmd+→

Select one word to the right of the cursor

Shift+Home

Fn+ Shift+←

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

Shift+End

Fn+ Shift+→

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

Ctrl+Shift+↑

 Shift+ Ctrl+ Cmd+↑

Expand the selection till the beginning of the paragraph

Ctrl+Shift+↓

 Shift+ Ctrl+ Cmd+↓

Extend the selection to the end of the paragraph

Shift+↑

 Shift+↑

Expand the selection by one line upwards

Shift+↓

 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 one character to the left

→

→

Move one character to the right

Ctrl+←

 Cmd+←

Move one word to the left

Ctrl+→

 Cmd+→

Move one word to the right

↑

↑

Move one line up

↓

↓

Move one line down

Ctrl+↑

 Cmd+↑

Move to the beginning of the previous paragraph

Ctrl+↓

 Cmd+↓

Move to the beginning of the next paragraph

Alt+F9

 Option+F9

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

Alt+=

 Option+=

Quick insertion of the SUM function with automatic determination of arguments

F9

F9

Recalculate formulas in the entire document

Shift+F9

 Shift+F9

Recalculate formulas on the sheet

Ctrl+Shift+F9

 Shift+ Cmd+F9

Force calculate formulas

Ctrl+Shift+F5

 Shift+ Cmd+F5

Update references to data in external documents

Ctrl+N

 Cmd+N

Create a file

Ctrl+O

 Cmd+O

Open a file

Ctrl+P

 Cmd+P

Open the preview, print settings and print window

Ctrl+0 (zero)

 Cmd+0 (zero)

Set the actual page size (100%)

Ctrl+K

 Cmd+K

Insert a link

Ctrl+Shift+V

 Shift+ Cmd+V

Insert a link from the clipboard

Ctrl+Shift+1

 Shift+ Cmd+1

Split the number into digit groups

Ctrl+F

Ctrl+H

 Cmd+F

Open the find and replace pane

Ctrl+T

 Cmd+T

Open the window to create a table

Shift+F3

 Shift+F3

Open the function pane

Ctrl+/

 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

 Cmd+Q

Close the active window of the application