LibreOffice Calc keyboard shortcuts
Calc spreadsheet shortcuts plus shared LibreOffice application commands.
46 shortcuts Mac and Windows checked September 11, 2026
Print all 46 shortcuts One sheet with every shortcut in this app, ready for the printer or a PDF.
8 actions and 8 key variants match.
- LibreOffice Calc Documented
| Action | Keys | Row actions |
|---|---|---|
| Build a formula with guidance Function Wizard | Windows CtrlF2 | Source |
| Define a named range Define Names dialog | Windows CtrlF3 | Source |
| Trace dependents Formula cell | Windows ShiftF5 | Source |
| Trace precedents Formula cell | Windows ShiftF9 | Source |
| Reference locking Formula editing | Windows F4 | Source |
| Recalculate changed Sheet | Windows F9 | Source |
| Recalculate all Workbook | Windows CtrlShiftF9 | Source |
| Percentage format Digit row | Windows CtrlShift5 | Source |
About LibreOffice Calc and its shortcuts
LibreOffice Calc is the free spreadsheet most Linux desktops ship with, and its keyboard deliberately stays close to what spreadsheet users already know, so habits carry over. Where it differs is around its own dialogs: the function wizard, the navigator and the sheet management commands follow LibreOffice conventions rather than anyone else's.
LibreOffice lets you load an alternative key set aimed at people arriving from other spreadsheets, so an installation can behave differently from the defaults. Commands also differ slightly between the Windows and Mac builds.
Where the LibreOffice Calc keys came from
Read from 2 documentation pages published by the makers of LibreOffice Calc. Report a key that is wrong
To see how one action is done in other apps as well as LibreOffice Calc, browse the shortcuts by task. Shortcuts by task