User Guide

250 Index
adding 42, 186
formatting 186
inserting 186
See also headers and footers
page orientation (portrait and landscape) 42
password protection
for a PDF of a spreadsheet 234
for a spreadsheet 31
PDF format 234
percentage format 91
picture frames 219
pie charts 151
polygon shape 205
pop-up menus. See cell controls
Print View 17
printing
all sheets 233
arranging objects on a page 41
list of formulas 233
numbering pages 42
Print View 39
setting page margins 43
setting page orientation 42
setting page size 40
setting pagination order 42
the current sheet 233
using headers and footers 41
Q
quick formulas 11 7
quote bubble shape 204
R
reference tabs 47
relative cell references 12 6
Reorganize window 64, 65, 69, 72
reusable tables. See tables
rounded rectangle shape 203
rows
adding 56
alternating colors for banded eect 62
categorizing 66
deleting 58
ltering 65
hiding 63
rearranging 58
resizing 62
sorting 64
See also tables
S
saving
a copy of a spreadsheet 35
an automatic backup version 34
as an Excel document 33
as an iWork ’08 document 33
as a template 34
Spotlight search terms 35
with media les 33
scatter charts 15 7
scientic format 95
searching for formulas. See nding and replacing
shapes
adding custom 199
adding predrawn 198
adding text in 183
editing 200
reshaping curves 202
sharing spreadsheets
by email 239
by exporting in CSV format 235
by exporting in Excel format 235
by exporting in PDF format 234
by printing 233
using iWeb 239
Sheet inspector 38, 40, 41, 42, 43
sheets
adding and deleting 37
naming 38
paginating 39
reorganizing 37
Sheets pane 36
showing and hiding 36
using to organize a spreadsheet 36
smart quotes 169
sorting rows 64
sound
adding 206
adjusting playback settings 208
le types supported 206
reducing le size 209
spell checking 187, 188
spilling 79
splitting table cells 84
Spotlight 35
spreadsheets
adding CSV data 30
creating by importing 29
creating from a template 28
nding and replacing formula elements 130
opening 30
organizing using sheets 36
paginating 39
password-protecting 31
saving 32
undoing changes 34
viewing all formulas in 12 9
star shape 205
steppers. See cell controls
Styles pane 21