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)
+ 9 more controls in the table below
+ 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 |
| 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.
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.
Free PNG is web-resolution & watermarked.
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.
Thanks — your feedback helps us improve.
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