General Shortcuts
| Action | Shortcut Key |
|---|
| New File | Ctrl + N |
| Open File | Ctrl + O |
| Save File | Ctrl + S |
| Print | Ctrl + P |
| Undo | Ctrl + Z |
| Redo | Ctrl + Y |
| Cut | Ctrl + X |
| Copy | Ctrl + C |
| Paste | Ctrl + V |
| Select All | Ctrl + A |
| Find | Ctrl + F |
| Find & Replace | Ctrl + H |
| Insert Function | Shift + F2 |
| Spell Check | F7 |
Navigation Shortcuts
| Action | Shortcut Key |
|---|
| Move to the Next Cell (Right) | Tab |
| Move to the Previous Cell (Left) | Shift + Tab |
| Move to the Next Row (Down) | Arrow Down |
| Move to the Previous Row (Up) | Arrow Up |
| Go to the First Cell (A1) | Ctrl + Home |
| Go to the Last Cell | Ctrl + End |
| Go to the Next Sheet | Ctrl + Page Down |
| Go to the Previous Sheet | Ctrl + Page Up |
Editing Shortcuts
| Action | Shortcut Key |
|---|
| Insert Row | Ctrl + Shift + + |
| Delete Row | Ctrl + - |
| Insert Column | Ctrl + Shift + = |
| Delete Column | Ctrl + Shift + - |
| Add a New Sheet | Shift + F11 |
| Insert Hyperlink | Ctrl + K |
| Open Cell Format Dialog | Ctrl + 1 |
Formatting Shortcuts
| Action | Shortcut Key |
|---|
| Bold | Ctrl + B |
| Italic | Ctrl + I |
| Underline | Ctrl + U |
| Align Left | Ctrl + L |
| Align Center | Ctrl + E |
| Align Right | Ctrl + R |
| Increase Font Size | Ctrl + Shift + > |
| Decrease Font Size | Ctrl + Shift + < |
| Format as Currency | Ctrl + Shift + $ |
| Format as Percentage | Ctrl + Shift + % |
Cell Formatting Shortcuts
| Action | Shortcut Key |
|---|
| Format as Date | Ctrl + Shift + # |
| Format as Number | Ctrl + Shift + ! |
| Format as Text | Ctrl + Shift + @ |
| Merge Cells | Ctrl + M |
| Wrap Text in Cell | Alt + Enter |
Data Shortcuts
| Action | Shortcut Key |
|---|
| AutoSum | Alt + Shift + = |
| Sort Ascending | Alt + A + S |
| Sort Descending | Alt + A + O |
| Open Filter Menu | Ctrl + Shift + L |
| Toggle Auto Filter | Ctrl + Shift + L |
These shortcuts will help improve your efficiency while using LibreOffice Calc.
Leave a Reply