formatting (continued)
previewing, 10
retaining for reused slides , 378
row, changing, 312
searching for, 265, 267
shapes, 471, 478, 931-933
Special formats, 328
tables, 160
text, 901
text boxes, 900
time, in cells, 319
tools for, 311-312
WordArt, 912
formatting marks
displaying, 56
keyboard shortcut for, 68
section break indicator, 214, 216
showing/hiding, 68, 149
forms
aligning labels in, 838
basing on tables, 824
bound to tables, 829
control source, 829
creating, , 822, 824, 768
customizing layout, 837
default layout, 837
entering data in, 826
filtering records in, 851
filtering records with, 855-857
font size, changing, 831
font weight, changing, 833
in Layout view, 824, 830, 837
label captions, changing, 836
layout, removing, 841
Layout view, switching to, 838
margins, setting, 840
navigating, 825, 827-828
opening, 768
overview of, 768
printing, 786
properties in, 829, 832
Property Sheet, displaying, 832
record source, 829
saving, 828, 836
selecting all controls on, 834
selecting columns in, 838
shadow effects, 835
sorting records in, 846
Stacked layout, 837
subforms, 768
synchronizing with tables, 828
tabular layout, 837
viewing list of, 768
views for, 768, 771
tab order, changing, 842
for Web databases, 822
Form view, 768, 771, 825
Form View button, 825
Formula AutoComplete, 288, 295-296
formula bar
changing data in, 266
contents of, 260
Excel display font, changing, 313, 315
hiding, 249
formula box
editing formulas in, 286
phone numbers in, 328
Formula button (Word), 158
Formula dialog box (Word), 158
formulas, Excel
absolute references in, 307
conditional, 296
contiguous cells in, 290
copying and pasting, 291, 294
creating, 286, 288, 295
defined, 286
details, displaying, 303
displaying messages with, 296
editing, 286
entering ranges in, 295
equal sign (=) in, 286
erroneously treated as text, 286
errors. See errors, Excel
examining, 303, 306
Excel tables in, 289, 293, 295
in Excel tables, 276, 277
Formula AutoComplete, 288, 295-296
functions in, 286
ignoring values in, 357
making ranges available for, 282
multiple worksheets and, 243
noncontiguous cells in, 290
ranges in, 282, 288
relative references in, 291, 307
revising, 286
searching in, 266
square brackets in, 289
troubleshooting, 286
unrecognized text in, 301
formulas, Word, 158
constructing, 158
referencing cells in, 158
Forward button, 57, 639, 711, 733
forwarding e-mail messages
closing original message after, 635
prefix used by Outlook for, 6391000 formatting marks