Datasheet

355
encrypting, 274–275
junk, 288–289
recalling, 276–277
rules, 282–285
sending publications as, 322–323
viewing archived, 292–293
encryption, 32–33, 274–275
endnotes, 84–85
equations, 174
errors, auditing worksheets for, 116–117
Excel (Microsoft)
adding background color/patterns/images, 142–143
applying workbook themes, 136–137
auditing worksheets for errors, 116–117
AutoFill feature, 102–103
AutoFilter feature, 131
borders, 140–141
Calculator tool, 114–115
center-aligning printed data, 154
centering text across merged cells, 155
changing cell text orientation, 153
changing default font, 17
changing gridline colors, 138
chart objects, 146–147
color-code worksheet tabs, 104
conditional formatting, 144–145
creating database tables, 126–127
creating projections, 118–119
data forms, 128–129
data-validation rules, 132–133
establishing what-if scenarios, 120–121
exporting data from Access to, 219
freezing headings, 111
generating random numbers in cells, 110
Goal Seek feature, 122–123
importing data to Access from, 218–221
inserting comments in formulas, 112
joining text from separate cells, 113
naming worksheet tabs, 105
opening workbooks, 100–101
printing gridlines, 139
protecting cells, 108–109
Solver feature, 124–125
Sort dialog box, 130
Sparklines, 150–151
trendlines, 148–149
Watch windows, 106–107
wrapping text, 152
Expression Builder (Access), 232–233
F
fields (Access), 227–228
file formats, 23, 25, 206
files. See also documents
Access, 234–235
assigning passwords, 33
changing default save location, 22–23
media, 180–181
Office, 26–27
text, 316
fill patterns, 142
filler text, 76
Filter Query (Access), 239
filters, saving as queries in Access, 238–239
fonts, changing default, 16–17
footer building blocks, 44–45
footnotes, 84–85
formatting, 47, 143–145, 258–259
forms, 252–255
formulas, 112
G
Goal Seek feature (Excel), 122–123
graphics
adding captions, 344–345
adding custom watermarks, 348–349
assigning artistic effects to pictures, 336–337
clip art, 330–331
grouping objects, 340–341
online clip art, 332–333
ordering objects, 338–339
overview, 326
Picture Manager, 352–353
removing image backgrounds, 334–335
Screenshot, 328–329
turning WordArt objects into picture files, 346–347
Ungroup command, 342–343
wrapping text around, 350–351
gridlines, 138–139
growth trends, 119
H
handouts, 179
header building blocks, 44–45
headings, freezing in Excel, 111
hyperlinks, 95, 172–173
hyphenation in publications, 320–321
I
iCalendar file format, 307
images, 142, 334–335. See also pictures
Import Spreadsheet Wizard, 218–221
indexes, 90–93
input masks, 230–231
items (Outlook), 304–305
J
junk e-mail, 288–289
L
ligatures, 17
line numbers, 96–97
line spacing, 66–67
linear trends, 118
M
macros, 14–15, 248–249
mailing labels, 246–247
Map It feature (Outlook), 302–303
media files, compressing, 180–181
metadata, 30
Microsoft Clip Organizer, 330–333
17_577752-bindex.indd 35517_577752-bindex.indd 355 5/17/10 1:11 PM5/17/10 1:11 PM