Datasheet

400
Index
formulas
creating, 182–183
editing, 183
overview, 180–181
function elements, 186
functions
applying, 188–189
editing, 189
help with, 189
overview, 186–187
types of, 186–187
G
grammar checking, 118–119
gridlines
adding, 206
overview, 149
printing worksheets with, 165
H
handouts, creating, 259
headers (Word), 100–101
help (Office), 12–13
I
icons shortcut, 5
images
adding
effects, 38
to PowerPoint slides, 238–239
to publications, 354–355
artistic effects, 41
color adjustments, 40
compressing, 31
correcting, 39
cropping, 36–37
inserting, 30–31
pasting into OneNote, 380
undoing changes, 31
index
customizing layout, 109
editing entries, 109
generating, 108–109
marking entries, 106–107
Insert dialog box (Excel), 155
Instant Search feature (Outlook), 326
J
junk e-mail, 340–341
K
keyboard
selecting
cells with, 137
text with, 23
zooming with, 351
L
layout
chart, 202
slide, 221–223
leader tabs (Word), 79
line spacing
PowerPoint, 231
Word, 75
lists, creating, 82–83
fields
adding to tables, 276
hiding in tables, 278
moving
fields in forms, 283
fields in tables, 279
overview, 267
removing
from custom reports, 305
from forms, 277, 284
from tables, 269, 277, 284
renaming, 273
file attachments, sending, 330
File tab menu, 6
files
attaching to notes, 381
browsing help, 13
closing, 19
creating
in Office, 14–15
in Office Live Workspace, 50–51
deleting from Office Live Workspace, 57
editing in Office Live Workspace, 52–53
formats, 17
opening, 18–19
printing, 20–21
saving, 16–17
searching for, 19
uploading to Office Live Workspace, 48–49
viewing
earlier versions, 53
multiple, 26–27
Fill Effects dialog box (Publisher), 369
Filters (Excel), 173
Folder list (Outlook), 324–325
font
changing
Excel, 144
PowerPoint, 226
Publisher, 356
Word, 70
chart text, 205
Font dialog box (Word), 73
footers (Word), 100–101
footnotes (Word), 102–103
formatting
applying, 71, 227
chart, 237
clearing, 85
conditional, 152–153, 298–299
copying, 84
number, 146
removing from cells, 161
retaining in slides, 247
text, 357
forms
adding records to, 288–289
changing views, 282
creating, 280–281
deleting
fields in, 284
overview, 281
records from, 293
editing records in, 289
moving fields in, 283
navigating records in, 290
overview, 267
searching for records in, 291
Formula bar, 7
34_571941-bindex.indd 40034_571941-bindex.indd 400 4/9/10 7:47 PM4/9/10 7:47 PM