Keyboard shortcuts

Ctrl+Z

Cmd+Z

Undo

Ctrl+Y

Cmd+Y

Redo

Ctrl+X

Cmd+X

Cut

Ctrl+C

Cmd+C

Copy

Ctrl+V

Cmd+V

Paste

Ctrl+Alt+V

Cmd+ Option+V

Insert data without formatting

Alt+Enter

Option+ Return

Insert line break

Backspace

Backspace

Remove one symbol left

Ctrl+Backspace

Cmd+Backspace or

Option+Backspace

Remove one word left

Delete

Fn+Backspace

Remove one symbol right

Ctrl+Delete

Cmd+Fn+Backspace or

 Option+Fn+Backspace

Remove one word right

Backspace or Delete

Backspace or Fn+Backspace

Remove data from selected cell

Ctrl+B

Cmd+B

Bold

Ctrl+I

Cmd+I

Italic

Ctrl+U

Cmd+U

Underline

Ctrl+5

Cmd+5

Strikethrough

Ctrl+Shift+=

Cmd+ Shift+=

Superscript

Ctrl+Shift+−

Cmd+ Shift+−

Subscript

Ctrl+Shift+,

Cmd+ Shift+,

Decrease font size by 1

Ctrl+Shift+.

Cmd+ Shift+.

Increase font size by 1

Ctrl+Shift+C

Cmd+ Shift+C

Copy formatting

Ctrl+Shift+V

Cmd+ Shift+V

Apply formatting

Ctrl+Shift+L

Cmd+ Shift+L

Aligh left

Ctrl+Shift+E

Cmd+ Shift+E

Align center

Ctrl+Shift+R

Cmd+ Shift+R

Align right

Ctrl+Shift+J

Cmd+ Shift+J

Justify

Ctrl+A

Cmd+A

Select content of cell

Shift+Left Arrow

Shift+Left Arrow

Select one symbol left or cancel this selection

Shift+Right Arrow

Shift+Right Arrow

Select one symbol right or cancel this selection

Ctrl+Shift+Left Arrow

Cmd+ Shift+Left Arrow

Select one word left or cancel this selection

Ctrl+Shift+Right Arrow

Cmd+ Shift+Right Arrow

Select one word right or cancel this selection

Shift+Home

Fn+ Shift+Left Arrow

Select content from cursor to start of cell

Shift+End

Fn+ Shift+Right Arrow

Select content from cursor to end of cell

Ctrl+Shift+Home

Cmd+Fn+ Shift+Left Arrow

Extend selection to the start of cell

Ctrl+Shift+End

Cmd+Fn+ Shift+Right Arrow

Extend selection to the end of cell

Shift+Down Arrow

Shift+Down Arrow

Extend selection one line down

Shift+Up Arrow

Shift+Up Arrow

Extend selection one line up

Double click left mouse button

Double click left mouse button

Select word

Triple click left mouse button

Triple click left mouse button

Select paragraph

Click left mouse button and move cursor up

Click left mouse button and move cursor up

Select text up

Click left mouse button and move cursor down

Click left mouse button and move cursor down

Select text down

Alt+L

Option+L

Insert column left

Alt+R

Option+R

Insert column right

Alt+A

Option+A

Insert row above

Alt+B

Option+B

Insert row below

Alt+Ctrl+R

Option+ Cmd+R

Remove row

Alt+Ctrl+U

Option+ Cmd+U

Remove column

Alt+Ctrl+M

Option+ Cmd+M

Merge cells

Alt+Shift+M

Option+ Shift+M

Split cells

Tab or Right Arrow

Tab or Right Arrow

Move to next cell

Shift+Tab or Left Arrow

Shift+Tab or Left Arrow

Move to previous cell

Shift+ Right/Up/Down/Left Arrow

Shift+ Right/Up/Down/Left Arrow

Select range

Down Arrow

Down Arrow

Move to cell below

Up Arrow

Up Arrow

Move to cell above

Right Arrow

Right Arrow

Move to right cell

Left Arrow

Left Arrow

Move to left cell

Ctrl+A

Cmd+A

Select all cells

Home

Cmd+Left Arrow or Fn+Left Arrow

Start of line

End

Cmd+Right Arrow or Fn+Right Arrow

End of line

Ctrl+Left Arrow

Cmd+Left Arrow

One word left

Ctrl+Right Arrow

Cmd+Right Arrow

One word right

Up Arrow

Up Arrow

One line up

Down Arrow

Down Arrow

One line down

Left Arrow

Left Arrow

One symbol left

Right Arrow

Right Arrow

One symbol right

Page Up

Cmd+Fn+Up Arrow

One screen up

Page Down

Cmd+Fn+Down Arrow

One screen down

Ctrl+End

Cmd+Fn+Right Arrow

Last cell of work area

Ctrl+Home

Cmd+Fn+Left Arrow

First cell of work area

Ctrl+O

Cmd+O

Download and open a file located on a computer or external storage medium

Shift+Ctrl+S

Cmd+ Shift+S

Download file

Ctrl+Zero

Cmd+Zero

Setup scale to 100%

Ctrl and + or

Ctrl+=

Cmd and + or

Cmd+=

Increase scale

Ctrl and —

Cmd and —

Decrease scale

Ctrl+F

Cmd+F

Open the search pane

Ctrl+P

Cmd+P

Print document

Ctrl+;

Cmd+;

Insert current date

Ctrl+Shift+;

Cmd+ Shift+;

Insert current time

Ctrl+Alt+F

Cmd+ Option+F

Insert footnote

Ctrl+K

 Cmd+K

Insert a link to a sheet

Left-click

Left-click

Set cursor in document

Right-click

Right-click

Show context menu

Сtrl+Shift+Space

Cmd+Shift+Space

Insert a non-breaking space