OnlyOffice Spreadsheet Editor keyboard shortcuts 

OnlyOffice Spreadsheet Editor  

Zeynel -
5 months ago
- Shortcuts
0
Ctrl + F

Open 'Find' dialog window

0
Ctrl + H

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

0
Alt + H

Open comment field

0
Ctrl + S

Save spreadsheet

0
F11

Full screen (Online Editors)

0
F1

Help menu

0
Esc

Close menu or modal window, reset modes, etc.

0
Ctrl + F4

Close file

0

Move one cell up, down, left, or right

0
⤶ Enter

Move active cell down

0
Tab

Move active cell to the right

0
End

Jump to the end of the row

0
Home

Jump to the beginning of the row

0

Move up one row

0

Move right one column

0
or Tab
0
Page Down

Move down one screen

0
Page Up

Move up one screen

0

Move vertical scrollbar Up/Down

0
↑  Shift +

Move horizontal scrollbar Left/Right

0

Move down one row

0
or ⤶ Enter
0

Move left one column

0
Tab

Navigate between controls in modal dialogues

0
Ctrl + A

Select the entire worksheet

0
Ctrl + Z

Undo

0
Ctrl + Y

Redo

0
⤶ Enter

Visit hyperlink

0
⤶ Enter

Data Formatting

0
Ctrl + B

Bold

0
Ctrl + 5

Strikeout

0
F2

Edit active cell

0
F2

Data Filtering

0
⤶ Enter

Complete cell entry and move down

0
Tab

Complete cell entry and move to the right

0
⤶ Enter

Add new placeholder to equation argument

0
Esc

Cancel

0
Del

Clear content of all selected cells

0
Del

Delete to the right

0
Ctrl + A

Select all

0

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

0
Home

Jump to the beginning of the line

0
End

Jump to the end of the line

0
↑  Shift + F3

Insert function

0
F9

Recalculate functions

0
Ctrl + 1

Open the 'Number Format' dialog box

0
F4

Switch the type of reference

0
⤶ Enter

Working with shapes

0
⤶ Enter

Working with charts

0
Ctrl + A

Select all

0
Tab

Add tab character to the object content

0

Move shape by a big step

0
Tab

Move focus to the next object

0
Ctrl + E

Align center

0
Ctrl + R

Align right

0
Del

Remove graphical object

0
⤶ Enter

End paragraph and start a new one

0
Esc

Exit from adding shapes mode, remove selection step by step

0
Ctrl

Create a copy when dragging

Advertisement

0
↑  Shift + F9

Recalculate functions

0
Alt + =

SUM function

0
Ctrl + Del

Remove word, selection to the right

0
Alt + F5

Update pivot table

0
Ctrl + ↑  Shift + R

Add summary row

0
Ctrl +

Movement by one-pixel increments

0
↑  Shift + ⤶ Enter

Add line break

0
Ctrl + Del

Remove graphical object

0
Ctrl + J

Align justified

0
↑  Shift + Home

Select from cursor to beginning of line

0
↑  Shift + End

Select from cursor to end of line

0
↑  Shift +

Select one line up

0
↑  Shift +

Select one line down

0
Ctrl + Home

Jump to the beginning of the text

0
Ctrl + End

Jump to the end of the text

0
↑  Shift +

Select one character to the right

0
↑  Shift +

Select one character to the left

0
Ctrl +

Move the cursor one word to the left

0
Ctrl +

Move the cursor one word to the right

0
Ctrl + ⤶ Enter

Complete cell entry and stay in it

0
Ctrl + ⤶ Enter

Fill the selected cell range with the current entry

0
Alt + ⤶ Enter

Start new line

0
Ctrl + U

Underline

0
↑  Shift + ⤶ Enter

Complete cell entry and move up

0
↑  Shift + Del

Cut

0
Ctrl + Insert

Copy

0
↑  Shift + Insert

Paste

0
Ctrl + K

Insert hyperlink

0
Shift + Page Down

Extend the selection down one screen

0
Shift + Page Up

Extend the selection up one screen

0
↑  Shift + End

Extend the selection to the nearest nonblank cell to the right

0
↑  Shift + Home

Extend the selection to the first column

0
Ctrl + Space

Select column

0
↑  Shift + Space

Select row

0
↑  Shift +

Select one cell to the right

0
↑  Shift +

Select one cell to the left

0
↑  Shift +

Select one cell up

0
↑  Shift +

Select one cell down

0
↑  Shift + Home

Select from cursor to beginning of row

0
↑  Shift + End

Select from cursor to end of row

0
↑  Shift + ⤶ Enter

Move up one row

0
Ctrl + Home

Jump to the beginning of the spreadsheet

0
Ctrl +

Jump to the end of the row

0
Ctrl + End

Jump to the end of the spreadsheet

0
Alt + Page Up

Move to the previous sheet

0
Alt + Page Down

Move to the next sheet

0
Ctrl + ↑  Shift + S

Download as...

0
Ctrl +

Jump to the edge of the visible data region or the next cell with data

0
↑  Shift + ⤶ Enter

Move active cell up

0
↑  Shift + F10

Element contextual menu

0
Ctrl + 0

Reset the ‘Zoom’ parameter

0
Ctrl + ↑  Shift + H

Open 'Comments' panel

0
Ctrl + `

Display functions on sheet

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

(hold on a sheet tab) Duplicate a worksheet

0
Ctrl + ↑  Shift +

Select to the next nonblank cell to the right

0
Ctrl + ↑  Shift +

Select to the next nonblank cell to the left

0
Ctrl + ↑  Shift +

Select to the next nonblank cell up

0
Ctrl + ↑  Shift +

Select to the next nonblank cell down

0
Ctrl + ↑  Shift + Home

Extend the selection to beginning of worksheet

0
Ctrl + ↑  Shift + End

Extend the selection to the last used cell

0
Ctrl + ↑  Shift +

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

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

Select the entire worksheet

0
Ctrl + +

Zoom In

0
Ctrl + -

Zoom Out

0
Ctrl + ↑  Shift + ⤶ Enter

Complete cell entry and stay in it

0
Ctrl + ↑  Shift + L

Enable/Remove Filter

0
Ctrl + ↑  Shift + =

Insert cells

0
Ctrl + ↑  Shift + ;

Insert the current time

0
Ctrl + ↑  Shift +

Select one word to the left

0
Ctrl + ↑  Shift +

Select one word to the right

0
Ctrl + ↑  Shift + Home

Select from cursor to beginning of text

0
Ctrl + ↑  Shift + End

Select from cursor to end of text

0
Ctrl + I

Italic

0
Ctrl + L

Format as table template

0
Ctrl + L

Data Entry

0
Ctrl + O

Open existing file

0
Ctrl + ↑  Shift + ~

Apply the General format

0
Ctrl + L

Align left

0
Backspace

Remove graphical object

0
Alt + C

Clear selected values

0
Alt + S

Switch multi-select

0
Ctrl + Alt + F5

(Only Windows, won't work on Linux) Update all pivot tables

0
Ctrl + ↑  Shift + !

Apply the Number format

0
Alt + F

Open 'File' panel

0
Alt + Q

Open 'Chat' panel (Online Editors)


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.) 2024. 11. 24. 23:20:05 New program added.
2024. 11. 24. 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