LibreOffice Calc keyboard shortcuts and OpenOffice Calc keyboard shortcuts are essential tools to enhance efficiency and productivity when working with spreadsheets. Here is a detailed list of the most useful shortcuts for data entry, navigation, cell selection, formatting, formulas and document management in these applications.
Using keyboard shortcuts in Calc helps reduce repeated mouse actions. These commands are especially useful when entering values, checking formulas, moving across large worksheets, selecting cell ranges, formatting data or managing a workbook.
Data Entry
The following shortcuts help you enter, validate, edit or repeat content in cells. They are useful when you need to update many spreadsheet cells quickly.
Editing and Validation
- F2: Edit the current cell to change its content.
- Ctrl + Enter: Go to the next line within the cell.
- Esc: Cancel an unconfirmed entry.
- Enter: Confirm an entry and activate the cell below.
- Alt + Enter: Confirm an entry without changing cell.
- Shift + Enter: Confirm an entry and activate the cell above.
- Delete or Backspace: Clear the content of selected cells.
- Equal key: Select the current cell to enter a formula.
- Ctrl + F2: Open the "Function Wizard" dialog box.
- Ctrl + Shift + Semicolon: Insert the time in a cell (LibreOffice).
- Ctrl + Semicolon: Insert the date in a cell (LibreOffice).
- Ctrl + Shift + F2: Place the cursor in the input line.
- Ctrl + Shift + F5: Place the cursor in the name box.
- Ctrl + F3: Open the "Define Names" dialog (OpenOffice) or "Manage Names" (LibreOffice).
- Ctrl + D: Copy the content of a cell down (LibreOffice).
- Ctrl + Shift + Y: Repeat the last action.
For formula work, shortcuts such as the Equal key, Ctrl + F2, Shift + F4 and F9 help you enter formulas, use the Function Wizard, change references and recalculate modified formulas without leaving the keyboard.
Navigating in the Document
Navigation shortcuts make it easier to move through worksheets, especially when a spreadsheet contains many rows, columns or multiple sheets.
Simple Navigation
- Arrow keys: Move to the neighboring cell based on the arrow key pressed.
- Tab: Move to the cell on the right.
- Home: Move to the first cell in the current row.
- End: Move to the last cell in the current row that contains data.
Advanced Navigation
- Ctrl + Home: Move to the first cell in the current sheet.
- Ctrl + End: Move to the last cell in the current sheet that contains data.
- Ctrl + Up Arrow: Reach the first cell with data upwards, or default to cell in row 1.
- Ctrl + Down Arrow: Reach the last cell with data downwards, or default to cell in row 1,048,576.
- Ctrl + Left Arrow: Reach the first cell with data to the left, or default to column A.
- Ctrl + Right Arrow: Reach the last cell with data to the right, or default to column AMJ.
- Page Up / Page Down: Move one screen page up / down in the current sheet.
- Alt + Page Up / Page Down: Move one screen page left / right in the current sheet.
- Ctrl + Page Up / Page Down: Move to the next / previous worksheet in the current workbook.
These shortcuts are helpful when you need to check the start or end of a data table, move between worksheets, or scan a wide spreadsheet without using the scroll bars.
Cell Selection
Selection shortcuts allow you to choose rows, ranges or the whole sheet before applying a command such as copy, clear, format or paste.
Single and Multiple Selection
- Shift + Space: Select the entire row containing the current cell.
- Ctrl + Asterisk: Select the range of cells containing the active cell, if it exists.
- Ctrl + A: Select the entire sheet.
- F8: Turn on/off extended selection mode.
- Shift + F8: Turn on/off selection mode with addition.
- Ctrl + Shift + End: Select cells containing data to the right and down, starting from the active cell.
Cell Formatting
Formatting shortcuts help you change the appearance or number format of spreadsheet content. They are useful when preparing a worksheet for reading, printing or sharing.
Text Styles
- Ctrl + G: Toggle bold.
- Ctrl + I: Toggle italic.
- Ctrl + U: Toggle underline.
- Shift + F3: Cycle text between lowercase, uppercase, and initial capital.
- Ctrl + 1: Open the "Format Cells" dialog box.
- Ctrl + Shift + 1 / 2 / 3 / 4 / 5 / 6: Apply decimal, scientific, date, currency, percentage, and standard formats (OpenOffice).
- Alt + Right Arrow / Left Arrow: Increase/Decrease the width of the column containing the active cell.
For example, you can use Ctrl + 1 to open the cell formatting options, then adjust how values, dates or text are displayed. Column width shortcuts can also help when data is hidden or when a column needs more space.
Various Commands
These LibreOffice Calc and OpenOffice Calc keyboard shortcuts cover common workbook actions such as creating, opening, saving, printing, searching and managing cells.
Document Management
- Ctrl + N: Create a new workbook.
- Ctrl + O: Open a workbook.
- Ctrl + C / X / V: Copy/Cut/Paste the selection.
- Ctrl + Shift + V: Special paste.
- Ctrl + F: Search (LibreOffice); Search and Replace (OpenOffice).
- Ctrl + H: Search and Replace (LibreOffice).
- Ctrl + P: Print.
- Ctrl + S: Save the workbook.
- Ctrl + Shift + S: Save the workbook under another name or in another folder.
- Ctrl + Shift + O: Show/Hide Print Preview (LibreOffice).
- Shift + F4: Toggle absolute and relative referencing.
- F9: Recalculate modified formulas.
- F5: Show/Hide the Navigator.
- Ctrl + NumPadPlus: Open the "Insert Cells" dialog box.
- Ctrl + NumPadMinus: Open the "Delete Cells" dialog box.
- Ctrl + F1: Show the comment of the active cell if it exists.
Shortcut Summary by Task
This summary groups the main shortcuts by everyday spreadsheet task.
| Task | Useful shortcuts |
|---|---|
| Enter and edit data | F2, Enter, Alt + Enter, Ctrl + Enter, Esc |
| Work with formulas | Equal key, Ctrl + F2, Shift + F4, F9 |
| Move through a sheet | Arrow keys, Home, End, Ctrl + Home, Ctrl + End |
| Select cells and ranges | Shift + Space, Ctrl + Asterisk, Ctrl + A, F8 |
| Format cells | Ctrl + G, Ctrl + I, Ctrl + U, Ctrl + 1 |
| Manage a workbook | Ctrl + N, Ctrl + O, Ctrl + S, Ctrl + P |
FAQ
What are the most useful keyboard shortcuts for LibreOffice Calc?
Some of the most useful shortcuts are F2 to edit the current cell, Ctrl + S to save the workbook, Ctrl + F2 to open the Function Wizard, Ctrl + Home to move to the first cell in the sheet, and Ctrl + 1 to open the Format Cells dialog box.
Can these shortcuts be used in OpenOffice Calc?
Many shortcuts listed here apply to OpenOffice Calc as well as LibreOffice Calc. Some entries include specific notes when a shortcut is identified for LibreOffice or OpenOffice.
Which shortcuts help with data entry in Calc?
For data entry, useful shortcuts include Enter to confirm an entry, Alt + Enter to confirm without changing cell, Ctrl + Enter to add a line inside a cell, and Esc to cancel an unconfirmed entry.
How can I move faster inside a large spreadsheet?
You can use Ctrl + Home, Ctrl + End, Ctrl + Arrow keys, Page Up, Page Down, and Ctrl + Page Up / Page Down to move quickly through rows, columns and worksheets.
Which shortcuts are useful for formatting cells?
For formatting, you can use Ctrl + G for bold, Ctrl + I for italic, Ctrl + U for underline, Shift + F3 to change text case, and Ctrl + 1 to open the Format Cells dialog box.
Conclusion
Keyboard shortcuts are essential for optimizing the use of LibreOffice Calc and OpenOffice Calc. By integrating these shortcuts into your routine, you can work more efficiently and save valuable time.
The best approach is to start with the shortcuts you use most often, such as saving, editing cells, moving through the sheet and formatting data. Over time, adding more LibreOffice Calc keyboard shortcuts and OpenOffice Calc keyboard shortcuts to your routine can make spreadsheet work faster and more comfortable.
