If you're after a free alternative to Microsoft Excel, look no further than LibreOffice Calc. It has all the professional features that you would expect in spreadsheet software.
You can integrate real-time data streams, have multiple users working on the same sheet, and even open spreadsheets saved in Excel's file format—perfect when working with people who don't use LibreOffice Calc.
To truly become a spreadsheet wizard, it's vital that you master all the keyboard shortcuts at your fingertips. This means you can navigate, format, and input data with ease, speeding up your workflow and getting the job done faster. That's why we've put together this list of LibreOffice Calc keyboard shortcuts.
FREE DOWNLOAD: This cheat sheet is available as a downloadable PDF from our distribution partner, TradePub. You will have to complete a short form to access it for the first time only. Download the LibreOffice Calc Keyboard Shortcuts Cheat Sheet.
LibreOffice Calc Keyboard Shortcuts
| SHORTCUT | ACTION |
|---|---|
| Navigation | |
| Ctrl + Home | Move cursor to A1 |
| Ctrl + End | Move cursor to last cell with data inside |
| Home | Move cursor to first cell of the row |
| End | Move cursor to last cell of the row |
| Shift + Home | Select from current cell to first cell of the row |
| Shift + End | Select from current cell to last cell of the row |
| Shift + Page up | Select from the current cell up a page |
| Shift + Page down | Select from the current cell down a page |
| Ctrl + Left arrow | Move cursor left of the current data range |
| Ctrl + Right arrow | Move cursor right of the current data range |
| Ctrl + Up arrow | Move cursor to the top of the current data range |
| Ctrl + Down arrow | Move cursor to the bottom of the current data range |
| Ctrl + Shift + Arrow | Select all cells containing data, in the direct of the arrow |
| Ctrl + Page up | Move sheet right |
| Ctrl + Page down | Move sheet right |
| Alt + Page up | Move one screen left |
| Alt + Page down | Move one screen right |
| Alt + Down arrow | Increase current height row |
| Alt + Up arrow | Decrease current height row |
| Alt + Right arrow | Increase current column width |
| Alt + Left arrow | Decrease current column width |
| Alt + Shift + Arrow | Fits column width and row height based on current cell |
| Shift + Ctrl + Page up | Adds previous sheet to current sheet |
| Shift + Ctrl + Page down | Adds next sheet to current sheet |
| Ctrl + * | Selects data range contained by the cursor |
| Ctrl + / | Selects matrix formula contained by the cursor |
| Ctrl + Plus | Insert cells |
| Ctrl + Minus | Delete cells |
| Enter | Move cursor one cell down |
| Ctrl + ` | Display/hide formulas |
| Formatting | |
| Ctrl + 1 | Open Format cells |
| Ctrl + Shift + 1 | Two decimal places |
| Ctrl + Shift + 2 | Exponential format |
| Ctrl + Shift + 3 | Date format |
| Ctrl + Shift + 4 | Currency format |
| Ctrl + Shift + 5 | Percentage format |
| Ctrl + Shift + 6 | Standard format |
| Functions | |
| Ctrl + F1 | Show comment |
| F2 | Enter Edit mode |
| Ctrl + F2 | Open Function wizard |
| Shift + Ctrl + F2 | Move cursor to input line |
| Ctrl + F3 | Open Define names |
| Shift + Ctrl + F4 | Show/hide Database explorer |
| F4 | Rearrange references |
| F5 | Show/hide Navigator |
| Shift + F5 | Traces dependents |
| Shift + Ctrl + F5 | Moves cursor to Sheet area |
| F7 | Check spelling |
| Shift + F7 | Traces precedents |
| Ctrl + F7 | Opens Thesaurus |
| F8 | Enable/disable additional selection mode |
| Ctrl + F8 | Highlight cells containing values |
| F9 | Recalculate formulas in current sheet |
| Ctrl + F9 | Update chart |
| Ctrl + Shift + F9 | Recalculate formulas in all sheets |
| F11 | Open Styles |
| Shift + F11 | Create a document template |
| Shift + Ctrl + F11 | Update the template |
| F12 | Group the selected data range |
| Ctrl + F12 | Ungroup the selected data range |
LibreOffice Is an Excellent Office Suite
Use these LibreOffice Calc shortcuts and you'll be able to create and manage your spreadsheets with ease. These shortcuts are especially useful when you have huge spreadsheets, so you can focus on the data and formulas rather than fiddling in menus.
Don't forget that LibreOffice also offers many other office tools, including presentation software and a word processor. It's all free and open-source.
0 Comments