Datasheet

379379
Index
Fill Series command (AutoFill feature),
73, 75
Fill tab (Format Cells dialog box), 113
Fill without Formatting command (AutoFill
feature), 73
 lter buttons, pivot table, 272–273, 275–276
 ltering
AutoFilter feature, 337–341
column  eld, 274–275
custom, 336–340
data list record, 333–340
date  lter, 336
number  lter, 335–336
operators used in, 337–338
pivot chart, 281–282
report, 273–274
row  eld, 274–275
Find and Replace dialog box
closing, 222
Comments option, 219
Find Next button, 217, 220, 222
Find What option, 217
Format button, 219
Match Case option, 218, 221
Match Entire Cell Contents option, 218,
221
No Format Set button, 219
Options button, 217
Preview button, 219
Replace All button, 221
Replace button, 222
Replace With option, 221
First tab scroll button, 231
Fixed Decimal feature, 57–59
font
bold, 126
color, 127
comment, 213
default, 125
effect, 126
footer, 193
header, 193
italicized, 126
selection, 125–126
size, 42, 125–126
strikethrough, 126
style, 126
theme, 314
underlined, 126
Font button, 109
Font Color button, 110
Font group (Home tab), 108–110
Font Size button, 109
Font tab (Format Cells dialog box), 113
footer
alignment, 189, 192
auto, 189–191
centered, 189–190
custom, 191–193
date, 192
even and odd page, 195
 lename, 193
 rst-page, 194
font, 193
page number, 192
picture, 192
text, 193
uses for, 189
worksheet name, 193
Form button, 321–322
Format As Table feature, 105, 366. See also
Table gallery
Format Axis dialog box, 296–297
Format button (Find and Replace dialog
box), 219
Format Cells dialog box, 112–113, 219
Format menu command, Excel 2003 and
2010 equivalent, 36–37
Format Painter feature, 112, 139–140
Format Picture button, 192
Formats option (Paste Special dialog
box), 166
formatting
chart, 294–297
clearing all, 167
conditional, 140–143, 365
Fill Formatting Only command, 73
Formulas & Number Formatting (O)
option, 163
from Home tab, 107–111
Keep Source Formatting (K) option, 163
with mini-toolbar feature, 111–112
pivot chart, 282
pivot table, 271–273
pivot table value, 272–273
SmartArt graphic, 312–313
text box, 300–301
25_489536-bindex.indd 37925_489536-bindex.indd 379 3/23/10 7:56 PM3/23/10 7:56 PM