LibreOffice Calc Keyboard Shortcuts
Complete LibreOffice Calc keyboard shortcuts reference — 59 shortcuts across 7 categories. Quick reference cheat sheet for Windows & Linux.
Cursor Movement (12)
| 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 |
Selection (11)
| 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 |
Open, Display & Hide (8)
| 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 |
Insert & Add (3)
| 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) |
Spreadsheet Keys (11)
| 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 |
Number Formatting (7)
| 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 |
Pivot Table (7)
| 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 |
📜 Every shortcut on this page is taken from the official LibreOffice Calc documentation —
help.libreoffice.org🔧 Spotted an error or a missing shortcut?
Suggest an edit on GitHub — every accepted fix goes live on this page, the API and the CLI.
🤖 Ask AI about LibreOffice Calc shortcuts
Open your assistant with this page preloaded as the source — great for follow-up questions like "which of these work in other apps?"