LibreOffice Calc keyboard shortcuts cheat sheet
The Document Foundation · 62 shortcuts62 LibreOffice Calc shortcuts grouped by task. Click any row for the full answer page.
Essentials
| Action | Windows |
|---|---|
| Open file | Ctrl+OCtrlO |
| Select all cells | Ctrl+ACtrlA |
| Edit cell | F2F2 |
| Cycle reference types | F4F4 |
| Spelling check | F7F7 |
| Recalculate sheet | F9F9 |
| Recalculate all sheets | Ctrl+Shift+F9CtrlShiftF9 |
| Open Function Wizard | Ctrl+F2CtrlF2 |
| Open Format Cells | Ctrl+1Ctrl1 |
| Insert cells | Ctrl++Ctrl+ |
| Delete cells | Ctrl+-Ctrl- |
| Delete contents without dialog | DeleteDelete |
| Delete contents with dialog | Backspace⌫ |
| Cut without formatting | Ctrl+Shift+XCtrlShiftX |
| Toggle Navigator | F5F5 |
| Toggle Styles window | Ctrl+F11CtrlF11 |
Navigation
| Action | Windows |
|---|---|
| Go to cell A1 | Ctrl+HomeCtrlHome |
| Go to last cell with data | Ctrl+EndCtrlEnd |
| Go to first cell of row | HomeHome |
| Go to last column with data | EndEnd |
| Jump left to data edge | Ctrl+LeftCtrl← |
| Jump right to data edge | Ctrl+RightCtrl→ |
| Jump up to data edge | Ctrl+UpCtrl↑ |
| Jump down to data edge | Ctrl+DownCtrl↓ |
| Previous sheet | Ctrl+PgUpCtrlPgUp |
| Next sheet | Ctrl+PgDnCtrlPgDn |
| Move screen left | Alt+PgUpAltPgUp |
| Move screen right | Alt+PgDnAltPgDn |
| Focus input line | Ctrl+Shift+F2CtrlShiftF2 |
| Focus Name Box | Ctrl+Shift+F5CtrlShiftF5 |
Selection
| Action | Windows |
|---|---|
| Select current row | Shift+SpaceShiftSpace |
| Select current column | Ctrl+SpaceCtrlSpace |
| Select data block range | Ctrl+Shift+ArrowCtrlShiftArrow |
| Select data block around cursor | Ctrl+*Ctrl* |
| Select matrix formula range | Ctrl+/Ctrl/ |
| Select to start of row | Shift+HomeShiftHome |
| Select to end of data in row | Shift+EndShiftEnd |
| Additional selection mode | F8F8 |
| Add previous sheet to selection | Ctrl+Shift+PgUpCtrlShiftPgUp |
| Add next sheet to selection | Ctrl+Shift+PgDnCtrlShiftPgDn |
Formulas and data
| Action | Windows |
|---|---|
| Fill range with formula | Alt+EnterAlt↵ |
| Enter array formula | Ctrl+Shift+EnterCtrlShift↵ |
| Insert manual line break | Ctrl+EnterCtrl↵ |
| Show or hide formulas | Ctrl+`Ctrl` |
| Define names | Ctrl+F3CtrlF3 |
| Highlight values | Ctrl+F8CtrlF8 |
| Update chart | Ctrl+F9CtrlF9 |
| Trace dependents | Shift+F5ShiftF5 |
| Trace precedents | Shift+F9ShiftF9 |
| Group data | F12F12 |
| Ungroup data | Ctrl+F12CtrlF12 |
| Insert cell comment | Ctrl+F1CtrlF1 |
Formatting
| Action | Windows |
|---|---|
| Two decimals with thousands separator | Ctrl+Shift+1CtrlShift1 |
| Exponential format | Ctrl+Shift+2CtrlShift2 |
| Date format | Ctrl+Shift+3CtrlShift3 |
| Currency format | Ctrl+Shift+4CtrlShift4 |
| Percentage format | Ctrl+Shift+5CtrlShift5 |
| Standard format | Ctrl+Shift+6CtrlShift6 |
| Increase row height | Alt+DownAlt↓ |
| Decrease row height | Alt+UpAlt↑ |
| Increase column width | Alt+RightAlt→ |
| Decrease column width | Alt+LeftAlt← |
More office apps shortcuts
Ask your agent
Prompt
Make me a one-page LibreOffice Calc cheat sheet from the 62 shortcuts at https://keyflowhub.com/shortcuts/libreoffice-calc, ordered by what I'm most likely to use, and point out any that clash with my current keybindings.
Paste into Claude Code and it will do the rest.
Sources: help.libreoffice.org