Keyboard shortcuts

Edit content

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

Alt+Shift+V

⌥Option+⇧Shift+V

Paste values only

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

Format content

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

Ctrl+1

⌘Cmd+1

Open number format settings window

Move within the workspace

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

Ctrl+↓

Ctrl+←

Ctrl+→

⌘Cmd+↑

⌘Cmd+↓

⌘Cmd+←

⌘Cmd+→

Move to the edge cell of the current data area, or to the edge cell of the nearest data area if the edge cell of the region or an empty cell is selected

Navigate between sheets

Ctrl+Page Up

⌃Ctrl+Fn+↑

⌘Cmd+Fn+↑

Go to the next sheet (to the right of the current one in the sheet tab pane)

Ctrl+Page Down

⌃Ctrl+Fn+↓

⌘Cmd+Fn+↓

Go to the previous sheet (to the left of the current sheet in the sheet tab pane)

Ctrl+Shift+Page Up

⌃Ctrl+Fn+Shift+↑

⌘Cmd+Fn+Shift+↑

Go to the last sheet (rightmost on the sheet tab pane)

Ctrl+Shift+Page Down

⌃Ctrl+Fn+Shift+↓

⌘Cmd+Fn+Shift+↓

Go to the first sheet (leftmost on the sheet tab pane)

Cells, columns, and rows

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

Split cells

Ctrl+—

⌘Cmd+—

Delete a row or column

Ctrl+9

⌘Cmd+(

Hide selected rows

Ctrl+Shift+9

⌘Cmd+⇧Shift+(

Show hidden rows

Ctrl+0

⌘Cmd+)

Hide selected columns

Ctrl+Shift+0

⌘Cmd+⇧Shift+)

Show hidden columns

Alt+Shift+→

⌥Option+⇧Shift+→

Group rows or columns

Alt+Shift+←

⌥Option+⇧Shift+←

Ungroup rows or columns

Ctrl+Shift+L

⌘Cmd+⇧Shift+L

Enable or disable sorting and filtering for the selected range

Select cells, columns, and rows

↑

↑

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 selection

Shift+↑

⇧Shift+↑

Expand the selection by one cell upwards

Shift+↓

⇧Shift+↓

Expand the selection by one cell downwards

Shift+←

⇧Shift+←

Extend selection one cell to the left in the table

Shift+→

⇧Shift+→

Extend selection one cell to the right in the table

Tab

⇥Tab

Move the active cell cursor to the right

Shift+Tab

⇧Shift+⇥Tab

Move the active cell cursor to the left

Enter

⌤Enter

Move the active cell cursor down

Shift+Enter

⇧Shift+⌤Enter

Move the active cell cursor up

Actions with cell content*

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

Start a new paragraph
(used only for text values, ignored when working with formulas)

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

F4

F4

Change the type of reference in a formula / function

* 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:

–Double-click the cell.

–Select the cell and start typing.

–Go to the Formula bar.

–Press F2 (Windows, Linux) or Fn+F2 (macOS).

Select text in the active cell*

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

Select or deselect before the beginning of the paragraph

Ctrl+Shift+↓

⇧Shift+⌃Ctrl+⌘Cmd+↓

Add selection to end of paragraph

Shift+↑

⇧Shift+↑

Select or deselect one row of text above

Shift+↓

⇧Shift+↓

Select or deselect one row of text below

Shift+←

⇧Shift+←

Select or deselect one position to the left of the cursor

Shift+→

⇧Shift+→

Select or deselect one position to the right of the cursor

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

* 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:

–Double-click the cell.

–Select the cell and start typing.

–Go to the Formula bar.

–Press F2 (Windows, Linux) or Fn+F2 (macOS).

Move within text in the active cell*

←

←

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

* 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:

–Double-click the cell.

–Select the cell and start typing.

–Go to the Formula bar.

–Press F2 (Windows, Linux) or Fn+F2 (macOS).

Work with formulas and functions

Alt+F9

⌥Option+F9

Replace part of the formula or the entire formula 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+Shift+Enter

⇧Shift+⌘Cmd+⌤Enter

Use formula as array formula

Other keyboard shortcuts

Ctrl+N

⌘Cmd+N

New file

Ctrl+O

⌘Cmd+O

Open a file

Ctrl+P

⌘Cmd+P

Open the preview and print settings window

Ctrl+K

⌘Cmd+K

Insert a link (to a web page or email address, to a place in a document, or to a file)

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

⌘Cmd+⇧Shift+U

Collapse or expand the Formula bar

Ctrl+/

⌘Cmd+/

Open the Quick actions pane

F1

Fn+F1

Open the Help section

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