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 (Mac)

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

+ 9 more controls in the table below

52 shortcuts

Editing 12

Action Shortcut
Copy ⌘C
Paste ⌘V
Undo ⌘Z
Cut ⌘X
Edit Cell F2
Paste Special ⌘⇧V
Redo ⌘⇧Z
Delete Cell Contents (No Dialog) ⌦
Insert Manual Line Break in Cell ⌃↵
Delete Cell Contents (With Dialog) ⌫
Delete Cells ⌘−
Insert Cells ⌘+

Navigation 10

Action Shortcut
Jump to Edge of Data Block ⌘→
Go to Cell A1 ⌘↖
Go to Last Cell with Data ⌘↘
Go to Start of Row ↖
Go to Last Column with Data in Row ↘
Next Sheet ⌘⇟
Previous Sheet ⌘⇞
Scroll One Screen Left/Right ⌥⇞
Move to Input Line ⌘⇧F2
Move to Name Box ⌘⇧F5

Formulas 8

Action Shortcut
Cycle Relative/Absolute References ⇧F4
Create Array (Matrix) Formula ⌘⇧↵
Fill Range with Formula from Input Line ⌥↵
Show/Hide Formulas ⌘`
Function Wizard ⌘F2
Recalculate Current Sheet F9
Recalculate All Formulas ⌘⇧F9
Define Names ⌘F3

Formatting 7

Action Shortcut
Format Cells ⌘1
Bold ⌘B
Italic ⌘I
Underline ⌘U
Clear Direct Formatting ⌘M
Open Styles Window F11
Optimize Column Width / Row Height ⌥⇧→

Selection 6

Action Shortcut
Select to Edge of Data Block ⌘⇧→
Select Current Row ⇧␣
Select Current Column ⌃␣
Select All Cells ⌘A
Select Data Block Around Cursor ⌘8
Toggle Additional Selection Mode F8

Tools 5

Action Shortcut
Find ⌘F
Find & Replace ⌘⌥F
Toggle Navigator F5
Check Spelling F7
Thesaurus ⌘F7

File 4

Action Shortcut
Save Document ⌘S
New Document ⌘N
Open Document ⌘O
Print ⌘P

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

Mac edition · 52 shortcuts

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

Edition

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 macOS — 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 macOS 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