LibreOffice Shortcut Keys

**Ctrl + ' **

Copy formula from cell above

Data Entry

**Ctrl + Shift + ' **

Copy value from cell above

Data Entry

Alt + Down

Open Selection List/Filter

Data Tools

Alt + Enter

Insert a line break inside a cell

Cell Editing

Alt + Page Down

Move right one screen

Navigation

Alt + Page Up

Move left one screen

Navigation

Alt + Shift + Arrow

Optimize column width/row height

Management

Backspace

Clear contents immediately

Cell Editing

Ctrl + `

Toggle formula view (Show formulas)

Formulas

Ctrl + -

Delete selected cell/row/column

Management

Ctrl + ;

Insert the current date

Data Entry

Ctrl + [

Decrease Font Size

Formatting

Ctrl + ]

Increase Font Size

Formatting

Ctrl + *

Select the current data range

Selection

Ctrl + /

Select the current array/matrix

Selection

Ctrl + +

Insert a new cell/row/column

Management

Ctrl + 0

Hide selected columns

Management

Ctrl + 1

Open the Format Cells dialog

Formatting