OnlyOffice Spreadsheet Editor keyboard shortcuts 

OnlyOffice Spreadsheet Editor  

Zeynel -
6 months ago
- Shortcuts
0
Esc

Close menu or modal window, reset modes, etc.

0
Esc

Cancel

0
Esc

Exit from adding shapes mode, remove selection step by step

0
Tab

Add tab character to the object content

0
Tab

Move focus to the next object

0
Tab

Complete cell entry and move to the right

0
Tab

Move active cell to the right

0
Tab

Move right one column

0
Tab

Navigate between controls in modal dialogues

0
⤶ Enter

Move down one row

0
⤶ Enter

Move active cell down

0
⤶ Enter

Complete cell entry and move down

0
⤶ Enter

Visit hyperlink

0
⤶ Enter

Data Formatting

0
⤶ Enter

Add new placeholder to equation argument

0
⤶ Enter

Working with shapes

0
⤶ Enter

Working with charts

0
⤶ Enter

End paragraph and start a new one

0
F1

Help menu

0
Ctrl + S

Save spreadsheet

0
F2

Edit active cell

0
F2

Data Filtering

0
Ctrl + Z

Undo

0
Del

Delete to the right

0
Del

Clear content of all selected cells

0
Ctrl + A

Select all

0
Ctrl + A

Select the entire worksheet

0
Del

Remove graphical object

0
Ctrl + A

Select all

0
Ctrl + F

Open 'Find' dialog window

0

Move up one row

0

Move left one column

0

Move right one column

0
Ctrl + O

Open existing file

0

Move down one row

0
Ctrl + P

Print spreadsheet

0
Ctrl + I

Italic

0
Ctrl + R

Align right

0
Ctrl + Y

Redo

0
F4

Switch the type of reference

0
Ctrl + B

Bold

0
Ctrl + E

Align center

0
F9

Recalculate functions

0
Ctrl + L

Align left

0
Ctrl + L

Format as table template

0
Ctrl + L

Data Entry

0
Home

Jump to the beginning of the line

0
Home

Jump to the beginning of the row

0
Backspace

Delete to the left

0
Backspace

Clear active cell content

0
Backspace

Remove graphical object

0
F11

Full screen (Online Editors)

0
Ctrl + U

Underline

0

Move one character to the left/right or one line up/down

0

Move one cell up, down, left, or right

0

Move shape by a big step

0
End

Jump to the end of the row

0
End

Jump to the end of the line

0
Page Down

Move down one screen

Advertisement

0
Page Up

Move up one screen

0
Ctrl + H

Open 'Find and Replace' menu (panel) with replacement field

0
Ctrl + K

Insert hyperlink

0
Ctrl + ↑  Shift + S

Download as...

0
Ctrl + ⤶ Enter

Complete cell entry and stay in it

0
Ctrl + ⤶ Enter

Fill the selected cell range with the current entry

0
↑  Shift + Tab

Complete cell entry and move to the left

0
↑  Shift + Tab

Move active cell to the left

0
↑  Shift + Tab

Move left one column

0
↑  Shift + Tab

Navigate between controls in modal dialogues

0
↑  Shift + Tab

Move focus to the previous object

0
Ctrl + 1

Open the 'Number Format' dialog box

0
Ctrl

Create a copy when dragging

0
Ctrl + J

Align justified

0
Ctrl + -

Zoom Out

0
Ctrl +

Move the cursor one word to the left

0
Ctrl +

Move the cursor one word to the right

0
Ctrl +

Jump to the end of the row

0
Ctrl + Tab

Switch to the next tab

0
Ctrl + ↑  Shift + R

Add summary row

0
Ctrl + 0

Reset the ‘Zoom’ parameter

0

Move vertical scrollbar Up/Down

0
Ctrl + ↑  Shift + L

Enable/Remove Filter

0
Ctrl + Space

Select column

0
↑  Shift + ⤶ Enter

Move up one row

0
↑  Shift + ⤶ Enter

Move active cell up

0
↑  Shift + ⤶ Enter

Complete cell entry and move up

0
↑  Shift + ⤶ Enter

Add line break

0
↑  Shift +

Select one character to the left

0
↑  Shift +

Select one cell to the left

0
Alt + ⤶ Enter

Start new line

0
↑  Shift +

Select one character to the right

0
↑  Shift +

Select one cell to the right

0
Ctrl + Home

Jump to the beginning of the spreadsheet

0
Ctrl + Home

Jump to the beginning of the text

0
Ctrl + +

Zoom In

0
↑  Shift +

Select one cell up

0
↑  Shift +

Select one line up

0
↑  Shift +

Select one line down

0
Ctrl + End

Jump to the end of the text

0
↑  Shift +

Select one cell down

0
Ctrl + End

Jump to the end of the spreadsheet

0
Alt + S

Switch multi-select

0
Ctrl + F4

Close file

0
Alt +

Auto Fill (Open drop-down list)

0
Alt +

Open filter window

0
↑  Shift + F3

Insert function

0
Ctrl + ↑  Shift + Tab

Switch to the previous tab

0
Ctrl + 5

Strikeout

0
Ctrl + Del

Remove word, selection to the right

0
Ctrl + Del

Remove graphical object

0
Ctrl + ]

Increase font

0
Ctrl + ↑  Shift + H

Open 'Comments' panel

0
Ctrl + [

Decrease font

0
Alt + C

Clear selected values

0
Ctrl + ,

Superscript

0
Ctrl + .

Subscript

0
↑  Shift + Del

Cut

0
Ctrl + Backspace

Remove word, selection to the left

0
Ctrl + Backspace

Remove graphical object

0
↑  Shift + F10

Element contextual menu

0
Ctrl + ↑  Shift +

Select to the next nonblank cell to the right

0
Ctrl + ↑  Shift +

Extend the selection to the nearest nonblank cell to the right

0
Ctrl + ↑  Shift +

Select one word to the right

0
Ctrl + ↑  Shift +

Select one word to the left

0
Ctrl + ↑  Shift +

Extend the selection to the nonblank cell to the left

0
Ctrl + ↑  Shift +

Select to the next nonblank cell to the left

0
Alt + F

Open 'File' panel

0
↑  Shift + Space

Select row

0
Ctrl + ↑  Shift +

Select to the next nonblank cell up

0
Ctrl + ↑  Shift +

↓  Extend the selection to the nearest nonblank cell up/down the column

0
Ctrl + ↑  Shift +

Select to the next nonblank cell down

0
Ctrl + Insert

Copy

0
↑  Shift + End

Extend the selection to the nearest nonblank cell to the right

0
↑  Shift + Insert

Paste

0
↑  Shift + End

Select from cursor to end of row

0
↑  Shift + End

Select from cursor to end of line

0
↑  Shift + Home

Extend the selection to the first column

0
↑  Shift + Home

Select from cursor to beginning of row

0
↑  Shift + Home

Select from cursor to beginning of line

0
Alt + H

Open comment field

0
Ctrl + ↑  Shift + ⤶ Enter

Complete cell entry and stay in it

0
Alt + Q

Open 'Chat' panel (Online Editors)

0
↑  Shift + F9

Recalculate functions

0
↑  Shift + +

Constrain movement

0
↑  Shift + +

(drag when rotating) Set 15-degree rotation

0
↑  Shift + +

(drag when rotating) Maintain proportions

0
↑  Shift + +

(drag when rotating) Change angle of line/arrow when drawing

0
Shift + Page Up

Extend the selection up one screen

0
Shift + Page Down

Extend the selection down one screen

0
Ctrl + ↑  Shift + Home

Extend the selection to beginning of worksheet


Share this page on:
Is this page helpful?
0 0

Program information

Program name: OnlyOffice Spreadsheet Editor OnlyOffice Spreadsheet Editor (Productivity)

Web page: onlyoffice.com/spreadsheet-edi...

More information >>

Updated: Updated program information. (2 updates.) 24.11.2024 23:20:05 New program added.
24.11.2024 23:28:15 Updated program information.

Shortcut count: 193

Platform detected: Windows or Linux

Similar programs



Download OnlyOffice Spreadsheet Editor

OnlyOffice Spreadsheet Editor is available for download.

License: Freeware

Go to download page

User operations

Add OnlyOffice Spreadsheet Editor to your list of favorites

Advertisement


What is your favorite OnlyOffice Spreadsheet Editor hotkey? Do you have any useful tips for it? Let other users know below.


Only registered users can post links.
 
No comments yet. Ask, or type the first one!

Latest articles