Cheat sheet guide
LibreOffice Calc shortcuts worth learning first
This page collects 32 searchable LibreOffice Calc keyboard shortcuts across 4 categories. Start with the shortcuts for File & Edit, Cells & Formulas, Navigation & Selection, Formatting, then print the cheat sheet once the important ones are worth keeping nearby.
- New spreadsheetCtrlN
- Edit cellF2
- Go to cell A1CtrlHome
- BoldCtrlB
- OpenCtrlO
- SaveCtrlS
File & Edit
10 shortcuts
New spreadsheet
CtrlN
WinCtrlNMac⌘NLinuxCtrlN
Open
CtrlO
WinCtrlOMac⌘OLinuxCtrlO
Save
CtrlS
WinCtrlSMac⌘SLinuxCtrlS
Print
CtrlP
WinCtrlPMac⌘PLinuxCtrlP
Undo
CtrlZ
WinCtrlZMac⌘ZLinuxCtrlZ
Redo
CtrlY
WinCtrlYMac⌘YLinuxCtrlY
Cut
CtrlX
WinCtrlXMac⌘XLinuxCtrlX
Copy
CtrlC
WinCtrlCMac⌘CLinuxCtrlC
Paste
CtrlV
WinCtrlVMac⌘VLinuxCtrlV
Paste special
CtrlShiftV
WinCtrlShiftVMac⌘⇧VLinuxCtrlShiftV
Cells & Formulas
8 shortcuts
Edit cell
F2
WinF2MacF2LinuxF2
Insert sum
Alt=
WinAlt=Mac⌥=LinuxAlt=
Confirm and stay
AltEnter
WinAltEnterMac⌥EnterLinuxAltEnter
Insert current date
Ctrl;
WinCtrl;Mac⌘;LinuxCtrl;
Insert current time
CtrlShift;
WinCtrlShift;Mac⌘⇧;LinuxCtrlShift;
Toggle absolute reference
ShiftF4
WinShiftF4Mac⇧F4LinuxShiftF4
Recalculate
F9
WinF9MacF9LinuxF9
Show formulas
Ctrl`
WinCtrl`Mac⌘`LinuxCtrl`
Navigation & Selection
8 shortcuts
Go to cell A1
CtrlHome
WinCtrlHomeMac⌘HomeLinuxCtrlHome
Go to last cell
CtrlEnd
WinCtrlEndMac⌘EndLinuxCtrlEnd
Jump to data edge
CtrlArrow
WinCtrlArrowMac⌘ArrowLinuxCtrlArrow
Select whole column
CtrlSpace
WinCtrlSpaceMac⌃SpaceLinuxCtrlSpace
Select whole row
ShiftSpace
WinShiftSpaceMac⇧SpaceLinuxShiftSpace
Select all
CtrlA
WinCtrlAMac⌘ALinuxCtrlA
Next sheet
CtrlPageDown
WinCtrlPageDownMac⌘PageDownLinuxCtrlPageDown
Previous sheet
CtrlPageUp
WinCtrlPageUpMac⌘PageUpLinuxCtrlPageUp
Formatting
6 shortcuts
Bold
CtrlB
WinCtrlBMac⌘BLinuxCtrlB
Italic
CtrlI
WinCtrlIMac⌘ILinuxCtrlI
Underline
CtrlU
WinCtrlUMac⌘ULinuxCtrlU
Format cells
Ctrl1
WinCtrl1Mac⌘1LinuxCtrl1
Find & Replace
CtrlH
WinCtrlHMac⌘⌥FLinuxCtrlH
Find
CtrlF
WinCtrlFMac⌘FLinuxCtrlF
Frequently asked questions
What is the fastest way to find LibreOffice Calc shortcuts on this page?
Use the search box or press /, then type an action such as new spreadsheet.
Can I print this LibreOffice Calc shortcut cheat sheet?
Yes. Use the Print / PDF button or your browser print command to save a compact cheat sheet.
Does this page include Windows and Mac shortcuts for LibreOffice Calc?
Yes. Use the OS tabs to switch between Windows and macOS shortcuts. For example, New spreadsheet is Ctrl+N on Windows and ⌘N on macOS where available.
