
Chapter 5
Getting Started with Calc
Using Spreadsheets in LibreOffice

 !
!" #$%&!'!
()$$"""  $!$! !*+,-!+,
.()$$, $!$$/ $*+,/ !
.!!0"!!"

0Getting Started with OpenOffice.org 3.3
To this edition
. 123 !,4!!
,5 '!6 14!!7
To previous editions
14!!7 '! ,8!
43!2 26!1 8
1. !,4!! ,9!
8

'!:
!!);!! ! 

<,!!+!!
!"+!!,
!

'!. 5= 

007"> 
!!",0 6
!!+!4!
Windows or Linux macOS equivalent Effect
!
!
! .
Right-click !?!0$@!0

>
Ctrl(Control* (⌘ Command* &"0
F5 Shift? ?⌘ F5 %,
F11 ?⌘ T !0
Documentation for LibreOffice is available at https://documentation.libreoffice.org/en/english-documentation/

""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""#


,
60
'!",
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""#
$%""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""&
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""&
7! A
6!> A
8 A
''"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""&
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""(
!
8
! B
6! B
 
 
!
C,!!!

)"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""*#
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""*+
, /
<> D
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""*,
!!, D
, =
9, A
3<0 
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""*-
!!! B
!!! B
2!! B
2@!! B
!!" 
!!" 
8!!!" 
< 
! 
! 
Chapter 5 Getting started with Calc | 3
8!! 
8!!@ 
.!! 
4" 
$""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""#*
C!" 
!!" 
8!!!" 
!!" 
!!" 
8!!!" 
$""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""##
C" 
8, -
 -
&! -
! /
2 /
)"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""#+
," /
63"! D
63"! D
&3 D
! D
!3!!,!! =
2,!," =
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""#.
% =
8 =
3 =
%> 
> 
 
. B
2! B
<> B
 B
!3 B
2 B
, B
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""/0
&6!!! -
&!! -
!! -
!! -
&!! -
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""//
4| Chapter 5 Getting started with Calc
)"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""//
1"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""/+
! -/
!! -/
! -/
2! -/
 -/
&0 -/
& -/
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""/,
8!!!> -D
." -D
8!!0 -=
0>!! -=
6 -=
6>!! -=
6!! -
6!!0 -
6!!!! -
2"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""/(
&.6 -
".6 -B
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""/-
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""+*
3""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""+*
4 /
" /
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""+#
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""+/
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""++
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""++
6736 //
24""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""+,
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""+,
', /=
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""+.
' /A
 /A
. /A
2, /A
< /A
' /A
2"! /
Chapter 5 Getting started with Calc | 5
'0 /
C0 /B
!0 /B
4 /B
 /B
6| Chapter 5 Getting started with Calc
$%
! #(!!!*
!!
.!,!+!E7 F
,!",
,!!)
• 6+"!!>!!
• +++!
• G"-
• 8+>,0G!!
5+'+5!!+1,
• .!++,8<>!
• C>!!+!48+H+'6+
'

$
!"!asterisk (*)+question mark (?)+tilde (~)
!3 7!"
!!!!"!
>"!"!>
5
5!+!"!>+Calc R1
Excel R1>8<>! "!!!!!"
" 4",+!"<>!"!>!
 !!!!5Excel
R1@",
6!>+Calc Guide Chapter 7 Formulas and Functions
6
8Visual Basic for applications(H5.*+Basic
.'C .!!+I
!!
",some<>!H!5! !
!7!)82"
6+!!8
''
!"0"!!spreadsheets ,!
sheets+!!"! .!!!
"!!
!!!,!!J>++!+J0
!!
Spreadsheets, sheets, and cells | 7
<,,!+,,!!! C
!+,>+/+DA=">/! 
!!-+

7!+""(6* ""
!"

!+!+" 7
"!!!0+Untitled X+"X
7,+
Figure 1: Calc main window
6
7!8+@"" #
!38GChapter 14 Customizing LibreOffice
• J!G>!+Open+Save+
Wizards+Export as PDF+Print+Digital Signatures, and Templates.
• 1JG>!+Undo, Copy, Paste,
Track Changes, Find and Replace, Compare and Merge Documents.
• )J"!!0G>!+
Toolbars, Grids, Column & Row Headers, Full Screen, Zoom.
• 9J!G>!+
Pictures, Media, Objects, Formula Design, Frames, Special Characters, Charts, Functions,
8 | Calc main window
Shapes, Pivot Tables, Named Ranges, Comments, Hyperlinks, Headers and Footers, Form
Controls.
• J!G>!+
Cells+Page+Styles+Alignment, Merge Cells, Print Range, Conditional Formatting,
Spreadsheet Themes, Image, Chart, Object.
• J!!!!+!!

• J!+Insert
Delete Cells, Columns, Rows and Sheets, Sheets from File, Cell Reference Type, Link to
External Data, "!! Comments  Fill cells.
• :J!G>!+Define
Database Range+Sort+6!+Statistics, Pivot Tables, Consolidate, Forms, Groups and
Outlines.
• J,!03G
>!+Spelling+Share Document+Gallery+Macros, Goal Seek, Solver, Detective,
Protect Sheet, XML Filter Settings, Extension Manager.
• $JNew""Close""
• 3J!0!!!G
>!+Help+License Information+User Guides+Check for Updates, Send Feedback+
Donate

!"!6!0
"0(6*
!!0>!+!G,!
,"0 0!0,
0"0+!!! !!
"0>"0
#!@!!,!!! C
@ ,+!)! !;6<
!)! !)! !
!(!!*!,"
 #!,!GChapter 14
Customizing LibreOffice 7,!"+!
"!

6!5(6*!!"0 6!
5!0!! C6!
5,!+)8!8
Figure 2: Formula bar
6!+6!5!!")
• 85J,,!!!
+>!. !!"
!!! C,!!!!+
"> #!!!%5>
Formula bar | 9
I!! CEnter
0+!!
• $4 J!"!
,!! ,!!""

•  J!0!!!,!!!
!!!!! C,!
!!+!!!! 7+!
"!>+! #
Enter+IEsc #!I"
!>I  
!K,!EnterEsc
•  J!06K!(L*!!!
9+!!"! %>"!
K!+K0>
• 9J!!!!(+!+*!!"
!! C!!!,!
!+!0"
#!!!!!!!!@!0!! 7
"!!+62


CEF,I!
 Calc Guide Chapter 7 Using Formulas and Functions


!(6-*,"!!K0
," 8!!
GChapter 1 Introducing LibreOfficeCalc Guide
Chapter 1 Introducing Calc
Figure 3: Calc status bar
K0"!!! 
#!!,+!+!@!0
,!!!"!
(6*

!()!*!"" C>
!! C!7("/
0*,0)'+!+!!+%,+6 <0
!+!!""
" 0!"
10 | Calc main window
• )0!,!
– =.,!!!!!+!!!+"!!!
– )!>+!+3+! 
!++!,">,
C!6!!! 
– =M0!!!++
+> %!!!!!6!,!!
– 2)!!>,"+!3!,!
!+"+++>+,!0
– 2=!+!!!0
!+!!!!!!+!
<!6+"!,
 !!0!!
• =0!!+"!
(F11*>6!
• >)0!!+"!
>! !>8
• )0!!+"!!
%,""!0!
!)!(F5*8 !
:%,!
• )0!!+"""
!9!"""8
!0(?*+"!0
!,! !00
+,!!+!04$" I
0"+!

Individual cells
"0!!!! <!!
!"
.!!">
! !!.
 "!"
!"!!%5>
6!5(6* C,!+)8
!@A3
Sheet tabs
C!+, .!!
" !0
!,!! .,
""(!!* #!!!!!"Ctrl
0"!!0
Spreadsheet layout | 11
!(++*+@!0
!A>!!0!
!" !0B"!!
!+@!0! >
 ! !!!0B"!! 
"!!!+Chapter 14 Customizing LibreOffice
)
@@,!(H*!!>"!!
+>!! <!H>!
" >"K0G
"K0

8H!!+K++"
!!K 87"+H!,
N!>!0!0<>!!+!!H!
!!
H!!)
* !8!H!"
* !!!0 5!+H!>.csv 4",+
H!,.txt>
-*  59!(6D* 4!,,!!
"H!!
/* !0B!
Figure 4: Text Import dialog
12 | Opening a CSV file
H!!!!")
• 9
– Character SetJ!
– LanguageJ"
C!H+!"!!!!!! C
!+!"!!"

– From RowJ""" ",!
,"""!
• J">"
!
– Fixed widthJ>@"(K!*! 
!0!,""""
– Separated byJ!!! C
!Other+! 
!
– Merge delimitersJ,!,!0!
– Text delimiterJ!!>
• 
– Quoted fields as textJ"!+!!!",!
K(!,!K!>!*
>
– Detect special numbersJ"!+!"!!!!!!
+!!++
 !!!!"!
+!,,
!
7!+!"!!,!! 
+!+"!!> .
!,@B++!
 !,"!
!
• J"""!!!0"!
– Column typeJ!!,"""!
!
– Standard J!
– TextJ>
– US EnglishJ&<!!
!! .! C&
<!+Standard!
– HideJ!
Opening a CSV file | 13

,+Chapter 1 Introducing LibreOffice!",!
!!!! !!,!>
'6+48+N48!1'<'%G
Calc Guide Chapter 6 Printing, Exporting, and E-mailing

C>!""!,!
6(6*(*.ods*+"!!+,

* ,!!(*.ods*
* !!282!(6D*
-* C+"!
/* C@"+!"
D* C25!+!>
,!"!!!
=* !0
Figure 5: Save As dialog
A* 7,!!+!(6=* 
!0C555D,!!0
:,!
Figure 6: File Format dialog
14 | Saving spreadsheets
* C! 5)(*.csv*+15 5!
(6A* 4!+!!+>!+
H!
Figure 7: Export Text File dialog for CSV files

,!,!!!6
+ !!7!> C:
:!:+!'2+!
!
15
C"!!+!
+!>!!(*'%
1')
* !
* !E15"""<>!
-* <>
/* !! !
D* 800>15!
=* !015"""

!,","!!!! #
!!

7!!!+!!3 7!!
!+!!! !!!!
!!!",
• J!,!!!0! 
,!!+!,
!!""!0!
• J!!>!!%5>
6!5(6B* "!!!!"
Cell navigation | 15
,Enter0!!@,)>!+
-.-"!!,!!.-
• JF50%,!(6*!0
 !!!2"
!Enter0
Figure 8: Navigator in Calc
• 1JEnter,!!"!>
" 'Shift+Enter,!,"
•  J,!!">! 
'Shift+Tab,!",!
• J"00,!!
"
• 3+1+:
– Home,!!"
– End,!!!!!"@!

– Page Down,!!"!!
– Page Up,!!!!

<+!0
 ",")
• J"%,(6*+!@!0
!!
• J0Ctrl+Page Down,
Ctrl+Page Up,!
• J!0
!
C!+ C
)
• &!,,"(6B*
• 2@!0">"!
(6*
16 | Navigating within spreadsheets

7"+!!!>
K ""
"++"
! C
03!
Figure 9: Navigating sheet tabs
Figure 10: Right-click any arrow button
B
,0+00 60
+0 !!00
,!
Table 1. Keyboard cell navigation
Keyboard
shortcut
Cell navigation
→ 8,!!!!
← 8,!!!!!
↑ 8,!!!!
↓ 8,!!"!!
Ctrl+→ 8,!!!"!!
!0!!
8,!!!!!!
"!!!!
8,!!!!
!!
Keyboard navigation | 17
Ctrl+← 8,!!!!!"!!
!0!!
8,!!!!!!
"!!!!
8,!!!"!!

Ctrl+↑ 8,!!!0!!!!,
!
8,!!"!!!!
!!
8,!!!!!!!!
"
Ctrl+↓ 8,!!!0!!!!!"
!
8,!!!"!!!
!!!!
8,!!!!!!!!
!"
Ctrl+Home 8,!!"!!.
Ctrl+End 8,!!"!!!!"
@!!!

Alt+Page Down 8,!!(!*
Alt+Page Up 8,!!!(!*
Ctrl+Page Down 8,!!!!>"
"G
Ctrl+Page Up 8,!!!!>!"
"G
Tab 8,!!>!!
Shift+Tab 8,!!>!!!
Enter 8,!!"!!(!* >
Shift+Enter 8,!!!!(!*
41
#3"Enter0,!! !
!!> !!!,@"
! !+
! Enter0!" &
"Input settings6Enter0
Figure 11: Customizing the Enter key
18 | Navigating within spreadsheets


Single cell
@!0!! #,!!0%5>6!5
(6B*
Range of contiguous cells
.!!!0
!!!)
* !0!!
* '!"!
-* 8,
/* !0!!!+!!
!!!")
* !0!!"!!
* 8,!!
-* 4!"Shift0!0

#!!!!!0
!5(6-*!15
!0!! 800
>!!!!!
!!!")
* !!!"!!!!
* 7!!"Shift0+"!

#!!!!!%5> !0%
5>6!5(6B* !!!+!!
!@!!+!!"!()*+!"@
!! 6>!+!"!.-=+
"!A3:C6
Range of non-contiguous cells
* !!!!!,
* 8,>!!!
-* 4!"Ctrl0!0!0@@!!!

/* 2
Selecting cells | 19
=
!"@!! 6>!+
@

Single column or row
!!!+!0!(6*
!!"+!0"
Multiple columns or rows
!!!!")
* !0!"
* 4!"Shift0
-* !0!!"
!!!!")
* !0!"
* 4!"Ctrl0
-* !0!!K!""!!"Ctrl0
Entire sheet
!+!0>"!."
(6*+0Ctrl+A!+1
8!2
Figure 12: Select All box

#!!!! C,!!!+
!!""0
Single sheet
!0"! !
"(!!*
Multiple contiguous sheets
!!!)
* !0
* 8,,!
-* 4!"Shift0!0
/* .!!""!"!!"(!!* .
"!!"!!!
20 | Selecting items in a spreadsheet
Multiple non-contiguous sheets
!!!@)
* !0
* 8,,
-* 4!"Ctrl0!0
/* 2
D* !"!!"(!!* ."!!"
!!!
All sheets
2@!02>
3
",!
! +!
,+@!0>+!3 "
+@!0!> .!"!!
"!!! !0!0B

!!!,!
$
9
Single column or row
&)
* !!!+!+""""!"
* 8!9!!O
A9!A!A2OA8
&)
* !!""""!"
* 2@!0!"
-* !9+9A+9A2+9A
8>
Multiple columns or rows
8!!!"
* 4!K!"!"!
K
* '!!",
Inserting columns and rows | 21
:
Single column or row
!!!")
* !!!!""!
* 8!:@!0!:
>
-* !K!!!!(6-*
Figure 13: Delete Cells dialog
.!,!)
* !0!!!"
* 8!:@!0!:
:A>
Multiple columns or rows
!!!!")
* !!"+E8!!!"F

* 8!:+@!0!:
:A>
$
9
!02 "!
"9! !!"
9!(6/*+""+
+"+!!
* !"""+!9"""
8
* 2@!0"""!9
>
-* !0
/* 2@!0!9
>
#,!
22 | Working with sheets
Figure 14: Insert Sheet dialog
6
#,"+
67! ,+,
67!
Dragging and dropping
,"+!0!
"!
copy"+!"Ctrl0(Option08*
!0"! 
!!
Using a dialog
&67!(6D*>!""
+"+"
,
* C+@!0",!
67>!6"""
8
* !6,.
-* !""!@"!
 +!+
"
/* !9""!
D* >>"",
 C+!!(+-+
*
=* !0B,!!

7,"+!
"!!0,!
Moving and copying sheets | 23
Figure 15: Move/Copy
Sheet dialog
:
!!+@!0"!!:
>+!:"""8 !0F
!
!!!+!(E!F*+@!0
!:>+!:
"""8!0F!
A
5!+"SheetN+"X>
 7!"0!!"!"+
!"
#!!")
• <>>"C
!(6D/*
• 2@!0!A>!
>"
• !@!0A!

"!G+!
+!!" .+
!+++.
",!"!!
)

&3""!!""""0
 63+Chapter 1 Introducing LibreOffice
24 | Viewing Calc
4
63!0"!!
"! +","+!!
3"!!","
6="3"! ,3!!""-
-,,!!"!6M"-!.
63 ""--!"6M,!!

Figure 16: Frozen rows and columns
Freezing rows or columns
* !0!!!!"""3!
!"3
* !04A !)
8!4!4A.,!
""!"3!
Unfreezing
3"!+)8!4!4
A!04A! 
,!3"!!

.","!!(!
0"!""* !3!!+,!!++,
," .>!!
"6A"!!"""
7"!"P6>!+!"!!
!!! &!@K+
!!!!"!
 #!!""
!
Figure 17: Split screen example
Splitting the screen | 25
Splitting horizontally or vertically
* !0"!""""!3!!
!0!!""!
,!!
* )8!$"7""
"!"!!+"6
.!,!)
• 63!!+"3!""""
"3!!
• 6,!!+",!""!
"",!!
Figure 18: Split screen window borders
Removing split views
,!,"+!!")
• !""0!!!
• )8!$"

8!!0

!0!!00
0 5!+!!!
Minus numbers
,+(J*!
(*+>!(-/* !"!!
+>!@-/
Leading zeroes
!!"
+>!-/+!3,
!!"
26 | Using the keyboard
6*
* 7!!!+@!0!!+!>
!80Ctrl+1
!(6B*
* 80!!NumberCategory!
-* C!G+K 6
>!++/ .!"!!,
!3+>!
/* !0B !
"!!!
Figure 19: Format Cells dialog – Numbers page
6#
* !!!
* ()!*!0(H*
!
-* !!>
/* 4,!>+ 6!!
Figure 20: Set Leading zeroes
C"!3+>!/+"
3+!!"!!!!! ,!
3)
* (Q*+>!Q/
Numbers | 27
* 8,!!!! !!,+!
3,>!!
Numbers as text
%!>!!"
6*
* 7!!!+@!0!!!>
!80Ctrl+1
!(6B*
* 80!+!TextCategory!
-* !0B+"+,>+!+!!
6#
* !!!
* ()!*!0(H*
!
-* ! 5!> 6!!!!
/* !00!! <,!!,


5!+,>"!!
3! 6!"!!
> # EEE
E+:+!;
5<!
5"!
5
!0!!> 5!+>!@!!!
:
!!!
#!"!($*(J*>+>!
 !!!!
7+!"!+>!)/-)/D 
!!!!
!+!!"
6*
* 7!!!+@!0!!!>
+!8+0Ctrl+1+
!(6B*
* 80!+!DateTimeCategory!
-* !"Format! !0B
6#
* 7!!!+()!*(*!0
(H*!
* !:!>
28 | Using the keyboard
-* !06!!!
/* !"Format! !0B
2
!!!!+!,
, #!
0Ctrl+Z!!0!
"""!!
+ !28
2!(6*
Replace
<!!!!!",

Exceptions
,!"
!!
Options
!!!!0B
Localized options
.K0
!>
Reset
2,!0!,!
Figure 21: AutoCorrect dialog
:
.!" 
!.+ 8!!29
Deactivating automatic changes | 29

<,!@,+!,,!!
,
!!!" 8
!!.C!! !!!,!!+
!!,! !!!!+!!+!
!!

!6!!!!>!!
(6*
* !!!"
* !"Shift0!0!!!
"!!
-* !8!""
(+:+A*A"""

.!,!+!!!!
* !!!"
* 8,,!!K!!! 
"!!
-* !0"!!!! C!!!
>+>"!!!! C!!!+
"!!
Figure 22: Using the Fill tool
Using a fill series
7!!!!!"""+!(6-*
 4!"
30 | Speeding up data entry
Figure 23: Fill Series dialog
• :J
– DownJ""!!!!
,!
– RightJ!"!!!
,!
– UpJ"!!!
,!
– LeftJ!!!!
,!
•  J
– LinearJ!,!
– GrowthJ",!
– DateJ
– AutoFillJ! .6!!0
3! 6>!+1!!+
!! !!!
.6!!!,! 6>!+
!+-+D!!!"A+B++-G
  BBD  BB+,!
•  J !,

– DayJ,
– WeekdayJ,
– MonthJ
,
– YearJ
• )J,! &+
• 1)J,! &+
• 9J,!"!
 <!!+",
!
Using the Fill tool | 31
Figure 24: Sort Lists dialog
Defining a fill series
"!!)
*  !!!!
(6/* !",!@Lists>!
!!Entries>
* !0Entries>!
-* "!Entries>(!*
/* !02"!"!!"Lists>
D* !0B,"!
Defining a fill series from a range in a sheet
#>,!!!
* !>,!"!!
*  !!!!(6
/*
-* !> !0
!

!!,!!!>!!>!
!
* !!0!!!!!">
* 2@!0!> .@"!
!!!!!>"
>
-* !0>K!!!
32 | Speeding up data entry

#"!!!!+>!
!,!3 C!
,!!+,!
* 1!!"""8!
Figure 25: Select
Sheets dialog
* !,!"" &Shift
Ctrl(Options8*0!!!
-* !0B!"!!!
/* <!!"""!!
!!!

K!!,"+""+
!!!! 80!!
"

)
7!+,!!!
,!!! #!,!""0
!>!
6!!!!!+!
 ,!"+!!!:!)
8!! 6>!+!!
K"!"!!+!!
!
",!+,!!
+,!>!!!!"
!",! #!!!,!+
""+" Calc Guide Chapter 2
Entering, Editing, and Formatting Data,!!!
Validating cell contents | 33
1
:
Deleting data only
!!!"!!! !0!!!
Delete0
Deleting data and formatting
!!!!!
* !0!!!
* 'Backspace0+@!0!!!:
>+1!:*8:
!(6A* 4!
!!!,!!
Figure 26: Delete
Contents dialog
A
!!!!!"+!!!" 
""!!!!!!"!!!
!!
.!,!+!!!!0C6!5(6B*+
!@!0!!!"

!!",!!!! 
6>!+E!M FE!MF!!"
Using the keyboard
* !0!!!
* 'F20!!!
-* &0"0""
"!!
/* 7,+Enter0,
Using the mouse
* !@!0!!!!!!
* <)
• 2"""!!
34 | Editing data
• !@!0!!!
• 8,C6!5(6B*!0
"""!!
-* 7,+!0"!!!
,


.!!!!!! 
Calc Guide Chapter 4 Using Styles and Templates in Calc
65
8!!!>!!!"!!
0 <!
Automatic wrapping
!!"!!!>!!+!!"
6*
* 2@!0!!!>+!
8+Ctrl+1+6!!!
* !0Alignment(6A*
-* &+!7>!!!0B
Figure 27: Format Cells dialog – Alignment page
6#
* !!!
* ()!*!0(H*2
!
-* !$5!!
Multiple lines of text | 35
Figure 28: Wrap text formatting
Manual line breaks
!!0"!!!+Ctrl+Enter 7>+!@
!0!!+""!0 C!
!+Shift+Enter
7!!0!!+!!"!!!!
!!
5
3!!!!I!! +
!Shrink to fit cell size6!!!(6A*
2 !!,!!!06
!0+">!!!

,!!!!6!
(!6B* !!!+!0!,
Figure 29: Number icons on Formatting toolbar
6!!+Numbers6!!
!(6A*)
• .!!
• !!!!3
• <
• !!!
!
,!!:!'
0 !066!!!,
5
K0!!>!!)
* !!!
* !0!!!6%>6!
(!6-*!@"!
36 | Formatting data
-* !0!!!636!!
3"!
Figure 30: Font Name and Size on Formatting toolbar
/* +!08+Italic+&!
D* 3!!+!0!
(++2+1* 6E
E2+!43!"!
=* ,!!>!!+EE
2!H!"!
A* !+!0">6! !!
!+!!
* !K0>!!(6-*
Figure 31: Direct formatting through Format menu
0,!++++
22+""!!!
6!
!!!+6!!! #
!!6!6
!!! !!!!!"!"

&Font Effects6!!! Calc
Guide Chapter 4 Using Styles and Templates in Calc
Formatting fonts and text in cells | 37

!!!!!+!05 
6!+!!!
!!+!0!! !! 
6!!!!+!5! .!!!
2!0+
!
6!+!"!!!!+
Borders6!!!(6A*+"!
"! !062!+!06
!:!!@"!+6!!!Borders 
Calc Guide Chapter 4 Using Styles and Templates in Calc

!!!!!!!!"
!! 6>!+!!-+
!,!- C,!
!!

0!!!!!+!0!!">
50! 6!.!!+!6!
!+! #!Background6!!!(6
A* 2!0
!"!! Calc Guide Chapter 4 Using Styles and
Templates in Calc

!!!!!!+!06O! .!
!! !!!+!+!
60 #!!!!!!!06O
!O%"!R<"!!0>!
! .!+!+!!!60 
2
2
#!:.6!(!!*K0!! C!
!!"!0!,!.!!
!
* !!!!!"+!!"+
"
* !282!
(6-*
-* !!!
38 | AutoFormatting of cells
/* !!.6 7!
!+.6!!!
D* !0B
Figure 32: AutoFormat dialog
:2
#".6,!!!!
* 6++3+!!+!!0+
!!
* !
-* !2.6! 2",
/* !02
D* CName>..6!+!
"
=* !0B, ".6",!!Format!.6
!

".6!,!!
 4",+".6!!
".6

!"(!*!
 7!C!"!+!
! !,!!
"!
!)
* !0   ! C!,!+
)! 8! + !
(6--* !!,!!"!
* !"!.!+!
!!,!
-* !0B
Using themes | 39
/* C"+"!""! 
G!!


.!",>"!!,!!>!
3""!
Figure 33: Theme Selection dialog
!"0"!!! ,!!!
! ."!+!Card 6-/"
!Pastel
Figure 34: Cell styles of
theme "Pastel"
40 | Using themes

#!! 6>!+
!+"!!,!,,!!!"
, 8!!priority
rules +!!"0!
+>!
!!.!!
!  !!28! 
Calc Guide Chapter 2 Entering, Editing, and Formatting Data
3
C!!,!!
" 4",+!!!!
!! 6>!+!5+"!
!.
6""+!"!
!+Calc Guide Chapter 2 Entering, Editing, and Formatting Data

7!!+!0!!,!
3
sheets+!+!38+@!0
3> #!!G
!,!
rowscolumns)
* !"!"
* 8!A
-* !3"!!,"
.!,!+@!0"!!3A3
>

"+"+!)
* !+"!+"!
* 8!+A
-* !+"!"!!!

.!,!+@!0+"!!
>

C!(.*"(*+!"!
""!
Showing data | 41

.!!!!",
3 "!!!,
!+,!"!!"
5!+all !!"!!!Protected (6-=*
5+"!!!"!!
""
)
* &,!+!!!"
* 6!!!@!0!Format Cells!
!8
-* 6!!'6!!!+',!
!!!
CCell Protection6!!!!4!!
!!
!!!)
*  !
* <"!0B
-* !8+@!0!
>+0Ctrl+1!
/* !0Cell Protection(6-D*!!!
D* !0B
Figure 35: Cell Protection page in Format Cells dialog
7!!!!,!")
*  !'!"!!(6-=*
* !Protect this sheet and the contents of protected cells
-* ""
/* !!!!!
D* !0B
.!!!"!!!!
,"
42 | Cell protection
Figure 36: Protect Sheet dialog
.!,!+,!!!
,!! !8 
!0+"6-A
Figure 37: The lock icon in
a protected sheet

"!!! ,!
!,! !"
!,!,!
.!+!"" 7
!+!!"+"
! .,+

6",!!+Calc Guide
Chapter 2 Entering, Editing, and Formatting Data
Figure 38: Sort Criteria dialog
Sorting records | 43
!!)
* !!!
* :!8!(6-*
-* !"! !!!
!!!
/* !(.@S+@B*(S@.+B@*
D* !0B

!!>,.
!!+"!!
!",,!!!T:
"@!0!!!Insert
Comment  Context Menu . .!,!+ 
!9!8, 0(Ctrl+Alt+C), 
!0Standard Toolbar.
5!+"!!!", !!
0"K !,!
+!)!8.

#> !!
!! 6!K,!
! H!!!!!KK
.!!!!!!3! .!!
,!!!!6!
!K!!0
$4
6!!!
"3 !"3+!0673Name box.
C"3++!+""!
,!! #!!""3,
!!!!
<+"!+"!!!>!!> C
"!!!!!>"K
result window ">!!

.!,"3+!Functions tab
"!!"K0!!"",
>!>+,
!!!"3
6@!"3+Calc Guide Chapter
7 Formulas and Functions.
44 | Using formulas and functions
Figure 39: Function Wizard with Search Bar
24
!!,!!!!3+
+!!!+,
!" !,"!
!!!!!!+"
!!+!!+,
!+0K+ !!
,!!:!
Calc Guide Chapter 9 Data Analysis!,!!!
!3

!!!3Pivot Table
.,!"3+!+3!0
"!!!!""K
@@,@@
6>!+!:,!,
,+!"
!!! !+!!!
!!,!
.!,!+!,!"!"03

Pivot tables and pivot charts | 45
Figure 40: Pivot Table dialog with raw data and results
,!!+9! :! !
8 ',!!"!!!!!!
,"Available Fields!> 6
+column, row, or page fields3
!B,"!
"!+!!>+@!0
">,!>1"
6@>!,!+Calc Guide Chapter 8 Pivot Tables

K0,!,!+Pivot Chart

6!!+,!!!>"0 6+
,!!+,"!!I!!!!!" 
!Field ButtonsG!!!!"!
,!",!+"!@,,
!,
6',!+Calc Guide Chapter 3 Charts
and GraphsCalc Guide Chapter 8 Pivot Tables

'!(Chapter
10 Printing, Exporting, and Emailing* 4",+!!
+!!
46 | Printing

',,!+!!
!"!, 6+
Calc Guide Chapter 6 Printing, Exporting, and E-mailing
Defining a print range
">)
* !!!!
* !A!:8"'0!!

-* 0+!8!0
 "!!!!!
Adding to a print range
.+!! 
!!"!!+"!"!
* .+!>!!
* !A!28>!!
 0!!!
-* 0+!8!0
 "!!!

!"!!+,

Removing a print range
C,+>!+"!
!
,!!+!A!A8
.,,+!0!"!!
Editing a print range
.+!+>!,3
 !A!181A
!"

!+!+!"
)
* !8'!!(6/*
* !0!,!!
-* !0B"
6+Calc Guide Chapter 6 Printing, Exporting, and
E-mailing
Printing options | 47
Figure 41: Page Style dialog
A
C!!+"!
 6>!+"""!!!.
!!+!!")
* !A!18<'2!
(6/*
* "Rows to repeat> 6>!+"+
I*=I# !!Rows to repeat JKKJJKKKJ
-* !Columns to repeat> 6>!+!.+
I2 CColumns to repeat!+@UU@@UKU@
/* !0B
6+Calc Guide Chapter 6 Printing, Exporting,
and E-mailing
Figure 42: Edit Print Ranges dialog

7!"!!+!!
I!!!manual or page break .0!
!3 #
3!0,,!0!,!!
48 | Printing
6!0+Calc Guide Chapter 6 Printing, Exporting, and
E-mailing
Inserting a break
0)
* %,!!"0"!!
* 9!88
-* !A80,!!!
!80!!!!
Deleting a page break
,0)
* %,!!>0",
* 1!:88
-* !A88

8!!!"!0> 7"
,+,,0,!!
3
4>
" 4 
6+Calc Guide Chapter 6
Printing, Exporting, and E-mailing
4!! #!
!" 6
!+Calc Guide Chapter 4 Using Styles and Templates
Setting a header or footer
)
* %,"
* !8!(6/-*
-* '!!+!3
/* !3
D* !7"
!!
=* ++ #!!2
>!!I
A* +!06
0!
* +>!++
+!01!!
Headers and footers | 49
Figure 43: Header page of Page Style dialog
50 | Printing