OnlyOffice Spreadsheet Editor keyboard shortcuts 

OnlyOffice Spreadsheet Editor  

Zeynel -
5 months ago
- Shortcuts
0
Ctrl + ↑  Shift + Space

Select the entire worksheet

0
Ctrl + ↑  Shift + End

Extend the selection to the last used cell

0
Ctrl + ↑  Shift + Home

Select from cursor to beginning of text

0
Ctrl + ↑  Shift + End

Select from cursor to end of text

0
Ctrl +

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

0
Ctrl +

Movement by one-pixel increments

0
Ctrl + +

(hold on a sheet tab) Duplicate a worksheet

0
Ctrl + ↑  Shift + -

Delete cells

0
Ctrl + `

Display functions on sheet

0
Alt + Page Up

Move to the previous sheet

0
Alt + Page Down

Move to the next sheet

0
Ctrl + ;

Insert the current date

0
Alt + F5

Update pivot table

0
↑  Shift +

Move horizontal scrollbar Left/Right

0
Ctrl + ↑  Shift + =

Insert cells

0
Num .

Insert separator

0
Alt + =

SUM function

0
Ctrl + ↑  Shift + ;

Insert the current time

0
Ctrl + Alt + F5

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

0
Ctrl + ↑  Shift + ~

Apply the General format

0
Ctrl + ↑  Shift + !

Apply the Number format

0
Ctrl + ↑  Shift + %

Apply the Percentage format

0
Ctrl + ↑  Shift + @

Apply the Time format

0
Ctrl + ↑  Shift + $

Apply the Currency format

0
Ctrl + ↑  Shift + #

Apply the Date format

0
Ctrl + X,

Cut

0
Ctrl + ↑  Shift + ^

Apply the Exponential format

Advertisement

0
Ctrl + W,

Close file

0
Ctrl + C,

Copy

0
Ctrl + V,

Paste

0
Ctrl then F

Paste only formula

0
Ctrl then O

Paste formula + number format

0
Ctrl then K

Paste formula + all formatting

0
Ctrl then B

Paste formula without borders

0
Ctrl then W

Paste formula + column width

0
Ctrl then T

Transpose

0
Ctrl then V

Paste only value

0
Ctrl then A

Paste value + number format

0
Ctrl then E

Paste value + all formatting

0
Ctrl then R

Paste only formatting

0
Ctrl then N

Paste link

0
Del,

Clear active cell content

0
Ctrl + ; then Space then Ctrl + ↑  Shift + ;

Insert the current date and time


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 下午11:20:05 New program added.
2024/11/24 下午11: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