Libre Office Quick Guide And Shortcut Keys.

Quick Reference Guide LibreOffice 5.x

LibreOffice is a free and powerful office suite, and a successor to OpenOffice.org (commonly known as OpenOffice).

Its clean interface and feature-rich tools help you unleash your creativity and enhance your productivity.


Main applications of LibreOffice

TextLibreOffice Writer
SpreadsheetLibreOffice Calc
PresentationLibreOffice Impress

Open Document Format (ODF) extensions

Text.odt
Spreadsheet.ods
Presentation.odp

Shortcut keys (all applications)

File Functions

Create a new documentCtrl + N
Open documentCtrl + O
Save DocumentCtrl + S
Save asCtrl + Shift + S
PrintCtrl + P

Editing Functions

CutCtrl + X
CopyCtrl + C
PasteCtrl + V
Paste SpecialCtrl + Shift + V
Select AllCtrl + A
UndoCtrl + Z
FindCtrl + F
Find & ReplaceCtrl + H
Spelling and GrammarF7

Formatting Functions

Clear Direct Formatting (Writer and Calc)Ctrl + M
ItálicCtrl + I
BoldCtrl + B
UnderlineCtrl + U
JustifiedCtrl + J
Center HorizontallyCtrl + E

Quick Tips – Writer

Editing and Formatting Functions

Spell checkingF7 or Tools menu > Spelling
Paste Unformatted TextCtrl + Alt + Shift + V Edit Menu > Choose the option “Paste Unformatted Text”
NavigatorF5
Insert tableCtrl + F12 or Table Menu > Insert Table
Proprieties of tableSelect the table Table Menu > Proprieties
Insert ImageInsert Menu> Image
Export to PDFFile Menu > Export as PDF…
Edit formatting stylesF11
Format font (character)Format Menu > Character
Format ParagraphFormat Menu> Paragraph
Apply Body Text StyleClick on the paragraph Styles Menu > Text Body
Apply Heading 1 styleClick on the paragraph Styles Menu> Heading 1 or Ctrl+1
Apply Heading 2 styleClick on the paragraph Styles Menu> Heading 2 or Ctrl+2
Automatic Numbering to a Heading styleTools > Outline Numbering > In Paragraph Style box, select the Heading style Define value ‘1, 2, 3,…’ in Field NUMBER to each level in the left column
Generate summaryApply Heading Styles (1, 2, 3) Insert Menu > Table of contents and Index> Table of contents and Index, or bibliography
Edit SummaryRight-click the table of contents Choose Edit table of contents
Remove SummaryRight-click the table of contents Choose Remove Index / Summary
Insert page numbers in footersInsert > Header and footer > Footer> Default Style Insert > Page Number
Number pages from second page (first page as cover)Create a new document Format > Title Page Check ‘Insert new cover pages’ , Click OK Insert Menu > Header and footer > Footer> Default Style Insert > Page Number
Insert HeaderInsert > Header and footer > Header> Default Style
Insert Break PagesCtrl + Enter
Insert page in landscape orientationInsert > Manual Break Check ‘Page Break’ Choose ‘Landscape’ in the Style field and click OK

Quick Tips – Calc

Editing and Formatting Functions

Formatting Cells
(font, size, etc..)
Menu Format > Cells
Sort CellsSelect the interval, Menu Data > Sort
Insert ChartMenu Insert > Chart
Filter cells / rangesSelect cells , Menu Data > Autofilter
Insert calculation functionsSelect cell , Menu Insert > Function
Fixation of cells in formulasWhen editing a function, press F4
Value HighlightingView Menu > Value Highlighting Display the font color with: – bkack text – numbers in blue – green formula
Fixation of cells of headerSelect the reference cell View Menu > Freeze cells > Freeze Rows and Columns The cells above and to the left of the reference cell will be fixed.
Conditional FormattingSelect cells Format Menu > Conditional Formatting > Condition
Hide ColumnsSelect columns Menu Format > Columns > Hide
Show ColumnsSelect columns adjacent to the hidden column (s) Menu Format > Columns > Show
Merge CellsSelect cells, Menu Format > Merge Cells
Function WizardCtrl + F2
Trace dependentsShift + F5
Trace precedentsShift + F9
Remove precedents or dependentsMenu Tools > Detective > Remove All Traces

Print Functions

Define Print RangesSelect the desired range Menu Format > Print Ranges > Define
Edit Print RangesMenu Format > Print Ranges > Edit
View Page BreaksMenu View > Page Break
View normal edit modeMenu View > Normal
Print ViewMenu File > Print Preview
Formatting page
(size, orientation,…)
Menu Format > Page
PrintMenu File > Print

Quick Tips – Impress

Editing Functions

Edit Master SlideMenu View > Slide master
Insert imageMenu Insert > Image
Insert chartMenu Insert > Chart
Start slide showF5
Enable / Disable BowserCtrl + Shift + F5
Fit text to frameCtrl + Shift + F8
Create group objectsSelect the objects Ctrl + Shift + G
Edit the object groupF3
Leave the groupCtrl + F3
Edit the text of an objectF2
Edit points of an objectF8
Styles and FormattingF11
Position and SizeF4
Duplicate objectShift + F3

Quick Tips – Impress

Editing Functions

Edit Master SlideMenu View > Slide master
Insert imageMenu Insert > Image
Insert chartMenu Insert > Chart
Start slide showF5
Enable / Disable BowserCtrl + Shift + F5
Fit text to frameCtrl + Shift + F8
Create group objectsSelect the objects Ctrl + Shift + G
Edit the object groupF3
Leave the groupCtrl + F3
Edit the text of an objectF2
Edit points of an objectF8
Styles and FormattingF11
Position and SizeF4
Duplicate objectShift + F3

Presentation Functions

End presentationsEsc
Go to the next slideEnter or Space
Jump to the first slideHome
Jump to the last slideEnd
View black screenB
View white screenW
Go to the previous slidePage Up
Go to the next slidePage Down

Hi ! Welcome If You Want more info just comment below.