OnlyOffice Spreadsheet Editor keyboard shortcuts 

OnlyOffice Spreadsheet Editor  

Zeynel -
5 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
Ctrl + A

Select all

0
Ctrl + A

Select the entire worksheet

0
Ctrl + A

Select all

0
Del

Remove graphical object

0
Del

Delete to the right

0
Del

Clear content of all selected cells

0
Ctrl + F

Open 'Find' dialog window

0

Move up one row

0

Move left one column

0

Move right one column

0

Move down one row

0
Ctrl + O

Open existing file

0
Ctrl + P

Print spreadsheet

0
Ctrl + I

Italic

0
Ctrl + R

Align right

0
F4

Switch the type of reference

0
Ctrl + Y

Redo

0
Ctrl + B

Bold

0
F9

Recalculate functions

0
Ctrl + E

Align center

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

Move one cell up, down, left, or right

0

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

0

Move shape by a big step

0
Ctrl + U

Underline

0
End

Jump to the end of the line

0
End

Jump to the end of the row

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

Create a copy when dragging

0
Ctrl + 1

Open the 'Number Format' dialog box

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

Move vertical scrollbar Up/Down

0
Ctrl + Tab

Switch to the next tab

0
Ctrl + Space

Select column

0
Ctrl + ↑  Shift + R

Add summary row

0
Ctrl + 0

Reset the ‘Zoom’ parameter

0
Ctrl + ↑  Shift + L

Enable/Remove Filter

0
↑  Shift + ⤶ Enter

Complete cell entry and move up

0
↑  Shift + ⤶ Enter

Move up one row

0
↑  Shift + ⤶ Enter

Move active cell up

0
↑  Shift + ⤶ Enter

Add line break

0
↑  Shift +

Select one cell to the left

0
↑  Shift +

Select one character to the left

0
↑  Shift +

Select one character to the right

0
↑  Shift +

Select one cell to the right

0
Alt + ⤶ Enter

Start new line

0
Ctrl + Home

Jump to the beginning of the text

0
Ctrl + Home

Jump to the beginning of the spreadsheet

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

Strikeout

0
Ctrl + [

Decrease font

0
Alt + C

Clear selected values

0
Ctrl + ,

Superscript

0
↑  Shift + Del

Cut

0
Ctrl + .

Subscript

0
Ctrl + Backspace

Remove graphical object

0
Ctrl + Backspace

Remove word, selection to the left

0
Ctrl + ↑  Shift +

Select one word to the right

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 +

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

Select one word to the left

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

Select from cursor to end of row

0
↑  Shift + End

Select from cursor to end of line

0
↑  Shift + Insert

Paste

0
↑  Shift + Home

Select from cursor to beginning of line

0
↑  Shift + Home

Extend the selection to the first column

0
↑  Shift + Home

Select from cursor to beginning of row

0
Alt + H

Open comment field

0
Alt + Q

Open 'Chat' panel (Online Editors)

0
Ctrl + ↑  Shift + ⤶ Enter

Complete cell entry and stay in it

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.) 1403/9/4 23:20:05 New program added.
1403/9/4 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