headers/footers in documents.
See also footers in slides
centering text in, 189
closing, 190, 216
different first page, 216
editing, 216
hiding, 54
inserting, 188
moving to, 189
navigating between, 188
overview of, 183
settings inheritance, 183, 216
headers, column and row
changing formatting with, 312
displaying unique values, 359, 360
filter arrow in, 351
and SUBTOTAL function, 356
headers, e-mail
Attached box, 616
icons in, 618
information in, 618
headers, slide
adding to notes pages, 499
editing before printing, 493
headings, document, 51
height, row, 237, 806
Help button, xxv, xxxiii, 8, 751
Help, on Office Online Web site, xxvii, xxxv
Help page (OneNote Backstage view), 525
Help page (Word), 16
Help window
closing, xxviii, xxxvi
displaying, 8
navigating, xxviii, xxxvi
opening, xxvi, xxxiii, xxxiv
printing from, xxix, xxxvii
searching in, xxviii, xxxvi
showing all of topics, xxix, xxxvii
table of contents, displaying, xxvii, xxxv
topics, displaying, xxvii, xxxv
help with book, xxv, xxxiii
hidden characters, displaying, 53
hidden formatting marks, displaying, 68
hidden rows, ignoring in AGGREGATE function, 358
hidden text, clearing before distributing
document, 219
hidden worksheets, displaying, 234, 236
hiding
author names in OneNote, 548
columns, 238-239, 806-807
Document Properties panel, 230
fields, 806
formatting marks, 149
formula bar, 249
headers/footers in Word, 54
labels, 249
Mini Toolbar in Word, 18
non-printing characters, 56
ribbon, 59, 249
ribbon commands, 751
rows, 238
subdatasheets, 764
text, 53
tracer arrows, 302, 305-306
worksheets, 234-235
hierarchy diagrams, 454
highlighting during presentations, 509
highlighting objects. See selecting
highlighting text. See also selecting text
color selection for, 117
removing highlighting, 118
holidays, adding to calendar, 686
Home tab, 6
Home tab (Access), 753-754
Home tab (OneNote), 519
Home tab (Word), 10
horizontal scroll bar, 47
hyperlinks, 426
hyphenating text in columns, 141, 145
Hyphenation button (Word), 145I
icon sets
in Excel, 335
rules, changing, 335, 337
ID field, 809
IF function, 296-297, 299, 360
IFERROR function, 297
ignoring errors, 302
IM. See instant messages
images (Excel)
attributes, changing, 340
background, 341-344
borders, adding, 340
moving, 343
position, changing, 340
resizing, 340, 343
shape, changing, 340
worksheets, adding to, 339, 342
images (OneNote)
attaching to files, 575
displaying ScreenTips, 576
inserting, 568, 572-574
opening, 576
resizing, 569
scaling, 568
images (Outlook), resizing1002 headers/footers in documents