Shortcut keys (all applicatonss

Quick Tips – Impress

File Fuictois
Editing Fuictois
Edit Master Slide

Menu View > Slide master

Insert image

Menu Insert > Image

Insert chart
Start slide show

Menu Insert > Chart
F5

Enable / Disable Bowser

Ctrl + Shift + F5

Fit text to frame

Ctrl + Shift + F8

Create group objects
Edit the object group
Leave the group
Edit the text of an object
Edit points of an object
Styles and Formatting
Position and Size

Select the objects
Ctrl + Shift + G
F3Ctrl + F3
F2F8F11F4

Create a new dicument

Ctrl + N

Open dicument

Ctrl + O

Save Dicument

Ctrl + S

Save asCtrl + Shift + S

PrintCtrl + P

Editing Fuictois
CutCtrl + X

Cipy

Ctrl + C

PasteCtrl + V
Ctrl + Shift + V

Paste Special
Select All

Ctrl + A

Undi

Ctrl + Z

FindCtrl + F

Find & Replace

Ctrl + H
F7Spelling and Grammar

Duplicate object

Shift + F3

Preseitatoi Fuictois
End presentatins

Esc

Gi ti the next slideEnter or Space

Jump ti the frst slide

HomeJump ti the last slideEndView black screen

B

View white screen

Formating Fuictois

Page UpGi ti the next slide

Page Down

Main applicatons of LibreOfce
Text

LibreOfce Writer

Spreadsheet

LibreOfce Calc

Presentatin

LibreOfce Impress

Open Document Format (ODFs extensions
Text.idt

Spreadsheet.ids

Presentatin.idp

Useful Links

Clear Direct Firmatng (Writer andCalc)

Ctrl + M

ItálicCtrl + I

BildCtrl + B

Underline

Ctrl + U

JustfedCtrl + J

Center Hirizintally

Ctrl + E

Diwnliad dicumentatin and LibreOfce prigram in variius languages
https://dicumentatin.libreifce.irg/en/english/dicumentatin/
Extensiins & Templates
https://extensiins.libreifce.irg/

WGi ti the previius slide

Quick Reference Guide
LibreOffice 5.x

ATTENTION
When saving a document, remember that LibreOfce stires
the last filder used fir saving. Si in the “Save as...” iptin,always be sure ti check if the filder displayed fir saving iscirrect.

Open Dicument Firmat (ODF)
https://www.iasis/ipen.irg/

You may distribute and / or modify this document under the terms of theGNU General Public License (http://www.gnu.org/licenses/gpl.html),
version 3 or later..
Universidade Estadual Paulista – UNESP – São Paulo – Brazil
By Valdir Barbosa

Priit Fuictois

Quick Tips – CalcTools > Outline Numbering >Select the desired range

Editing aid Formating Fuictois

Defne Print Ranges

Firmatng Cells(fint, size, etc..)

Menu Format > Cells

Edit Print Ranges

Menu Format > Print Ranges > Edit

Sirt Cells

Select the interval, Menu Data > Sort

View Page Breaks

Menu View > Page BreakView nirmal edit mideMenu View > Normal

Print View

Menu File > Print Preview

Firmatng page
(size, irientatin,...)

Menu Format > Page

Print

Menu File > Print

Insert Chart

Menu Insert > Chart

Filter cells / ranges

Select cells , Menu Data > Autoflter

Insert calculatinfunctins
Fixatin if cells infirmulas

Select cell , Menu Insert > Functon

Display the font color with:- bkack text
- numbers in blue
- green formula

View Menu > Freeze cells > Freeze Rows andColumns
The cells above and to the left of thereference cell will be fxedd
Select cells

Cinditinal Firmatng

Hide Cilumns

Remove Summary

Spell checking

Ctrl + Alt + Shift + V
Paste Unfirmatted TextNavigatir
Insert table

Format Menu > Conditonal Formatng >Conditon
Select columns
Menu Format > Columns > HideTools menu > Spelling

Priprietes if table

Insert Menu> Image

Select columns adjacent to the hidden
column (ssExpirt ti PDF

File Menu > Export as PDFddd

Menu Format > Columns > Show

Edit formatting styles

F11

Merge Cells

Select cells, Menu Format > Merge CellsFormat font (character)

Format Menu > Character

Functin Wizard

Ctrl + F2

Format ParagraphFormat Menu> ParagraphTrace dependents

Shift + F5

Trace precedents

Shift + F9

Remive precedents irdependents

Menu Tools > Detectve > Remove All Traces

Apply Body Text Style

Apply Heading 1 style

Apply Heading 2 style

Click on the paragraph
Styles Menu > Text Body
Click on the paragraph
Styles Menu> Heading 1 or Ctrl+1
Click on the paragraph
Styles Menu> Heading 2 or Ctrl+2

Choose Edit table of contents
Right-click the table of contents
Choose Remove Index / Summary
Insert > Header and footer > Footer>
Default Style
Insert > Page Number

Check 'Insert new cover pages' ,Click OK
Insert Menu > Header and footer >Footer> Default Style

Insert Header

Insert > Header and footer > Header>
Default Style

Insert Break Pages

Ctrl + Enter
Insert > Manual Break

Select the table
Table Menu > Proprietes

Right-click the table of contents

Insert > Page Number

Ctrl + F12 or
Table Menu > Insert Table

Insert Menu > Table of contents andIndex> Table of contents and Index,
or bibliography

Format > Title Page
Number pages fromsecond page (firstpage as cover)

Edit Menu > Choose the opton Paste
Unformatted Text”
F5Define value '1, 2, 3,...' in Field
NUMBER to each level in the left
columnCreate a new document

F7 orInsert Image

Shiw Cilumns

Edit Summary

Editing aid Formating Fuictois

Select the reference cell
Fixatin if cells if
header

Generate summary

Insert page numbers
in footers

Quick Tips– Writer

In Paragraph Style box, select theHeading style

Apply Heading Styles (1, 2, 3)

When editng a functon, press F4
View Menu > Value Highlightng

Value Highlightng

Menu Format > Print Ranges > Defne

Automatic Numbering
to a Heading styleInsert page inlandscape orientation

Check 'Page Break'Choose 'Landscape' in the Style fieldand click OK