Skip to the main content
Shortivo

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.

Every system Mac Windows
Everything Blocks and structure Clipboard Comments and review Editing Files and printing Formulas and data Navigation Paragraphs and lists Search Selection Text formatting
Matching shortcuts
Action Keys Row actions
Edit the current cell Worksheet Windows F2 Source
Build a formula with guidance Function Wizard Windows CtrlF2 Source
Break a line inside a cell While editing cell text Windows CtrlEnter Source
Choose which cell contents to erase Delete Contents dialog Windows Backspace Source
Jump to cell A1 Worksheet Windows CtrlHome Source
Jump to the last used cell Worksheet Windows CtrlEnd Source
Move to the following sheet Worksheet, not print preview Windows CtrlPage Down Source
Move to the preceding sheet Worksheet, not print preview Windows CtrlPage Up Source
Define a named range Define Names dialog Windows CtrlF3 Source
Toggle the navigation panel Navigator Windows F5 Source
Row start Navigation Windows Home Source
Row data end Navigation Windows End Source
Block edge left Data navigation Windows CtrlLeft arrow Source
Block edge right Data navigation Windows CtrlRight arrow Source
Block edge up Data navigation Windows CtrlUp arrow Source
Block edge down Data navigation Windows CtrlDown arrow Source
Screen left Worksheet Windows AltPage Up Source
Screen right Worksheet Windows AltPage Down Source
Input line Worksheet Windows CtrlShiftF2 Source
Name box From input line Windows CtrlShiftF5 Source
Select row Selection Windows ShiftSpace Source
Select column Selection Windows CtrlSpace Source
Select sheet Selection Windows CtrlShiftSpace Source
Delete cells Selection Windows Ctrl- Source
Show comment Commented cell Windows CtrlF1 Source
Trace dependents Formula cell Windows ShiftF5 Source
Trace precedents Formula cell Windows ShiftF9 Source
Styles panel Worksheet Windows F11 Source
Reference locking Formula editing Windows F4 Source
Spellcheck Sheet Windows F7 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