ShortcutPosters
iPhone appNew

LibreOffice Calc Keyboard shortcuts

Get the poster

LibreOffice Calc is the free, open-source spreadsheet in the LibreOffice suite for calculations, charts, and data analysis. Its keyboard shortcuts speed up cell navigation, formatting, and formula entry, making large spreadsheets much easier to handle.

All LibreOffice Calc keyboard shortcuts (Windows)

Layout
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
⌫ Back
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Enter ⏎
Shift
Z
X
C
V
B
N
M
,
.
/
Shift
Ctrl
Win
Alt
Space
Alt
Win
Menu
Ctrl
↑
←
↓
→

+ 9 more controls in the table below

52 shortcuts

Editing 12

Action Shortcut
Copy CtrlC
Paste CtrlV
Undo CtrlZ
Cut CtrlX
Edit Cell F2
Paste Special CtrlShiftV
Redo CtrlY
Delete Cell Contents (No Dialog) Del
Insert Manual Line Break in Cell CtrlEnter
Delete Cell Contents (With Dialog) Bksp
Delete Cells Ctrl−
Insert Cells Ctrl+

Navigation 10

Action Shortcut
Jump to Edge of Data Block Ctrl→
Go to Cell A1 CtrlHome
Go to Last Cell with Data CtrlEnd
Go to Start of Row Home
Go to Last Column with Data in Row End
Next Sheet CtrlPgDn
Previous Sheet CtrlPgUp
Scroll One Screen Left/Right AltPgUp
Move to Input Line CtrlShiftF2
Move to Name Box CtrlShiftF5

Formulas 8

Action Shortcut
Cycle Relative/Absolute References ShiftF4
Create Array (Matrix) Formula CtrlShiftEnter
Fill Range with Formula from Input Line AltEnter
Show/Hide Formulas Ctrl`
Function Wizard CtrlF2
Recalculate Current Sheet F9
Recalculate All Formulas CtrlShiftF9
Define Names CtrlF3

Formatting 7

Action Shortcut
Format Cells Ctrl1
Bold CtrlB
Italic CtrlI
Underline CtrlU
Clear Direct Formatting CtrlM
Open Styles Window F11
Optimize Column Width / Row Height AltShift→

Selection 6

Action Shortcut
Select to Edge of Data Block CtrlShift→
Select Current Row ShiftSpace
Select Current Column CtrlSpace
Select All Cells CtrlA
Select Data Block Around Cursor Ctrl8
Toggle Additional Selection Mode F8

Tools 5

Action Shortcut
Find CtrlF
Find & Replace CtrlH
Toggle Navigator F5
Check Spelling F7
Thesaurus CtrlF7

File 4

Action Shortcut
Save Document CtrlS
New Document CtrlN
Open Document CtrlO
Print CtrlP

Sourced from help.libreoffice.org Last verified

Unofficial reference. ShortcutPosters is not affiliated with, endorsed by, or sponsored by LibreOffice Calc. All product names, logos, and trademarks are property of their respective owners. See our licensing & trademark notice.

Get the LibreOffice Calc poster

5 art directions — pick one below, click to zoom & compare.

LibreOffice Calc block shortcuts poster preview
LibreOffice Calc aurora shortcuts poster preview
LibreOffice Calc studio shortcuts poster preview
LibreOffice Calc blueprint shortcuts poster preview
LibreOffice Calc riso shortcuts poster preview

Windows edition · 52 shortcuts

A printable, framed-quality poster of the essential LibreOffice Calc shortcuts for Windows — the keys worth keeping in view, designed to stay readable on a wall.

Edition
Apple Mac Windows Windows

Free PNG is web-resolution & watermarked.

Customise this poster Pick the shortcuts, restyle the colours — download free. Get the framed-quality print Full 300 DPI, print-ready — at home or shipped to your door.

Frequently asked questions

Does the poster include every LibreOffice Calc shortcut?
LibreOffice Calc has 52 keyboard shortcuts on Windows — the complete list is free to read on this page. The poster features the most essential ones, curated to stay readable on a wall.
Can I print it at home?
Yes. The digital download is a high-resolution 300 DPI file you can print at home or at any print shop, in standard frame sizes.
Does it cover both Mac and Windows?
We sell a separate edition per platform so every key matches your keyboard exactly. This page is the Windows edition.
Is this an official LibreOffice Calc product?
No. This is an unofficial reference poster and is not affiliated with or endorsed by LibreOffice Calc. All trademarks belong to their respective owners.

Promote your app

Built an app with great keyboard shortcuts? Get it into the database — a free, searchable reference page, and an optional printable poster your power users will pin to the wall.

  • Free shortcut reference page
  • Indexed & searchable
  • Optional framed poster