Calc Guide

options 408
recording 327
reviewing 332
viewing 333
chart
appearance of 3D 89
area 79
area background 86
colors 87
creating 73
data labels 80, 92
editing 78
formatting 84
formatting 3D 87
graphic background 87
grids 78
illumination of 3D 89
interactive 3D rotation 90
mean value lines 83
moving elements 86
perspective 88
Position and Size dialog 94
resizing 93
rotation 88
titles 78
trend lines 82
types 95
wall 79
Y error bars 83
chart elements 79
chart type 75, 79
Chart Wizard 74
collaboration 323
color coding for input 207
color options 391
Color toolbar 139
column and line charts 103
column charts 95
columns
deleting 31
freezing 34
hiding and showing 63
inserting 30
selecting 29
comma separated values (CSV) 18, 22
comments
adding 330
editing 331
finding 332
formatting 332
comments on changes
adding 329
editing 330
comparative operators 183
comparing documents 337
concatenation operator 188
consolidating data 272
create document from template 119
creating new spreadsheets 16
cropping 140
CSV files 18, 22
custom sort order 67
customizing
Enter key 26
keyboard shortcuts 416
menus 410
toolbars 414
D
dashes, entering 44
data analysis
consolidating data 272
DataPilot 219
Goal Seek 288
introduction 272
Multiple Operations tool 281
scenarios 277
Solver 290
subtotals 275
data entry
keyboard 42
speeding up 45
data labels on charts 80, 92
data ranges 76
data series 77
data source
data to text 315
editing 314
editing using Base 315
linking 312
registering 312
using in OOo documents 315
viewing 314
data to text 315
database functions 466
database range 364
DataPilot
cell formatting 262
change layout 253
data fields 248
data source 243
Index 491