Complete LibreOffice Calc keyboard shortcuts reference — 59 shortcuts across 7 categories. Quick reference cheat sheet for Windows & Linux.
LibreOffice Calc keeps Excel's navigation model — Ctrl + arrows to the edge of data, F2 to edit, F4 for absolute references — and differs mainly in the function keys and number formats. The table follows the LibreOffice help for Windows and Linux. If you move between Calc and Excel, the section on differences is the part to read.
| Shortcut | Action |
|---|---|
| Ctrl + Home | Moves the cursor to the first cell in the sheet (A1) |
| Ctrl + End | Moves the cursor to the last cell on the sheet |
| Home | Moves the cursor to the first cell of the current row |
| End | Moves the cursor to the last column |
| Ctrl + Left | Move to Edge of Data Block (Left) |
| Ctrl + Right | Move to Edge of Data Block (Right) |
| Ctrl + Up | Move to Edge of Data Block (Up) |
| Ctrl + Down | Move to Edge of Data Block (Down) |
| Ctrl + Page Up | Previous Sheet |
| Ctrl + Page Down | Next Sheet |
| Ctrl + Shift + F2 | Go to Input Line |
| Ctrl + Shift + F5 | Go to Name Box |
| Shortcut | Action |
|---|---|
| Shift + Home | Select to First Cell of Row |
| Shift + End | Selects all cells from the current cell to the last column |
| Shift + Page Up | Selects cells from the current cell up to one page |
| Shift + Page Down | Selects cells from the current cell down to one page |
| Shift + Space | Select Current Row |
| Ctrl + Space | Select Current Column |
| Ctrl + Shift + Space | Selects all cells in the sheet |
| Ctrl + / | Selects the matrix formula range |
| Ctrl + - | Delete cells (as in menu Edit - Delete Cells) |
| Shift + Enter | Paste Clipboard Contents |
| F8 | Toggle Additional Selection Mode |
| Shortcut | Action |
|---|---|
| Ctrl + F1 | Displays the comment that is attached to the current cell |
| Ctrl + F3 | Opens the Define Names dialog |
| Ctrl + F2 | Opens the Function Wizard |
| Ctrl + Shift + F4 | Shows or Hides the Database explorer |
| F5 | Shows or hides the Navigator |
| Shift + F5 | Traces dependents |
| Shift + F9 | Traces precedents |
| F11 | Open Styles Window |
| Shortcut | Action |
|---|---|
| Ctrl + Shift + Page Up | Add Previous Sheet to Selection |
| Ctrl + Shift + Page Down | Add Next Sheet to Selection |
| Ctrl + + | Insert cells (as in menu Insert - Cells) |
| Shortcut | Action |
|---|---|
| F2 | Edit Cell Contents |
| F4 | Cycle Absolute/Relative References |
| F7 | Checks spelling in the current sheet |
| Ctrl + F7 | Opens the Thesaurus if the current cell contains text |
| Ctrl + F8 | Highlights cells containing values |
| F9 | Recalculates changed formulas in the current sheet |
| Ctrl + Shift + F9 | Recalculates all formulas in all sheets |
| Ctrl + F9 | Updates the selected chart |
| Shift + F11 | Creates a document template |
| F12 | Groups the selected data range |
| Ctrl + F12 | Ungroups the selected data range |
| Shortcut | Action |
|---|---|
| Ctrl + 1 | Open Format Cells dialog |
| Ctrl + Shift + 1 | Two decimal places, thousands separator |
| Ctrl + Shift + 2 | Standard exponential format |
| Ctrl + Shift + 3 | Standard date format |
| Ctrl + Shift + 4 | Standard currency format |
| Ctrl + Shift + 5 | Standard percentage format (two decimal places) |
| Ctrl + Shift + 6 | Standard format |
| Shortcut | Action |
|---|---|
| Tab | Move Focus Forward in Dialog |
| Shift + Tab | Move Focus Backward in Dialog |
| Up | Moves the focus up one item in the current dialog area |
| Down | Moves the focus down one item in the current dialog area |
| Left | Moves the focus one item to the left |
| Right | Moves the focus one item to the right |
| Delete | Removes the current field from the area |
Ctrl + Left, Ctrl + Right, Ctrl + Up and Ctrl + Down jump to the edge of the current block, Ctrl + Home to A1 and Ctrl + End to the last used cell. Shift + Space and Ctrl + Space select the row and column. F2 edits the cell and F4 cycles a reference between relative and absolute forms. sheets are switched with Ctrl + Page Up or Ctrl + Page Down, and Ctrl + 1 opens Format Cells.
Number formats use Ctrl + Shift + digits but map differently: Ctrl + Shift + 1 is two decimals with a thousands separator, Ctrl + Shift + 3 a date, Ctrl + Shift + 4 currency, Ctrl + Shift + 5 percent and Ctrl + Shift + 6 resets to the standard format. Ctrl + - deletes cells and Ctrl + + inserts them, both opening a dialog to choose the shift direction. Ctrl + F2 opens the Function Wizard, Ctrl + F3 the Define Names dialog, and Ctrl + Shift + F2 moves the cursor to the input line. F9 recalculates the sheet and Ctrl + Shift + F9 every sheet.
Shift + F5 draws arrows to the cells that depend on the current one and Shift + F9 to the cells it depends on — the trace tools that Excel hides in a ribbon tab. Ctrl + F8 highlights values, formulas and text in different colours across the sheet, a quick way to spot a hardcoded number in a formula column. F12 groups the selected rows or columns for an outline and Ctrl + F12 ungroups. Ctrl + F1 shows the comment on the current cell and F5 opens the Navigator for sheets, ranges and objects.
Navigation and selection keys, F2, F4 and Ctrl + 1 all match. Number-format shortcuts and cell insert/delete use different keys.
Shift + F9 draws arrows from the precedent cells; Shift + F5 shows the dependents. Both are in Tools › Detective.
Ctrl + F8 highlights values, formulas and text in distinct colours.
Ctrl + + inserts and Ctrl + - deletes; each opens a dialog asking which way to shift the neighbours.
Open your assistant with this page preloaded as the source — great for follow-up questions like "which of these work in other apps?"