LibreOffice Calc is a free, open-source spreadsheet program for Linux, Windows, and MacOS. Like Microsoft Excel, LibreOffice Calc provides a simple yet powerful interface that you can use to record and manipulate data tables. LibreOffice Calc can also produce complex tables and analyze them through its extensive built-in wizards.
Download this Cheatsheet
Enter your email below to receive this PDF cheatsheet in your Inbox.
Essential LibreOffice Calc Keybindings
While creating new bindings for existing functions is possible, the default set of keybindings in LibreOffice Calc can already demonstrate its extensive features. For example, the spreadsheet editor has a bunch of keybindings for reference tracing, formula recalculation, setting custom colors, and formatting.
This cheatsheet provides an extensive list of default keybindings you can use with LibreOffice Calc. Furthermore, this list highlights some of the program’s lesser-known complex functions so you can become a spreadsheet wizard.
| Windows/Linux | macOS | Function |
|---|---|---|
| File Manipulation | ||
| Ctrl + N | Command + N | Create a new Calc spreadsheet. |
| Ctrl + O | Command + O | Open an existing Calc spreadsheet. |
| Ctrl + S | Command + S | Save the current Calc spreadsheet. |
| Ctrl + Shift + S | Command + Shift + S | Save the current Calc spreadsheet in a different format. |
| Ctrl + F4 | Command + F4 | Close the current Calc spreadsheet. |
| F6 | F6 | Switch focus on the next internal window. |
| Shift + F6 | Shift + F6 | Switch focus on the previous internal window. |
| Ctrl + P | Command + P | Open the Print dialog menu. |
| Interface Manipulation | ||
| Ctrl + Shift + J | Command + Shift + J | Switch between fullscreen and windowed mode. |
| Ctrl + Shift + R | Command + Shift + R | Render the current spreadsheet again. |
| Ctrl + Shift + I | Command + Shift + I | Toggle the cursor in Read Only spreadsheets. |
| F5 | F5 | Toggle the spreadsheet navigator subwindow. |
| F10 | F10 | Open the first item in the Menu Bar. |
| Shift + F10 | Shift + F10 | Open the Context Menu. |
| Ctrl + Shift + F10 | Command + Shift + F10 | Toggle the dock status of the current subwindows. |
| F11 | F11 | Open the “Styles” dialog box. |
| Ctrl + Q | Command + Q | Exit the Calc program. |
| Help Menu | ||
| F1 | F1 | Open the Built-in Libreoffice Help System. |
| Shift + F1 | Shift + F1 | Open the Help System entry for the current mode. |
| Shift + F2 | Shift + F2 | Reopen the Tips menu. |
| Spreadsheet Navigation | ||
| Left Arrow | Left Arrow | Move the selection cursor to the cell on the left. |
| Right Arrow | Right Arrow | Move the selection cursor to the cell on the right. |
| Up Arrow | Up Arrow | Move the selection cursor one cell up. |
| Down Arrow | Down Arrow | Move the selection cursor one cell down. |
| Ctrl + Left Arrow | Command + Left Arrow | Move the selection cursor to the first cell on the left with data. |
| Ctrl + Right Arrow | Command + Right Arrow | Move the selection cursor to the first cell on the right with data. |
| Ctrl + Up Arrow | Command + Up Arrow | Move the selection cursor to the first cell with data upwards. |
| Ctrl + Down Arrow | Command + Down Arrow | Move the selection cursor to the first cell with data downwards. |
| Ctrl + Page Up | Move to the previous spreadsheet in the file. | |
| Ctrl + Page Down | Move to the next spreadsheet in the file. | |
| Alt + Page Up | Move the spreadsheet viewer to the left by one screen. | |
| Alt + Page Down | Move the spreadsheet viewer to the right by one screen. | |
| Ctrl + F | Command + F | Search for a string in the current spreadsheet. |
| Ctrl + Shift + F | Command + Shift + F | Search for the last string that you searched for in the current spreadsheet. |
| Ctrl + H | Command + H | Open the “Find and Replace” dialog box. |
| Spreadsheet Selection | ||
| Shift + Space | Shift + Space | Select the entire current row. |
| Ctrl + Space | Command + Space | Select the entire current column. |
| Ctrl + Shift + Space | Command + Shift + Space | Select the entire spreadsheet. |
| Shift + Home | Select the current cell up until the first cell in the current row. | |
| Shift + End | Select the current cell up until the last cell with data in the current row. | |
| Shift + Page Up | Select the current cell and one screen up in the current column. | |
| Shift + Page Down | Select the current cell and one screen down in the current column. | |
| Ctrl + Shift + Page Up | Select the previous spreadsheet in the file along with the current one. | |
| Ctrl + Shift + Page Down | Select the next spreadsheet in the file along with the current one. | |
| Spreadsheet Editing | ||
| Ctrl + C | Command + C | Copy the contents of the currently selected cell. |
| Ctrl + X | Command + X | Copy the contents of the currently selected cell and delete it. |
| Enter | Enter | Paste the contents of the clipboard at the currently selected cell. |
| Backspace | Backspace | Open the “Delete Contents” dialog box. |
| Delete | Delete | Delete the contents of the currently selected cell. |
| Ctrl + Plus (+) | Command + Plus (+) | Insert a new cell at the current cursor position. |
| Ctrl + Minus (-) | Command + Minus (-) | Delete the currently selected cell. |
| Ctrl + Back Quote (`) | Command + Back Quote (`) | Toggle the formula display for each cell in the current spreadsheet. |
| Ctrl + Z | Command + Z | Undo the last change that you made. |
| Ctrl + Y | Command + Y | Redo the last change that you made. |
| Ctrl + Alt + Y | Command + Option + Y | Redo the last calc command that you made. |
| Ctrl + Semicolon (;) | Command + Semicolon (;) | Insert the current date in currently selected cell. |
| Ctrl + Shift + Semicolon (;) | Command + Shift + Semicolon (;) | Insert the current time in the currently selected cell. |
| Spreadsheet Formatting | ||
| Ctrl + 1 | Command + 1 | Open the “Format Cells” dialog box. |
| Ctrl + Shift + 1 | Command + Shift + 1 | Format the current cell up to two decimal places. |
| Ctrl + Shift + 2 | Command + Shift + 2 | Format the current cell in scientific notation. |
| Ctrl + Shift + 3 | Command + Shift + 3 | Format the current cell to the standard date format. |
| Ctrl + Shift + 4 | Command + Shift + 4 | Format the current cell to the standard currency format. |
| Ctrl + Shift + 5 | Command + Shift + 5 | Format the current cell in percentage format with up to two decimal places. |
| Ctrl + Shift + 6 | Command + Shift + 6 | Format the current cell using the default style. |
| Cell Formatting | ||
| Ctrl + B | Command + B | Format the current cell in bold. |
| Ctrl + I | Command + I | Format the current cell in italics. |
| Ctrl + U | Command + U | Underline the text in the current cell. |
| Ctrl + M | Command + M | Remove any formatting in the current cell. |
| Ctrl + L | Command + L | Force the contents of the current cell to be left justified. |
| Ctrl + R | Command + R | Force the contents of the current cell to be right justified. |
| Ctrl + E | Command + E | Center the contents of the current cell. |
| Ctrl + J | Command + J | Justify the contents of the current cell. |
| Shift + F3 | Shift + F3 | Toggle the different letter cases for the current cell. |
| Pivot Table | ||
| Tab | Tab | Go through the different fields in the Pivot Table dialog box. |
| Shift + Tab | Shift + Tab | Go through the different fields in the dialog box in reverse. |
| Up Arrow | Up Arrow | Move the selection cursor one line up in the current field. |
| Down Arrow | Down Arrow | Move the selection cursor one line down in the current field. |
| Left Arrow | Left Arrow | Move the selected data point to an adjacent field on the left. |
| Right Arrow | Right Arrow | Move the selected data point to an adjacent field on the right. |
| Home | Move the selection cursor to the top of the current field. | |
| End | Move the selection cursor to the bottom of the current field. | |
| Delete | Delete | Delete the selected data point in the current field. |
Image Credit: Unsplash and Wikimedia Commons. All alterations by Ramces Red.
