LibreOffice Calc Keyboard Shortcuts

LibreOffice Calc is a feature-rich spreadsheet application, offering tools for data analysis, visualization, and collaboration. Mastering its keyboard shortcuts allows users to streamline workflows, manipulate data efficiently, and maximize productivity.

Official URL: https://www.libreoffice.org/discover/calc/

Move one cell in the direction of the arrow

Arrow Keys

Move to the beginning of the sheet

⌘+Fn+Left Arrow

Move to the last cell with data

⌘+Fn+Right Arrow

Move up one screen

Fn+Up Arrow

Move down one screen

Fn+Down Arrow

Data Editing

Edit the active cell

Ctrl+U

Copy selected data

⌘+C

Paste data

⌘+V

Undo the last action

⌘+Z

Redo the last undone action

⌘+Y

Formatting

Apply bold formatting

⌘+B

Apply italic formatting

⌘+I

Underline selected text

⌘+U

Open the format cells dialog

⌘+1

File Management

Create a new spreadsheet

⌘+N

Open an existing spreadsheet

⌘+O

Save the current spreadsheet

⌘+S

Print the spreadsheet

⌘+P

Formulas

Start a formula in a cell

=

Toggle formula view

⌘+`

Recalculate all formulas

Fn+F9

Miscellaneous

Insert a line break within a cell

⌥+Enter

Apply or remove a filter

⌘+Shift+L