LibreOffice
Free open source office suite - word processor, spreadsheet, presentations, and more. Compatible with Microsoft Office formats.
Apps
| App | Description |
|---|---|
| Writer | Word processor - Microsoft Word alternative |
| Calc | Spreadsheet - Microsoft Excel alternative |
| Impress | Presentations - Microsoft PowerPoint alternative |
| Draw | Vector drawing and diagrams |
| Base | Database front-end - Microsoft Access alternative |
| Math | Formula and equation editor |
Calc
Shortcuts
| Action | Shortcut |
|---|---|
| Add row/column | Ctrl + |
| Delete row/column | Ctrl - |
| Move to next sheet | Ctrl PgDn |
| Move to previous sheet | Ctrl PgUp |
| Select to last used cell | Ctrl Shift End |
| Select all cells in direction | Ctrl Shift arrows |
| Insert current date | Ctrl ; |
| Insert current time | Ctrl Shift ; |
Writer
Shortcuts
| Action | Shortcut |
|---|---|
| Bold | Ctrl B |
| Italic | Ctrl I |
| Underline | Ctrl U |
| Find & Replace | Ctrl H |
| Insert page break | Ctrl Enter |
| Word count | Ctrl Shift G |
| Navigator | F5 |
Tips
Save as Microsoft Office format by default
Go to Tools → Options → Load/Save → General and set the default file format to .docx / .xlsx / .pptx to ensure compatibility when sharing files.
Enable macros
Go to Tools → Options → LibreOffice → Security → Macro Security and set to Medium to allow running macros with a prompt.