ShortcutPosters
Promote Request an app

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.

Official:Official site

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 CtrlRIGHT
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 AltShiftRIGHT

Selection 6

Action Shortcut
Select to Edge of Data Block CtrlShiftRIGHT
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

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

Layout
LIBREOFFICE CALCKEYBOARD SHORTCUTS · WINDOWS · 43 ESSENTIAL1CtrlFormat Cel…2345678CtrlSelect Dat…90QWERTYCtrlRedoUCtrlUnderlineICtrlItalicOCtrlOpen Doc…PCtrlPrintACtrlSelect All…SCtrlSave Docu…DFCtrlFindGHCtrlFind & Rep…JKLZCtrlUndoXCtrlCutCCtrlCopyVCtrlPasteBCtrlBoldNCtrlNew Docu…MCtrlClear Direc…MORE SHORTCUTSEdit CellF2Jump to Edge of…CtrlRIGHTSelect to Edge o…CtrlShiftRIGHTPaste SpecialCtrlShiftVDelete Cell Cont…DelGo to Cell A1CtrlHomeGo to Last Cell w…CtrlEndSelect Current R…ShiftSpaceSelect Current C…CtrlSpaceCycle Relative/A…ShiftF4Insert Manual Li…CtrlEnterGo to Start of RowHomeGo to Last Colu…EndNext SheetCtrlPgDnPrevious SheetCtrlPgUpCreate Array (M…CtrlShiftEnterDelete Cell Cont…BkspDelete CellsCtrl−Insert CellsCtrl+Open Styles Win…F11Fill Range with F…AltEnterShow/Hide Form…Ctrl`Function WizardCtrlF2Recalculate Curr…F9Recalculate All F…CtrlShiftF9shortcutposters.comUPDATED JAN 2026 · COMPATIBLE WITH LIBREOFFICE CALC · WINDOWS
FILESave DocumentCtrlSNew DocumentCtrlNOpen DocumentCtrlOPrintCtrlPSELECTIONSelect to Edge of Data BlockCtrlShiftRIGHTSelect Current RowShiftSpaceSelect Current ColumnCtrlSpaceSelect All CellsCtrlASelect Data Block Around CursorCtrl8Toggle Additional Selection ModeF8TOOLSFindCtrlFFind & ReplaceCtrlHToggle NavigatorF5Check SpellingF7ThesaurusCtrlF7NAVIGATIONJump to Edge of Data BlockCtrlRIGHTGo to Cell A1CtrlHomeGo to Last Cell with DataCtrlEndGo to Start of RowHomeGo to Last Column with Data in Ro…EndNext SheetCtrlPgDnPrevious SheetCtrlPgUpScroll One Screen Left/RightAltPgUpMove to Input LineCtrlShiftF2Move to Name BoxCtrlShiftF5FORMATTINGFormat CellsCtrl1BoldCtrlBItalicCtrlIUnderlineCtrlUClear Direct FormattingCtrlMOpen Styles WindowF11Optimize Column Width / Row Hei…AltShiftRIGHTEDITINGCopyCtrlCPasteCtrlVUndoCtrlZCutCtrlXEdit CellF2Paste SpecialCtrlShiftVRedoCtrlYDelete Cell Contents (No Dialog)DelInsert Manual Line Break in CellCtrlEnterDelete Cell Contents (With Dialog)BkspDelete CellsCtrl−Insert CellsCtrl+FORMULASCycle Relative/Absolute Referenc…ShiftF4Create Array (Matrix) FormulaCtrlShiftEnterFill Range with Formula from Input…AltEnterShow/Hide FormulasCtrl`Function WizardCtrlF2Recalculate Current SheetF9Recalculate All FormulasCtrlShiftF9Define NamesCtrlF3LibreOffice CalcKEYBOARD SHORTCUTS · WINDOWS · 52BOTH LAYOUTSQWERTYQWERTYAZERTYAZERTYshortcutposters.comUPDATED JAN 2026 · COMPATIBLE WITH LIBREOFFICE CALC · WINDOWS
FILE04Save DocumentCtrlSNew DocumentCtrlNOpen DocumentCtrlOPrintCtrlPSELECTION06Select to Edge of Data Blo…CtrlShiftRIGHTSelect Current RowShiftSpaceSelect Current ColumnCtrlSpaceSelect All CellsCtrlASelect Data Block Around C…Ctrl8Toggle Additional Selectio…F8TOOLS05FindCtrlFFind & ReplaceCtrlHToggle NavigatorF5Check SpellingF7ThesaurusCtrlF7NAVIGATION10Jump to Edge of Data BlockCtrlRIGHTGo to Cell A1CtrlHomeGo to Last Cell with DataCtrlEndGo to Start of RowHomeGo to Last Column with Dat…EndNext SheetCtrlPgDnPrevious SheetCtrlPgUpScroll One Screen Left/Rig…AltPgUpMove to Input LineCtrlShiftF2Move to Name BoxCtrlShiftF5FORMATTING07Format CellsCtrl1BoldCtrlBItalicCtrlIUnderlineCtrlUClear Direct FormattingCtrlMOpen Styles WindowF11Optimize Column Width / Ro…AltShiftRIGHTEDITING12CopyCtrlCPasteCtrlVUndoCtrlZCutCtrlXEdit CellF2Paste SpecialCtrlShiftVRedoCtrlYDelete Cell ContentsDelInsert Manual Line Break i…CtrlEnterDelete Cell ContentsBkspDelete CellsCtrl−Insert CellsCtrl+FORMULAS08Cycle Relative/Absolute Re…ShiftF4Create Array (Matrix) Form…CtrlShiftEnterFill Range with Formula fr…AltEnterShow/Hide FormulasCtrl`Function WizardCtrlF2Recalculate Current SheetF9Recalculate All FormulasCtrlShiftF9Define NamesCtrlF3LibreOffice CalcKEYBOARD SHORTCUTS · WINDOWS · 52BOTH LAYOUTSQWERTYQWERTYAZERTYAZERTYshortcutposters.comUPDATED JAN 2026 · COMPATIBLE WITH LIBREOFFICE CALC · WINDOWS
LIBREOFFICE CALC · KEYBOARD SHORTCUTSWindows · 7 SETS · No.01LIBREOFFICE CALCTOTAL52SHORTCUTSFOR WINDOWS · SHIPPED COMBOSSETSEDITING12FILE04NAVIGATION10SELECTION06FORMATTING07FORMULAS08TOOLS05REF. EDITION · JAN 2026shortcutposters.comCopyCtrlCPasteCtrlVUndoCtrlZCutCtrlXEdit CellF2Paste SpecialCtrlShiftVRedoCtrlYDelete Cell Contents (No Dialog)DelInsert Manual Line Break in CellCtrlEnterDelete Cell Contents (With Dialog)BkspDelete CellsCtrl−Insert CellsCtrl+Save DocumentCtrlSNew DocumentCtrlNOpen DocumentCtrlOPrintCtrlPJump to Edge of Data BlockCtrlRIGHTGo to Cell A1CtrlHomeGo to Last Cell with DataCtrlEndGo to Start of RowHomeGo to Last Column with Data in RowEndNext SheetCtrlPgDnPrevious SheetCtrlPgUpScroll One Screen Left/RightAltPgUpMove to Input LineCtrlShiftF2Move to Name BoxCtrlShiftF5Select to Edge of Data BlockCtrlShiftRIGHTSelect Current RowShiftSpaceSelect Current ColumnCtrlSpaceSelect All CellsCtrlASelect Data Block Around CursorCtrl8Toggle Additional Selection ModeF8Format CellsCtrl1BoldCtrlBItalicCtrlIUnderlineCtrlUClear Direct FormattingCtrlMOpen Styles WindowF11Optimize Column Width / Row HeightAltShiftRIGHTCycle Relative/Absolute ReferencesShiftF4Create Array (Matrix) FormulaCtrlShiftEnterFill Range with Formula from Input LineAltEnterShow/Hide FormulasCtrl`Function WizardCtrlF2Recalculate Current SheetF9Recalculate All FormulasCtrlShiftF9Define NamesCtrlF3FindCtrlFFind & ReplaceCtrlHToggle NavigatorF5Check SpellingF7ThesaurusCtrlF7

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
Get your app featuredHow it works