Learning LibreOffice: LibreOffice Calc Keyboard Shortcuts
Just over two months ago (April 2), we started a new series of posts about LibreOffice, the most well-known and widely used office suite in the Linuxverse. It's titled «Learning LibreOffice», and in this first one we have given it the objective of addressing and making known the topic of the «Keyboard shortcuts for each of the LibreOffice tools: Writer, Calc, Impress, Draw, Math, and Base..
Which, we have seen as very opportune and something very important in favor of our iconic LibreOffice office suite, above all, when it comes to being more effective and productive when we need to use for the preparation and management of our study and work spreadsheetsAnd above all, always thinking of those who don't yet know it or may be just starting to use it for study and work purposes.
Learning LibreOffice – Tutorial 1: Keyboard shortcuts for Writer
But, before starting to know each of the current ones «LibreOffice Calc Keyboard Shortcuts, we recommend you explore the Previous and first post of our previous series on this same office suite, at the end of it:
If you're one of those who doesn't yet know and use LibreOffice—because you most likely use MS Office or one of the few proprietary, closed, and paid/free alternatives for Windows—it's important for you to know a few things. For example, LibreOffice is visually similar to MS Office. It's also highly compatible with MS Office's proprietary formats, namely DOC, DOCX, XLS, XLSX, PPTS, PPTX, and other familiar formats from its other tools.
Learning LibreOffice: LibreOffice Calc Keyboard Shortcuts
Current LibreOffice Calc 25.2 Keyboard Shortcuts
Keyboard shortcuts are key combinations that allow you to perform specific actions in an operating system, application or program quickly, without having to use the mouse or navigate through menus. Their main purpose is to optimize productivity, reduce the time spent on repetitive tasks and facilitate access to frequently used functions.
Navigating a spreadsheet
Then These are the existing keyboard shortcuts to navigate through a spreadsheet., however, there are many more. For example, there are different ones for copying and changing sheet names, for performing actions or tasks with function keys in spreadsheets, for formatting cells using key combinations, and even for use in pivot tables. And you can see all of these in our downloadable format available on the LibreOffice Calc Keyboard Shortcuts: Download.
| KEYBOARD SHORTCUT | EFFECT |
|---|---|
| Ctrl + Home | Moves the cursor to the first cell on the sheet (A1). |
| Ctrl + End | Moves the cursor to the last cell that contains data. |
| Home | Moves the cursor to the first cell of the current row. |
| Lesson finish date | Moves the cursor to the last column containing data in any row. |
| Shift + Home | Select cells from the current to the first cell of the current row. |
| Shift + End | Selects all cells from the current cell to the last column containing data in any row. |
| Shift + Page Up | Select cells from current to one page above current column or extend current selection up one page. |
| Shift + Page Down | Select cells from the current one to one page below the current column or extend the current selection one page down. |
| Shift + Space | Selects the current row or extends the existing selection to all respective rows. |
| Ctrl + Space | Selects the current column or extends the existing selection to all respective columns. |
| Ctrl + Shift + Space | Select all cells in the sheet. |
| Ctrl + ← | Moves the cursor left at the beginning and end of blocks of cells with data. If the cell to the left of the cursor is empty or the cell with the cursor is empty, the cursor moves left in the current row until it reaches the next cell with content. If all cells in the same row to the left of the cursor are empty, the cursor moves to the first cell in the row. |
| Ctrl + → | Moves the cursor right to the beginning and end of blocks of cells with data. If the cell to the right of the cursor is empty or the cell with the cursor is empty, the cursor moves right in the current row until it reaches the next cell with content. If all cells in the same row to the right of the cursor are empty, the cursor moves to the last cell in the row. |
| Ctrl + ↑ | Moves the cursor up to the beginning and end of blocks of cells with data. If the cell above the cursor is empty or the cell with the cursor is empty, the cursor moves up in the current column to the next cell with content. If all cells in the same column above the cursor are empty, the cursor moves to the first cell in the column. |
| Ctrl + ↓ | Moves the cursor down to the beginning and end of blocks of cells with data. If the cell below the cursor is empty or the cell with the cursor is empty, the cursor moves down in the current column to the next cell with content. If all cells in the same column below the cursor are empty, the cursor moves to the last cell in the column. |
| Ctrl + Shift + arrow | Selects all cells in the range created by cursor movements when using the Ctrl + ↑, ↓, ←, or → key combinations. When used to select adjacent rows and columns, a rectangular range of cells is created. If the cursor is in an empty cell, the selection will extend from the current cell to the first cell with a value in the direction of the pressed arrow. |
| Ctrl + Page Up | Shift one sheet to the left.
In print preview: Moves to the previous page to print. |
| Ctrl + Page Down | Shift one sheet to the right.
In print preview: Moves to the next page to print. |
| Alt + Page Up | Scrolls one screen to the left. |
| Alt + Page Down | Scrolls one screen to the right. |
| Ctrl + Page Up | Adds the previous sheet to the current sheet selection. If all sheets in a workbook are selected, this key combination selects only the previous sheet. Makes the previous sheet the current sheet. |
| Ctrl + Page Down | Adds the next sheet to the current sheet selection. If all sheets in a workbook are selected, this key combination selects only the next sheet. Makes the next sheet the current sheet. |
| Ctrl + * | SEntering (*) the multiplication sign on the numeric keypad
SSelects the data area where the cursor is located. A data area contains a series of contiguous cells; it contains data and is bounded by empty rows and columns. |
| Ctrl + / | Susing (/) the division sign on the numeric keypad
SSelects the array formula range in which the cursor is located. |
| Ctrl + plus key | Insert cells (such as the Insert ▸ Cells menu) |
| Ctrl + subtraction key | Delete cells (like the Edit ▸ Delete Cells menu) |
| Intro (at a selected interval) | Moves the cursor down one cell in the selected range. To specify the direction the cursor moves, go to Tools ▸ Options ▸ LibreOffice Calc ▸ General and change the value for the Enter key moves selection down option. |
| Enter (after copying the cell contents) | If the cell contents have just been copied to the clipboard and no additional editing has been done in the current file, pressing Enter will paste the clipboard contents at the current cursor position. |
| Shift + Enter | If the clipboard contains cell content and no edits have been made to the file, pressing Shift+Enter will behave the same as Enter and will paste the clipboard contents at the current cursor position.
If no cell is selected, Shift + Enter moves the cursor in the opposite direction defined in the Press Enter to move selection option found in Tools ▸ Options ▸ LibreOffice Calc ▸ General. While selecting a range of cells, Shift+Enter moves the cursor within the current selection in the opposite direction defined in the Press Enter to move selection option. |
| Ctrl+ | ` (the key above Tab, see the note below this table) | Show or hide the formula instead of the value in all cells. |
Finally, and in case you want to know more about the current and future «LibreOffice Calc Keyboard Shortcuts Remember that you can either locally from your “LibreOffice Calc” go to the top menu bar and explore the path “Tools / Customize / Keyboard”; or online (via the Internet) to go to the official LibreOffice help web section just click on the following link to go directly to the documentation on this topic.
LibreOffice Calc is a feature-rich tool for manipulating data (preferably numerical) in a spreadsheet, producing specific results in both text and graphics. It also has the ability to automate actions, so you only need to change the value of certain data to obtain different results. This, in turn, allows the use of functions and formulas that improve and optimize the performance of complex calculations on data. Additionally, it includes database functions, which facilitate the ability to organize, store, and filter data; dynamic chart functions in 2D and 3D formats; and macro functions, which are often very useful for recording and executing repetitive tasks.
Summary
In short, we hope that this second tutorial in this series dedicated to learning more about «LibreOffice and its keyboard shortcuts» you like it and it is useful, both informatively and practically, to be able to Create and manage your study or work files better and faster about such a popular office suite. And especially on this occasion about LibreOffice Calc, which is the office tool whose functions allow us to generate and modify all types of information on frequently used spreadsheets (numbers, values, graphs, tables).
Lastly, remember visit our «homepage» in Spanish. Or, in any other language (just by adding 2 letters to the end of our current URL, for example: ar, de, en, fr, ja, pt and ru, among many others) to find out more current content. Additionally, we invite you to join our Official Telegram channel to read and share more news, guides and tutorials from our website.