User Guide

248 Index
dening rules 80
using 80
cropping 194
CSV format 235
currency format 90
custom cell formats
changing 109
date/time format 107
managing 110
number format 99
text format 108
using 98
custom date/time format 107
custom number formats
associating conditions with 105
creating 99
dening the decimals element 102
dening the integers element 101
dening the scale element 103
custom templates
creating 241
creating initial content 244
creating media placeholders 245
dening default chart attributes 243
dening default image attributes 244
dening default text boxes and shapes 243
dening reusable tables 242
dening table styles 242
predening sheets 245
predening tables and other objects 244
saving 246
setting up a document to use 246
custom text format 108
D
data series 132
data set 132
date and time format 92
document. See spreadsheets
document design. See custom templates
Document inspector 31, 35, 40
duration format 93
E
error bars 148
Excel format 235
exporting a spreadsheet
as a CSV le 235
as an Excel le 235
as a PDF le 234
in iWork ’08 format 33
to iWeb 239
F
le size
reducing the size of images 195
reducing the size of movies 209
ltering rows 65
nding and replacing
formula elements 130
text 189
Fonts window 25
footer rows 61
format bar 18
formatting tables
adding images or color to table cells 83
alternating row colors 62
formatting table cell borders 84
formatting table cell values 86
using table styles 49
formatting text 163, 17 0
adding accent marks 167
font smoothing 166
formula bar 12 0
Formula Editor 119
formula tools 20
formulas
adding a quick formula 11 7
adding to multiple cells 78
copying and moving 12 8
creating 11 8
deleting 12 3
elements of 11 5
nding and replacing elements of 130
handling errors and warnings 12 3
inserting cell references 12 5
performing instant calculations 116
referring to cells in 123
using arithmetic operators 12 7
using comparison operators 127
using the formula bar 12 0
using the Formula Editor 119
using the Function Browser 121
viewing all in a spreadsheet 12 9
See also functions; operators
fraction format 93
freezing header rows and header columns 60
Function Browser 121
See also functions
functions
adding to formulas 121
See also formulas
G
Graphic inspector 47
H
header rows and columns
adding 59
freezing 60
keeping visible as you scroll 60