Libre Office Calc Important Shortcuts for Beginner to Expert
Calc is the LibreOffice spreadsheet module. A spreadsheet allows you to enter and manipulate data, most of which is numerical, to get specific results.
Try the Libre Office Calc Important Shortcuts for get Practice and best performance in Libre Calc in following Exams, E.g. NIELIT’s Recommended O Level and CCC Courses.
| Shortcut | Action |
|---|---|
| Home | Move cursor to first cell of the row |
| End | Move cursor to last cell of the row |
| Enter | Move cursor one cell down |
| F2 | Enter Edit mode |
| F4 | Rearrange references |
| F5 | Show/hide Navigator |
| F7 | Check spelling |
| F8 | Enable/disable additional selection mode |
| F9 | Recalculate formulas in current sheet |
| F11 | Open Styles |
| F12 | Group the selected data range |
| Ctrl + * (Astrik) | Selects data range contained by the cursor |
| Ctrl + / (Slash) | Selects matrix formula contained by the cursor |
| Ctrl + Plus Button | Insert cells |
| Ctrl + Minus Button | Delete cells |
| Ctrl + ` (backtick) | Display/hide formulas |
| Ctrl + 1 | Open Format cells |
| Ctrl + F1 | Show comment |
| Ctrl + F2 | Open Function wizard |
| Ctrl + F3 | Open Define names |
| Ctrl + F7 | Opens Thesaurus |
| Ctrl + F8 | Highlight cells containing values |
| Ctrl + F9 | Update chart |
| Ctrl + F12 | UN-Group the selected data range |
| Ctrl + Home | Move cursor to A1 |
| Ctrl + End | Move cursor to last cell with data inside |
| 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 + Page up | Move sheet right |
| Ctrl + Page down | Move sheet right |
| 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 |
| Shortcut | Action |
|---|---|
| Ctrl + Shift + Arrow | Select all cells containing data |
| Ctrl + Shift + F9 | Recalculate formulas in all sheets |
| 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 |
| Shift + F11 | Create a document template |
| Shift + F5 | Traces dependents |
| Shift + F7 | Traces precedents |
| Shift + Ctrl + F2 | Move cursor to input line |
| Shift + Ctrl + F4 | Show/hide Database explorer |
| Shift + Ctrl + F5 | Moves cursor to Sheet area |
| Shift + Ctrl + F11 | Update the template |
| Shift + Ctrl + Page up | Adds previous sheet to current sheet |
| Shift + Ctrl + Page down | Adds next sheet to current sheet |
| 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 |
