# OnlyOffice Spreadsheet Keyboard Shortcuts

Learn the OnlyOffice Spreadsheet Editor keyboard shortcuts that speed up comparison entry, from moving between cells to editing, formatting, and finding values.

OnlyOffice Spreadsheet Keyboard Shortcuts are key combinations that let you move, edit, format, and navigate the ONLYOFFICE Spreadsheet Editor without reaching for the mouse. The set that matters for comparison entry covers cell movement, editing, selection, formatting, and search. Learning a handful of these hotkeys keeps your hands on the keys while you line up estimates side by side. 

- Arrow keys move one cell at a time, and Ctrl with an arrow jumps to the edge of a block of data.
- F2 opens the active cell for editing, while Enter confirms and moves down.
- Ctrl with the plus or minus keys inserts or deletes rows, columns, and cells.
- Ctrl+F opens search so you can locate a value in a long estimate sheet.
- Shortcut keys differ between editors and operating systems, so check the list that matches your setup.
 

## Moving around the sheet without the mouse 

Cell navigation shortcuts in the ONLYOFFICE Spreadsheet Editor keep your hands on the keyboard while you read across a row of figures. The arrow keys move the selection one cell in the pressed direction. Holding Ctrl with an arrow key jumps to the last filled cell in that direction, which helps you cross a long column of line items. 

The Home key returns the selection to the start of the current row, and Ctrl with Home goes to the top-left cell of the sheet. The Tab key moves one cell to the right and Shift with Tab moves one cell to the left. These moves stay inside the used area of the sheet when a range is selected. 

Page Up and Page Down scroll one screen at a time, so a large repair-estimate sheet stays readable without grabbing the scrollbar. Ctrl with Page Up or Page Down switches between worksheet tabs. Check the shortcut list for your version before you rely on a key you have not tried. 

## Entering and editing values in cells 

Editing shortcuts in the ONLYOFFICE Spreadsheet Editor decide whether a keystroke types text or moves the selection. Typing a character starts entry in the active cell, and Enter confirms the value and moves down. Shift with Enter confirms and moves up, which suits a column of figures entered from bottom to top. 

F2 puts the active cell into edit mode with the cursor inside the existing content. Esc cancels the entry and restores the previous value. Alt with Enter inserts a line break inside the cell when you need a note under a line item. 

Ctrl with Enter fills the selected range with the current entry, which copies one value across several cells at once. Ctrl with Z undoes the last action and Ctrl with Y redoes it. Treat undo as a safety net for typing, not a substitute for checking figures before you share the sheet. 

## Selecting cells, rows, and columns 

Selection shortcuts in the ONLYOFFICE Spreadsheet Editor speed up work on whole rows, columns, and blocks of data. Shift with the arrow keys extends the selection one cell at a time. Ctrl with Shift and an arrow key extends the selection to the edge of the data block. 

Ctrl with the spacebar selects the entire column of the active cell, and Shift with the spacebar selects the entire row. Ctrl with A selects the current data region and, pressed again, the whole sheet. These selections feed into formatting, copying, or deletion steps in one stroke. 

Ctrl with Shift and the plus sign selects the range you name in the dialog, which helps when you already know the address of a block. Name the range first and the selection lands exactly where you need it for a side-by-side comparison. 

## Inserting and deleting rows and columns 

Structural shortcuts in the ONLYOFFICE Spreadsheet Editor change the shape of a comparison table without a trip to the menus. Ctrl with the plus key opens the insert dialog for cells, rows, or columns. Ctrl with the minus key opens the delete dialog for the same choices. 

When a full row or column is selected, the insert or delete action applies to that whole line. Selecting a single cell and using the dialog asks you to choose the shift direction. Choosing the wrong shift direction moves data out of line, so read the dialog before you confirm. 

Deleting a row that holds source figures removes the values from the sheet, and undo restores them only while the session keeps the history. Copy the sheet or keep a backup before a large restructure of a repair estimate. 

## Formatting figures and text with hotkeys 

Formatting shortcuts in the ONLYOFFICE Spreadsheet Editor apply number and text styles to the selected cells. Ctrl with B applies bold and Ctrl with I applies italic to the current selection. Ctrl with U applies an underline. 

Ctrl with Shift and the number keys applies a number format to the selection, such as a plain number, a currency value, or a date. The exact key for each format depends on the editor version, so confirm it in the shortcut list before you commit a figure to a column. 

Ctrl with Shift and the tilde key applies the general number format, which strips a currency or date style from the cells. Formatting is display only and does not change the stored value. A currency format on a comparison column makes the amounts easier to read side by side. 

## Copying, pasting, and filling a comparison table 

Clipboard shortcuts in the ONLYOFFICE Spreadsheet Editor carry a figure from a provider quote into your comparison sheet. Ctrl with C copies the selection, Ctrl with X cuts it, and Ctrl with V pastes at the active cell. Ctrl with Shift and V opens paste special, where you choose values, formulas, or formatting alone. 

Paste special with values only is the safer choice when a quote arrives with its own formatting. The values land in your sheet without overwriting the number format you set for the column. Formulas pasted as values stop recalculating against cells that do not exist in your sheet. 

A fill handle drag copies a pattern down a column, and Ctrl with D fills the selected cells downward from the top cell. Ctrl with R fills to the right. These fill shortcuts repeat a formula or a label across a block without retyping it. 

## Finding and replacing values in a long sheet 

Search shortcuts in the ONLYOFFICE Spreadsheet Editor locate a figure or a label across a sheet of repair line items. Ctrl with F opens the search field, and Enter moves to the next match. Ctrl with H opens find and replace for a change that repeats across the sheet. 

Ctrl with G opens the go-to dialog, where you type a cell address or a named range. Go-to is faster than scrolling when you know where a figure sits. A named range also works in formulas, which keeps a comparison sheet readable. 

Replace all changes every match at once, so review the search term before you confirm. A wide search term can rewrite labels you did not intend to touch. Undo reverses the batch only while the history holds it. 

## Shortcut habits that keep estimates clean 

A steady set of ONLYOFFICE Spreadsheet Editor hotkeys keeps a comparison sheet consistent from the first quote to the last. Enter a label in one column and a figure in the next, then press Tab to move right and Enter to drop to the next row. The rhythm suits repeated entry of line items. 

Ctrl with S saves the workbook, and the save shortcut matters after a long block of entry. Save before a structural change and again after it. A saved copy gives you a point to return to if a delete or a replace goes wrong. 

Key combinations vary between the desktop app, the web editor, and different operating systems, so open the shortcut list that matches your setup. Learn a few keys at a time and add more as the muscle memory settles. The keyboard reference in the editor shows the full mapping. 

- Arrow keys move one cell, and Ctrl with an arrow jumps to the data edge.
- F2 edits the active cell, and Esc cancels the entry.
- Ctrl with the plus or minus key inserts or deletes rows and columns.
- Ctrl with Shift and a number key applies a number format.
- Ctrl with C, X, and V copy, cut, and paste the selection.
- Ctrl with F finds a value and Ctrl with H replaces it.
- Ctrl with S saves the workbook before a structural change.
 

## Questions about OnlyOffice spreadsheet shortcuts 

### What are the OnlyOffice spreadsheet keyboard shortcuts? 

OnlyOffice spreadsheet keyboard shortcuts are key combinations that carry out spreadsheet actions without the mouse. They cover moving between cells, editing values, selecting ranges, formatting, copying and pasting, and finding text. The ONLYOFFICE Spreadsheet Editor lists its full set in the shortcut reference for each version. 

### How do I edit a cell without retyping it? 

Press F2 to open the active cell for editing with the cursor inside the existing content. The ONLYOFFICE Spreadsheet Editor then lets you change part of the value and press Enter to confirm. Pressing Esc instead restores the previous content. 

### Which shortcut inserts a new row in OnlyOffice? 

Ctrl with the plus key opens the insert dialog in the ONLYOFFICE Spreadsheet Editor. With a full row selected, the dialog inserts a row above the selection. With one cell selected, the dialog asks which direction to shift the existing cells. 

### Why does a shortcut not work in my browser? 

A shortcut can fail when the web browser claims the same key combination for its own action. The ONLYOFFICE Spreadsheet Editor maps some keys differently in the browser than in the desktop app. Check the shortcut list for your version and platform before you assume a key is broken. 

### Can I find a value across a whole workbook? 

Ctrl with F opens search in the ONLYOFFICE Spreadsheet Editor, and the search options decide whether it looks in the current sheet only or across the workbook. Set the scope before you start typing. Ctrl with H opens find and replace for a repeated change.
