LibreOffice Calc is a great free alternative to Microsoft Excel. Below is the Keyboard Shortcuts for LibreOffice Calc
Basic Shortcuts
| Action | Shortcut |
|---|
| New spreadsheet | Ctrl + N |
| Open spreadsheet | Ctrl + O |
| Save | Ctrl + S |
| Print | Ctrl + P |
| Cut | Ctrl + X |
| Copy | Ctrl + C |
| Paste | Ctrl + V |
| Undo | Ctrl + Z |
| Redo | Ctrl + Y |
| Find | Ctrl + F |
| Find & Replace | Ctrl + H |
| Select all | Ctrl + A |
Navigation
| Action | Shortcut |
|---|
| Move one cell up/down/left/right | Arrow keys |
| Move to beginning of row | Home |
| Move to beginning of sheet | Ctrl + Home |
| Move to end of sheet | Ctrl + End |
| Move to next sheet | Ctrl + Page Down |
| Move to previous sheet | Ctrl + Page Up |
Editing
| Action | Shortcut |
|---|
| Edit active cell | F2 |
| Fill down | Ctrl + D |
| Fill right | Ctrl + R |
| Insert current date | Ctrl + ; |
| Insert current time | Ctrl + Shift + ; |
| Delete cell contents | Delete |
| Add comment | Ctrl + Alt + C |
Formatting
| Action | Shortcut |
|---|
| Bold | Ctrl + B |
| Italic | Ctrl + I |
| Underline | Ctrl + U |
| Center align | Ctrl + E |
| Left align | Ctrl + L |
| Right align | Ctrl + R |
| Format cells dialog | Ctrl + 1 |
| Currency format | Ctrl + Shift + 4 |
| Percentage format | Ctrl + Shift + 5 |
| Scientific format | Ctrl + Shift + 6 |
Row/Column Operations
| Action | Shortcut |
|---|
| Insert row | Ctrl + + (on numpad) |
| Delete row | Ctrl + - (on numpad) |
| Select entire row | Shift + Space |
| Select entire column | Ctrl + Space |
I hope these shortcuts make you more efferent at using LibreOffice Calc.
