Keyboard shortcuts are essential tools to enhance efficiency and productivity in LibreOffice Calc and OpenOffice Calc. Here is a detailed list of the most useful shortcuts for these applications.
Data Entry
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.
Navigating in the Document
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.
Cell Selection
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
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.
Various Commands
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.
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.
