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
Text
LibreOffice Writer
Spreadsheet
LibreOffice Calc
Presentation
LibreOffice Impress
Open Document Format (ODF) extensions
Text
.odt
Spreadsheet
.ods
Presentation
.odp
Shortcut keys (all applications)
File Functions
Create a new document
Ctrl + N
Open document
Ctrl + O
Save Document
Ctrl + S
Save as
Ctrl + Shift + S
Print
Ctrl + P
Editing Functions
Cut
Ctrl + X
Copy
Ctrl + C
Paste
Ctrl + V
Paste Special
Ctrl + Shift + V
Select All
Ctrl + A
Undo
Ctrl + Z
Find
Ctrl + F
Find & Replace
Ctrl + H
Spelling and Grammar
F7
Formatting Functions
Clear Direct Formatting (Writer and Calc)
Ctrl + M
Itálic
Ctrl + I
Bold
Ctrl + B
Underline
Ctrl + U
Justified
Ctrl + J
Center Horizontally
Ctrl + E
Quick Tips – Writer
Editing and Formatting Functions
Spell checking
F7 or Tools menu > Spelling
Paste Unformatted Text
Ctrl + Alt + Shift + V Edit Menu > Choose the option “Paste Unformatted Text”
Navigator
F5
Insert table
Ctrl + F12 or Table Menu > Insert Table
Proprieties of table
Select the table Table Menu > Proprieties
Insert Image
Insert Menu> Image
Export to PDF
File Menu > Export as PDF…
Edit formatting styles
F11
Format font (character)
Format Menu > Character
Format Paragraph
Format Menu> Paragraph
Apply Body Text Style
Click on the paragraphStyles Menu > Text Body
Apply Heading 1 style
Click on the paragraphStyles Menu> Heading 1 or Ctrl+1
Apply Heading 2 style
Click on the paragraphStyles Menu> Heading 2 or Ctrl+2
Automatic Numbering to a Heading style
Tools > Outline Numbering >In Paragraph Style box, select the Heading styleDefine value ‘1, 2, 3,…’ in Field NUMBER to each level in the left column
Generate summary
Apply Heading Styles (1, 2, 3)Insert Menu > Table of contents and Index> Table of contents and Index, or bibliography
Edit Summary
Right-click the table of contentsChoose Edit table of contents
Remove Summary
Right-click the table of contentsChoose Remove Index / Summary
Insert page numbers in footers
Insert > Header and footer > Footer> Default StyleInsert > Page Number
Number pages from second page (first page as cover)
Create a new documentFormat > Title PageCheck ‘Insert new cover pages’ , Click OKInsert Menu > Header and footer > Footer> Default StyleInsert > Page Number
Insert Header
Insert > Header and footer > Header> Default Style
Insert Break Pages
Ctrl + Enter
Insert page in landscape orientation
Insert > Manual BreakCheck ‘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 Cells
Select the interval, Menu Data > Sort
Insert Chart
Menu Insert > Chart
Filter cells / ranges
Select cells , Menu Data > Autofilter
Insert calculation functions
Select cell , Menu Insert > Function
Fixation of cells in formulas
When editing a function, press F4
Value Highlighting
View Menu > Value HighlightingDisplay the font color with:– bkack text– numbers in blue– green formula
Fixation of cells of header
Select the reference cellView Menu > Freeze cells > Freeze Rows and ColumnsThe cells above and to the left of the reference cell will be fixed.
Conditional Formatting
Select cellsFormat Menu > Conditional Formatting > Condition
Hide Columns
Select columnsMenu Format > Columns > Hide
Show Columns
Select columns adjacent to the hidden column (s)Menu Format > Columns > Show
Merge Cells
Select cells, Menu Format > Merge Cells
Function Wizard
Ctrl + F2
Trace dependents
Shift + F5
Trace precedents
Shift + F9
Remove precedents or dependents
Menu Tools > Detective > Remove All Traces
Print Functions
Define Print Ranges
Select the desired rangeMenu Format > Print Ranges > Define
Edit Print Ranges
Menu Format > Print Ranges > Edit
View Page Breaks
Menu View > Page Break
View normal edit mode
Menu View > Normal
Print View
Menu File > Print Preview
Formatting page (size, orientation,…)
Menu Format > Page
Print
Menu File > Print
Quick Tips – Impress
Editing Functions
Edit Master Slide
Menu View > Slide master
Insert image
Menu Insert > Image
Insert chart
Menu Insert > Chart
Start slide show
F5
Enable / Disable Bowser
Ctrl + Shift + F5
Fit text to frame
Ctrl + Shift + F8
Create group objects
Select the objectsCtrl + Shift + G
Edit the object group
F3
Leave the group
Ctrl + F3
Edit the text of an object
F2
Edit points of an object
F8
Styles and Formatting
F11
Position and Size
F4
Duplicate object
Shift + F3
Quick Tips – Impress
Editing Functions
Edit Master Slide
Menu View > Slide master
Insert image
Menu Insert > Image
Insert chart
Menu Insert > Chart
Start slide show
F5
Enable / Disable Bowser
Ctrl + Shift + F5
Fit text to frame
Ctrl + Shift + F8
Create group objects
Select the objectsCtrl + Shift + G
Edit the object group
F3
Leave the group
Ctrl + F3
Edit the text of an object
F2
Edit points of an object
F8
Styles and Formatting
F11
Position and Size
F4
Duplicate object
Shift + F3
Presentation Functions
End presentations
Esc
Go to the next slide
Enter or Space
Jump to the first slide
Home
Jump to the last slide
End
View black screen
B
View white screen
W
Go to the previous slide
Page Up
Go to the next slide
Page Down
Hi ! Welcome If You Want more info just comment below.