LibreOffice Shortcut Keys

A comprehensive guide to boost your productivity

File Menu

CTRL + N New Sheet
CTRL + Shift + N Manage Templates
CTRL + O Open Previous Saved File
Shift + F11 Save Template
CTRL + S Save File
CTRL + Shift + S Save As
CTRL + Enter Next Line
CTRL + Shift + O Print Preview
CTRL + Q Exit LibreOffice

Edit Menu

CTRL + X Cut
CTRL + C Copy
CTRL + V Paste
CTRL + Z Undo
CTRL + Y Redo
CTRL + Shift + Y Repeat
CTRL + Shift + V Paste Special
CTRL + Alt + Shift + V Paste Unformatted Text
CTRL + Shift + Spacebar Select All
CTRL + PageDn / CTRL + Tab Go To Next Sheet
CTRL + PageUp / CTRL + Shift + Tab Go To Previous Sheet
Shift + Spacebar Select Row
CTRL + Spacebar Select Column
CTRL + * Select Data Area
F2 Edit Cell
CTRL + Shift + M Edit Mode
CTRL + H Find and Replace
CTRL + F Find

View Menu

CTRL + F8 Value Highlighting
CTRL Show Formula
CTRL + F5 Show / Hide Sidebar
F11 Hide Styles
F5 Open Navigator
CTRL + Shift + J Full Screen
CTRL + Shift + F4 Data Source Hide/Show

Insert Menu

CTRL + F2 Insert Function
CTRL + Alt + C Comments
CTRL + K Hyperlink
CTRL + ; Date
CTRL + Shift + ; Time

Format Menu

CTRL + B Bold
CTRL + I Italic
CTRL + U Underline
CTRL + Shift + P Superscript
CTRL + Shift + B Subscript
Shift + F3 Cycle Case
CTRL + 5 1.5 Line Spacing
CTRL + 2 2 Line Spacing
CTRL + L Left Alignment
CTRL + E Centre Alignment
CTRL + R Right Alignment
CTRL + J Justified Alignment
CTRL + ] Increase Size
CTRL + [ Decrease Size
CTRL + D Double Underline
CTRL + Shift + 6 General Format
CTRL + Shift + 1 Number Format
CTRL + Shift + 5 Percent Format
CTRL + Shift + 4 Currency Format
CTRL + Shift + 3 Date Format
CTRL + Shift + 2 Scientific Format
CTRL + M Clear Formatting
CTRL + 1 Cell Formatting

Style Menu

F11 Manage Styles

Sheet Menu

CTRL + + Insert Cell
CTRL + - Delete Cell
Backspace Clear Cells
F4 Cycle Cell Reference Type
CTRL + D Fill Down
CTRL + Alt + C Edit Comment
CTRL + Shift + Tab To Previous Sheet
CTRL + Tab To Next Sheet
CTRL + F3 Manage Names
Tab Go To Next Cell
Shift + Tab Go To Previous Cell

Data Menu

CTRL + Shift + F9 Recalculate Hard
F9 Recalculate
F12 Group
CTRL + F12 Ungroup

Tools Menu

F7 Spelling
Shift + F7 Automatic Spelling Check
CTRL + F7 Thesaurus
Shift + F9 Trace Precedents
Shift + F5 Trace Dependents
CTRL + Alt + E Extension Manager

Window Menu

CTRL + W Close Window

Help Menu

F1 Help