OnlyOffice Spreadsheet Editor keyboard shortcuts 

OnlyOffice Spreadsheet Editor  

Zeynel -
27 days ago
- Shortcuts
0
Alt + F

Open 'File' panel

0
Ctrl + F

Open 'Find' dialog window

0
Ctrl + H

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

0
Ctrl + ↑  Shift + H

Open 'Comments' panel

0
Alt + H

Open comment field

0
Alt + Q

Open 'Chat' panel (Online Editors)

0
Ctrl + S

Save spreadsheet

0
Ctrl + P

Print spreadsheet

0
Ctrl + ↑  Shift + S

Download as...

0
F11

Full screen (Online Editors)

0
F1

Help menu

0
Ctrl + O

Open existing file

0
Ctrl + Tab

Switch to the next tab

0
Ctrl + ↑  Shift + Tab

Switch to the previous tab

0
Ctrl + W,

Close file

0
or Ctrl + F4
0
↑  Shift + F10

Element contextual menu

0
Esc

Close menu or modal window, reset modes, etc.

0
Ctrl + 0

Reset the ‘Zoom’ parameter

0
Ctrl +
+

(hold on a sheet tab) Duplicate a worksheet

Advertisement

0

Move one cell up, down, left, or right

0
⤶ Enter

Move active cell down

0
↑  Shift + ⤶ Enter

Move active cell up

0
Tab

Move active cell to the right

0
↑  Shift + Tab

Move active cell to the left

0
Ctrl +

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

0
Home

Jump to the beginning of the row

0
Ctrl + Home

Jump to the beginning of the spreadsheet

0
End

Jump to the end of the row

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

Move up one row

0
or ↑  Shift + ⤶ Enter
0

Move down one row

0
or ⤶ Enter
0

Move left one column

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

Zoom In

0
Ctrl + -

Zoom Out

0
Tab

Navigate between controls in modal dialogues

0
or ↑  Shift + Tab
0
Ctrl + A

Select the entire worksheet

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

Advertisement

0
↑  Shift + Home

Select from cursor to beginning of row

0
↑  Shift + End

Select from cursor to end of row

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

Extend the selection to the nearest nonblank cell to the right

0
or Ctrl + ↑  Shift +
0
Ctrl + ↑  Shift +

Extend the selection to the nonblank cell to the left

0
↑  Shift + Home

Extend the selection to the first column

0
Ctrl + ↑  Shift +

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

0
Shift + Page Down

Extend the selection down one screen

0
Shift + Page Up

Extend the selection up one screen

0
Ctrl + Z

Undo

0
Ctrl + Y

Redo

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

Insert hyperlink

0
⤶ Enter

Visit hyperlink

0
⤶ Enter

Data Formatting

0
Ctrl + B

Bold

0
Ctrl + I

Italic

0
Ctrl + U

Underline

0
Ctrl + 5

Strikeout

0
F2

Edit active cell

0
F2

Data Filtering

0
Ctrl + ↑  Shift + L

Enable/Remove Filter

0
Alt +

Open filter window

0
Ctrl + L

Format as table template

0
Ctrl + L

Data Entry

0
⤶ Enter

Complete cell entry and move down

0
↑  Shift + ⤶ Enter

Complete cell entry and move up

0
Tab

Complete cell entry and move to the right

0
↑  Shift + Tab

Complete cell entry and move to the left

0
Ctrl + ↑  Shift + ⤶ Enter

Complete cell entry and stay in it

0
or Ctrl + ⤶ Enter
0
Ctrl + ⤶ Enter

Fill the selected cell range with the current entry

0
Alt + ⤶ Enter

Start new line

0
⤶ Enter

Add new placeholder to equation argument

0
Esc

Cancel

0
Backspace

Delete to the left

0
Del

Delete to the right

0
Del,

Clear active cell content

0
or Backspace
0
Del

Clear content of all selected cells

0
Ctrl + ↑  Shift + =

Insert cells

0
Ctrl + ↑  Shift + -

Delete cells

0
Ctrl + ;

Insert the current date

0
Ctrl + ↑  Shift + ;

Insert the current time

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

Insert the current date and time

0
Num .

Insert separator

0
Alt +

Auto Fill (Open drop-down list)

0
Ctrl + Backspace

Remove word, selection to the left

0
Ctrl + Del

Remove word, selection to the right

0
Ctrl + A

Select all

0

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

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

Select one word to the left

0
Ctrl + ↑  Shift +

Select one word to the right

0
Ctrl + Home

Jump to the beginning of the text

0
Ctrl + End

Jump to the end of the text

0
Ctrl + ↑  Shift + Home

Select from cursor to beginning of text

0
Ctrl + ↑  Shift + End

Select from cursor to end of text

0
Home

Jump to the beginning of the line

0
End

Jump to the end of the line


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.
Checking site status...
 
No comments yet. Ask, or type the first one!

Latest articles