How can we help you?

If hotkeys are assigned to any command in the application, they are indicated in the drop-down menus next to the command names.

The shortcuts are also displayed in the context menu when working with an open document.

Edit content

Key combination

Command or action

Windows

macOS

Ctrl+Z

Cmd+Z

Cancel

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 original formatting

Alt+Enter

Option+Enter

Insert line break in edit mode

Backspace

Backspace

Delete one character to the left in a cell in edit mode

Ctrl+Backspace

Cmd+Backspace or

Option+Backspace

Delete one word on the left side of the cell in edit mode

Delete

Fn+Backspace

Delete one character on the right side of the cell in edit mode

Ctrl+Delete

Cmd+Fn+Backspace or

Option+Fn+Backspace

Delete one word on the right side of the cell in edit mode

Backspace or Delete

Backspace or Fn+Backspace

Delete data from the selected cell

The Mozilla Firefox browser does not allow access to the clipboard via the command and context menus. Inserting data is only available using the Ctrl+V (Cmd+V) keyboard shortcut.

Formatting content

Key combination

Command or action

Windows

macOS

Ctrl+B

Cmd+B

Bold

Ctrl+I

Cmd+I

Italic

Ctrl+U

Cmd+U

Underlined

Ctrl+5

Cmd+5

Underlined

Ctrl+Shift+=

Cmd+Shift+=

Superscript

Ctrl+Shift+-

Cmd+Shift+-

Subscript

Ctrl+Shift+,

Cmd+Shift+,

Reduce 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

Content alignment

Key combination

Command or action

Windows

macOS

Ctrl+Shift+L

Cmd+Shift+L

Align to left

Ctrl+Shift+E

Cmd+Shift+E

Center

Ctrl+Shift+R

Cmd+Shift+R

Align to right

Ctrl+Shift+J

Cmd+Shift+J

Justify

Selecting cell contents

Key combination

Command or action

Windows

macOS

Ctrl+A

Cmd+A

Select all cell contents

Shift+Left Arrow

Shift+Left Arrow

Select one character to the left or deselect that character

Shift+Right arrow

Shift+Right Arrow

Select one character to the right or deselect this character

Ctrl+Shift+Left Arrow

Cmd+Shift+Left Arrow

Select one word on the left or deselect it

Ctrl+Shift+Right Arrow

Cmd+Shift+Right Arrow

Select one word to the right or deselect it

Shift+Home

Fn+Shift+Left Arrow

Select content from the cursor to the beginning of the cell

Shift+End

Fn+Shift+Right Arrow

Select content from the cursor to the end of the row

Ctrl+Shift+Home

Cmd+Fn+Shift+Left Arrow

Extend the selection to the beginning of the cell

Ctrl+Shift+End

Cmd+Fn+Shift+Right Arrow

Extend selection to the end of the cell

Shift+Down Arrow

Shift+Down Arrow

Extend selection one row down

Shift+Up Arrow

Shift+Up Arrow

Expand selection one line up

Double-click

Double-click

Select a word

Triple-press

Triple-press

Select a paragraph

Click and move the cursor upward

Click and move the cursor upward

Select text up

Click and move the cursor downward

Click and move the cursor downward

Select text down

Working with a table

Key combination

Command or action

Windows

macOS

Alt+L

Option+L

Insert column from left

Alt+R

Option+R

Insert column on the right

Alt+A

Option+A

Insert row above

Alt+B

Option+B

Insert line below

Alt+Ctrl+R

Option+Cmd+R

Delete line

Alt+Ctrl+U

Option+Cmd+U

Delete column

Alt+Ctrl+M

Option+Cmd+M

Merge cells

Alt+Shift+M

Option+Shift+M

Separate cells

Tab or Right Arrow

Tab or Right Arrow

Move to the next cell

Shift+Tab or Left Arrow

Shift+Tab or Left Arrow

Go to the previous cell

Shift+Right/Up/Down/Left Arrow

Shift+Right/Up/Down/Left Arrow

Select range

Down arrow

Down Arrow

Move to the cell below

Up arrow

Up arrow

Move to the cell above

Right arrow

Right arrow

Move to the cell on the right

Left arrow

Left arrow

Move to the cell on the left

Ctrl+A

Cmd+A

Select all cells

The Safari browser does not support deleting a table row with the keyboard shortcut Option+Cmd+R.

Moving around the document

Key combination

Command or action

Windows

macOS

Home

Cmd+Left Arrow or

Fn+Left Arrow

Go to the beginning of the line

End

Cmd+Right Arrow or

Fn+Right Arrow

Go to the end of the line

Ctrl+Left Arrow

Cmd+Left Arrow

Move one word to the left in cell editing mode

Ctrl+Right Arrow

Cmd+Right Arrow

Go one word to the right in cell editing mode

Up arrow

Up Arrow

Go one line up in cell editing mode

Down arrow

Down arrow

Go one row down in cell edit mode

Left arrow

Left arrow

Move one character to the left in cell editing mode

Right arrow

Right arrow

Go one character to the right in cell edit mode

Page Up

Cmd+Fn+Up Arrow

Move up one screen

Page Down

Cmd+Fn+Down Arrow

Go one screen down

Ctrl+End

Cmd+Fn+Right Arrow

Go to the last cell in the workspace

Ctrl+Home

Cmd+Fn+Left Arrow

Move to the first cell of the workspace

Other shortcuts

Key combination

Command or action

Windows

macOS

Ctrl+O

Cmd+O

Load and open a file located on your computer or external storage media

Ctrl+0

Cmd+0

Set zoom to 100%

Ctrl and + or

Ctrl+=

Cmd and + or

Cmd+=

Zoom in

Ctrl and -

Cmd and -

Zoom out

Ctrl+F

Cmd+F

Open document search panel

Ctrl+P

Cmd+P

Print document

Ctrl+;

Cmd+;

Insert current date

Ctrl+Shift+;

Cmd+Shift+;

Insert current time

Ctrl+K

Cmd+K

Insert sheet reference

Shift+F11

Shift+F11

Insert sheet

Click

Click

Position the cursor in the document

Right-click

Right-click

Open the context menu of the selected item

Ctrl+Shift+Space

Cmd+Shift+Space

Option+Space

Insert non-breaking space

Alt+=

Option+=

Autosum

 

Was this helpful?
Yes
No
Previous
Macros