|
|
|
|
|
|
|
|
|
|
|
| Microsoft® Office XP Inside Out |
|
|
|
|||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||
Index
Note to the reader: Italicized page numbers refer to figures, tables, and illustrations.
Symbols and numbers
= (equal sign), 616, 733
3-D charts, 757, 766, 766, 771, 771
35mm slides, 937–38
A
absolute cell references, 737Accept Or Reject Changes dialog box, 703, 703
Access program. See Microsoft Access
accounts, 1093–1100
address book, 1096, 1099
defining for profiles, 1100
directory, 1093–94, 1099
e-mail, 1026–28, 1093, 1096–99
action buttons, 932–34, 932, 933
running other programs with, 934
using in electronic presentations, 944
action queries, 1330–32
Action Settings dialog box, 934, 934
Actions menu, Outlook program, 984, 984
activating Office XP, 26–27
ActiveX controls, 1251
Add Clips To Organizer dialog box, 117, 124
Add Constraint dialog box, 814, 814
adding. See also inserting
address book accounts, 1099
borders to text boxes, 1398–99, 1399
borders to worksheet cells, 661–63
buttons to toolbars, 49–50, 210–11, 216, 216
commands to menus or toolbars, 210–11
constraints to Solver problems, 814, 815
contents to tables, 341
database fields, 1281–82
directory accounts, 1099
e-mail accounts, 1096–97, 1098
forms to Web pages, 592–94
graphics to worksheets, 618–19
gridlines to charts, 770
hyperlinks to Word documents, 583–86
labels and arrows to charts, 772–74
members to distribution lists, 1063–64
menus to the menu bar, 211
movie clips to Web pages, 589–90
page numbers to documents, 521–22
pictures to tables, 900
rows/columns to tables, 342–44, 342, 343
rows/columns to worksheets, 640
shading to worksheet cells, 664–65
shortcuts to the Outlook Bar, 1090–92
smart tags to documents, 266
sounds to Web pages, 590–91
subtotals to lists, 791–92, 793
templates to the AutoContent Wizard, 853
text to documents, 245–46
text to organization charts, 136
text to Web pages, 1172–73
Web page components, 595–96
words to custom dictionaries, 483, 484–86
Add-Ins dialog box, 731, 731
add-in utilities
Excel program, 730–31, 810–18
Word program, 413–14
Add New Member dialog box, 1064, 1064
Add Object dialog box, 1408, 1408
Add Or Remove Buttons command, 216
Address bar, 1086
address book accounts, 1096, 1099
Address Book dialog box, 1094, 1094
Address Cards view, Outlook program, 1000, 1001
addresses
directory accounts for looking up, 1093–94, 1094
obtaining from Outlook program, 564
troubleshooting address lookups, 1095
Addressing dialog box, 1095, 1095
Add Scenario dialog box, 820, 821
Add To Outlook Bar dialog box, 1090, 1091
Add View dialog box, 714, 714
administrative installation point, 23
Administrative Installation Setup dialog box, 23
adult e-mail messages, 1038, 1039
advanced controls, 1250–52, 1251
Advanced E-Mail Options dialog box, 1022, 1022
Advanced Filter/Sort command, 1310
Advanced Find dialog box, 1011–13, 1012
Advanced Search task pane, 71–73
Advanced toolbar, Outlook program, 976, 977, 977
agenda slides, 869
aliases, for styles, 393
alignment
of cells in Excel worksheets, 650–54
of cells in Word tables, 349, 349
of form controls in Access databases, 1349
of images in Web pages, 1215, 1217
of objects with text, 1436
of page numbers in Word documents, 521
of paragraphs in Web pages, 1201–2
of paragraphs in Word documents, 311
of pictures in brochures, 1422
of text in PowerPoint presentations, 883–84
Alignment tab, Format Cells dialog box, 650–54, 651
all-day events, 1040
All Files report, 1152
Allow Background Saves option, 242
Allow Fast Saves option, 242
analysis
business analysis tools, 807–24
financial, with functions, 744–48
of lists in Excel, 791–94
animations, 919, 920–31
adding to Web pages, 1454–55
applying to slide shows, 920–21
customizing, 921–23
diagram and chart, 923–25, 925
motion paths for, 925–28, 926, 927, 928
text, 301
timing controls for, 928–29, 928
transitions applied to, 930–31
troubleshooting, 922, 1455
Animation Schemes task pane, 920
ANSI codes, for currency symbols, 658
Answer Wizard tab, Help window, 34, 35–36, 36
antonyms, 495
append query, 1331
applications. See also names of specific applications
accessing document libraries from, 189–91
common features in Office XP, 4–6
help resources, 29–39
integration features, 6
new document files, 58
opening documents within, 67–69
running, 43–46
Appointment form, 1040–42, 1041
Appointment Recurrence dialog box, 1045, 1045
appointments
categories for, 1043, 1043, 1044
color-coding, 1042–43, 1043
converting to meetings, 1050
defined, 1040
one-time, 1040–44
online, 1042
privacy option, 1044
recurring, 1044–45, 1045
scheduling in Outlook, 1040–45
setting up with contacts, 1067
troubleshooting, 1044
archiving Outlook items
automatically, 997–98, 998
manually, 998–99, 999
recovering archived items, 999
arguments
Excel program, 740–41
Visual Basic, 1496
arithmetic operators, 738, 738, 739
Arrange dialog box, 692, 692
arrows, adding to charts, 772–74
artwork. See also graphics; pictures
adding to worksheets, 618–19
ascending sort, 381, 784
Ask A Question list, 33–34, 34
assigned tasks
converting personal tasks to, 1072
defining in Outlook, 1072–74
storing copies of, 1073
Assigned To report, 1153
assigning
commands to shortcut keys, 217–19
datatypes to database fields, 1284, 1285–86
keywords to media clips, 125
keywords to Web pages, 1457–59
styles to shortcut keys, 218
tasks to contacts, 1067, 1072–74
templates to document libraries, 203
Assistant feature, 29–33, 30, 31
as-you-type option
grammar checker, 487–89
spelling checker, 476–78
attachments
opening, 1025
troubleshooting, 996
audio clips. See sounds
AutoArchive feature, 997–98, 998
AutoCalculate box, 604
AutoComplete feature
Excel program, 612, 779
Word program, 254, 255
AutoContent Wizard
adding templates to, 853
creating PowerPoint presentations with, 851–53, 852, 853
AutoCorrect dialog box
AutoCorrect tab, 258–60, 259, 872, 872
AutoFormat As You Type tab, 336, 336, 861, 862
AutoFormat tab, 334, 335
AutoText tab, 255–57, 257
Smart Tags tab, 263–64, 264
AutoCorrect Exceptions dialog box, 260–61, 260
AutoCorrect feature, 11, 258–63
defining exceptions, 260–61
disabling, 266
enabling in Word, 258–60
modifying corrections, 262
PowerPoint presentations, 871–72
spelling corrections, 263
AutoCorrect Options button, 11, 262
AutoFill feature, 642–44, 642
insertion patterns, 643
replicating formulas with, 736
suppressing, 642
AutoFilter command, 788–91
AutoFit command
Excel program, 668
Word program, 347–48, 347
AutoFormat As You Type feature, 336, 336
AutoFormat dialog box, 334, 335
AutoFormat feature
Excel program, 668–69, 669, 803
Word program, 334, 335
AutoLayout option, 137
automatic archiving, 997–98
automatic formatting features, 334–37
disabling, 266
smart tags, 861
troubleshooting, 331
automatic hyphenation, 499–501
automatic language detection, 506–7
Automatic Name Checking option, 1094
automatic page numbering, 520, 521–23
automatic save feature, 75, 1274
AutoPreview feature, 1010
AutoRecover feature, 75
AutoReport feature, 1362
AutoRepublish feature, 830
AutoShapes
inserting, 132–34
restrictions on modifying, 137
setting defaults for, 155
shortcut menu for, 158–59
transforming, 154
troubleshooting in Word, 135
AutoShapes toolbar, 132–34, 132
AutoSum button, 741, 741
AutoTable macro, 1515–17
AutoText feature, 252–58, 253, 254
AutoText toolbar, 257–58, 257
AVERAGE function, 743–44
B
Background dialog box, 887–88, 888background graphics
applying to Web pages, 597
custom, 890–92
fill effects, 888, 889
modifying in FrontPage, 1220
modifying in PowerPoint, 886–92
modifying in Publisher, 1456
saving, 889–90
troubleshooting, 597
Background Sound dialog box, 591, 591
background sounds
adding to Web pages, 590–91, 1453–54
troubleshooting, 592
Background task pane, 1453, 1453
backing up
Outlook data files, 1101
Web page files, 578
workbook files, 625
Balloon Indicator, Language Bar, 97, 97
Basic Search task pane, 70–71
Bcc text box, 1035
binding, creating margins for, 540, 540
bitmapped images, 1420
blank presentation templates, 855
body text
hiding on pages, 529
Outline view, 416, 423
Body Text style, 329
Book Fold option, 539
Bookmark dialog box, 289–90, 290
bookmarks, defining in Word, 289–90
books and booklets
creating in Word, 543
page setup for, 539–40
Boolean operators, 1318
borders
document, 359–61, 362–63, 547
instant, 662–63
modifying, 361
page, 365–66, 547
paragraph, 1201, 1204–6
removing, 361
shared, 1178, 1189–93
table, 340, 357, 358–64, 358–59
text box, 1398–99, 1399
uses for, 356–58, 357
Web page, 1204–6
worksheet cell, 661–63
Borders And Shading dialog box, 361–64
Borders tab, 362–63, 362, 1205, 1205
Horizontal Line button, 587
Page Border tab, 365–66, 365
Shading tab, 364, 364, 1205, 1206
Border And Shading Options dialog box, 366, 366
Borders toolbar, 663, 663
Border tab, Format Cells dialog box, 661–63, 661
bound controls, 1340–41
Break dialog box
FrontPage program, 1172–73, 1172
Word program, 524–25, 524
broadcasting slide presentations, 957–60
conducting a broadcast, 959–60
scheduling a broadcast, 957–58
troubleshooting problems with, 959
viewing a broadcast, 960
Broadcast Presentation dialog box, 959–60, 960
Broadcast Settings dialog box, 958, 958
brochures, 1412–29
aligning objects in, 1422
color fill effects in, 1415–18
color schemes for, 1413–15
creating from scratch, 1413
cropping pictures in, 1421
formatting drop caps in, 1424–26, 1426
grouping objects in, 1424, 1424
horizontal rules in, 1428–29, 1428
inserting pictures into, 1418
layering frames in, 1422–23, 1423
line breaks and hyphenation in, 1429–30
linking to picture files, 1418–19, 1419
moving pictures in, 1419, 1419
resizing pictures in, 1420
using typographic symbols in, 1426–28
broken hyperlinks, 1148–49
fixing, 1158
status report on, 1153, 1156–58, 1156
verifying, 1157, 1158
Broken Hyperlinks report, 1153, 1156–58, 1156
browse buttons, 234, 294–95, 294
browse objects, 286, 293, 294–95
browsers. See Web browsers
built-in functions, 739–44
built-in styles, 325, 326, 386
deleting, 399
document elements, 387
bulleted lists
converting to outlines, 378
PowerPoint presentations, 879–82
Publisher documents, 1396–97
Web pages, 1202–3
Word documents, 313, 372, 374–75, 374
Bullets And Numbering dialog box (FrontPage program)
Numbers tab, 1204, 1204
Picture Bullets tab, 1202–2, 1203
Plain Bullets tab, 1203, 1203
Bullets And Numbering dialog box (PowerPoint program)
Bulleted tab, 880, 880
Customize option, 882
Picture option, 880–81, 881
Bullets And Numbering dialog box (Word program)
Bulleted tab, 374–75, 374
List Styles tab, 379–80, 379
Numbered tab, 375–76, 375
Outline Numbered tab, 376–77, 376
business analysis tools, 807–24
Goal Seek command, 807–10
Scenario Manager, 818–24
Solver utility, 808–18
buttons
adding to toolbars, 49–50, 210–11, 216, 216
modifying on toolbars, 212, 212–14
removing from toolbars, 211, 216, 216
sizing, 604
Buttons tab, Customize dialog box, 49, 49
By Category view, Outlook program, 1000, 1001
C
calculated fields, 1325–27, 1327calculations. See also formulas; functions
controlling in Excel, 727–28
macros for performing, 1501–4
performed by Access databases, 1264, 1325–26, 1327
Calendar folder
Day/Week/Month view in, 1053, 1053
planning meetings in, 1046–52
publishing calendars on the Web, 1054
reminder feature in, 1042, 1054, 1054, 1055
scheduling appointments in, 1040–45
setting up events in, 1045–46
working with, 1052–55
Calendar Options dialog box, 1049, 1050, 1052, 1054–55
Caption property, 1289
captions, 435
cascading style sheet (CSS) styles, 1230–34
embedded, 1231–32
external, 1232–33
inline, 1230–31
troubleshooting, 1233–34
Categories dialog box, 1043, 1043
Categories report, 1153
category assignments
appointments, 1043, 1043, 1044
contacts, 1061, 1061, 1064
journal entries, 1081
notes, 1083–84
tasks, 1070
Category axis, 757
CD audio tracks, using in slide presentations, 917–18
CD installation of Office XP, 19–23
cell comments, 722
cell names, 605, 812
cell pointers, 606, 607
cell references, 617–18, 617, 737
cells (Excel worksheets), 605
aligning information in, 650–54
borders added to, 661–63
character formatting in, 662
clearing and deleting, 630–31, 631
entering information into, 609–19
formatting, 650–65
formula replication and, 737
horizontal alignment of, 651–52, 653
hyperlinks added to, 619–23
inserting into rows or columns, 641
locking and unlocking, 707
moving with drag-and-drop technique, 639, 639, 640
naming, 749–52
selecting or highlighting, 606, 628–30
shading added to, 664–65
target, 811
text orientation options, 654
variable, 811
vertical alignment of, 653
cells (Word tables), 340
aligning text in, 349, 349
inserting, 342–44, 342, 343
numbering, 373
removing, 344, 345
reorienting text in, 349, 349
resizing, 345–48, 345, 346, 347
CenterHeading macro, 1488–90
Change Case dialog box, 275, 275
changes, tracking. See tracking document changes
Change Source dialog box, 171, 171
changing. See also modifying
icons on toolbars and menus, 214–15
levels in outlines, 418–20, 424
page breaks on worksheets, 679–81
text direction in text boxes, 515
wrapping styles in text boxes, 514
character codes, 250
character formatting. See also fonts
applying to Ink objects, 103–4
character spacing, 300–301, 1394–95
chart titles or labels, 768
directly applying, 298–99, 302
drop caps, 1424–26, 1426
Formatting toolbar for, 308, 308
individual characters in cells, 662
kerning, 301, 1213, 1394–95
methods for applying, 299–301
removing, 302, 326–28, 1213
revealing, 302
shortcut keys for, 308–9, 308–9
styles used for, 321, 323–26, 389
tracking, 1394–95
troubleshooting, 307, 1213
Web pages, 1210–13
character spacing, 300–301, 1394–95
Character Spacing dialog box, 1394–95, 1394
Chart Location dialog box, 762, 762
Chart menu, 765, 765
Chart Options dialog box, 770, 770
charts (Excel program), 753–75
adding labels and arrows to, 772–74
adjusting gridlines on, 770
animating, 923–25
automatic updating of, 764
changing the type of, 766
copying formats from, 772
creating, 757–64
editing titles and labels on, 767–69
elements in, 756–57, 757
embedded, 761–64
formatting, 764–72
freezing, 764
linking to PowerPoint slides, 904–5
modifying the legend in, 770–71
organizing worksheets for, 753, 754
planning, 753–57
printing, 774–75
reordering items on, 764
scalability of, 775
shading options for, 775
three-dimensional, 757, 766, 766, 771, 771
troubleshooting, 767, 775
types of, 754, 755, 766, 767
viewing angle of, 771
charts (Graph program), 144–46
documents containing, 144–45
forms containing, 1334
modifying, 146
opening in PowerPoint, 903, 904
reports containing, 1363
charts (PowerPoint program)
animating, 923–25
customizing, 904
drawing with Freeform tool, 906, 906
inserting into presentations, 902, 903–4
linking Excel charts to, 904–5
Chart Source Data dialog box, 761, 762
Chart toolbar, 765, 765
Chart Wizard
Access program, 1334, 1362
Excel program, 758–60, 758, 759, 761–63
Check Grammar With Spelling option, 481
Checkout Status report, 1154
child windows, 80
Choose Document command, 59
Clear Formatting command, 326–28
clearing. See also deleting; removing
cells, 630–31, 631
text formatting, 326–28
clip art
inserting into slides, 911
obtaining images, 910–11
Clipboard, 109–13
activating, 109–11
copying blocks into, 111
customizing, 112–13, 113
deleting blocks from, 112
enhancements made to, 109
moving and copying text using, 277–80
pasting blocks from, 111–12
setting options for, 280–81, 281
troubleshooting, 113
worksheet data and, 637–38
Clipboard icon, 112
Clipboard status display, 112
shortcut menu, 112–13, 113
Clipboard task pane, 53, 109–13, 110
displaying, 109, 112
troubleshooting, 113
viewing blocks in, 111
Clip Organizer, 4, 115–25
freestanding mode, 120–24
importing clips into, 124–25
movie clips added with, 591
pictures added with, 115–20
sounds added with, 591
storing graphic objects in, 909
views available in, 121–24, 121, 123
clips. See media clips
closing
databases, 1274
Excel program, 625
Outlook data files, 1105
Code window (Visual Basic)
Auto List feature, 1486
writing event procedures in, 1528–30
collapsing outline text, 422–25
Collection List view, Clip Organizer, 123, 123
collections, Visual Basic, 1484
color-coding
appointments, 1042–43, 1043
notes, 1084
Web components, 1256
worksheet tabs, 686, 686
color fill effects, 1415–18
color models, 1415–16
colors
background, 597
border, 359
change tracking, 449
chart, 774
font, 300, 660–61, 1211–12
presentation, 884–86
shading, 361, 361, 364
text highlighting, 465
color schemes
PowerPoint program, 884–86
Publisher program, 1413–15
Color Schemes dialog box, 1414, 1414
Color Schemes task pane, 1414, 1414
Colors dialog box
PowerPoint program, 885, 885
Publisher program, 1415–16, 1415, 1416
columnar reports, 1362
column breaks, 370, 371
column charts, 766, 766
columns. See also rows
adding to worksheets, 640
applying to documents, 366–71
cells inserted into, 641
creating in a text box, 1396
deleting in Access, 1301
hiding in Access databases, 1301
hiding in Excel worksheets, 667–68
inserting into tables, 342–44, 342, 343
instantly setting the width of, 667
modifying in Outlook, 1004, 1004, 1005
newspaper-style, 366–71
removing from tables, 344, 345
repeating headings on, 724
resizing in databases, 1300
resizing in tables, 345–47, 345, 346
resizing in worksheets, 665–68
selecting in worksheets, 630
sorting in worksheets, 783–88
specifying for tables, 340
Columns button, 367, 367
Columns dialog box
Publisher program, 1396, 1396
Word program, 368–69, 368
Column submenu commands, 667
CommandButton control, 1525
commands. See also names of specific commands
adding to menus or toolbars, 210–11
assigning to shortcut keys, 217–19
undoing in Excel, 633–34
voice command mode, 96–97, 96
Commands And Options dialog box, 835–36, 835
comments
adding to macros, 1471
deleting from documents, 462–63
displaying information about, 460
editing, 461
entering into Excel worksheets, 614–15, 614
entering into PowerPoint presentations, 870
entering into Word documents, 457–60
managing, 615
navigating through, 463–64
troubleshooting, 463, 464
viewing, 460–61
voice, 461–62
Web component, 1246
Comments command, 615, 615
Compare And Merge Documents dialog box, 456, 457
comparing documents, 456–57
comparison operators, 1309, 1309, 1506
Component Errors report, 1153
Component Object Model (COM) technology, 832
composing e-mail messages, 1030–32, 1032, 1033, 1034
compound documents, 162
compressing
pictures, 130
publication files, 1401
conceptual drawings, 135–41
conditional expressions, 1505–6, 1506
using logical operators in, 1510
conditional formatting, 669–72
finding conditional formats, 672
Conditional Formatting dialog box, 670–71, 671
configuring FrontPage editors, 1136
confirmation field, 1251
conflicts, shared workbook, 701–3
Consolidate dialog box, 695–96, 696
consolidating worksheets, 694–97, 696, 697
constants, Visual Basic, 1486–91
constraints, 811
Contact form
Activities tab, 1061, 1061
All Fields tab, 1062
Certificates tab, 1062
Details tab, 1062
General tab, 1058–60, 1058
Contact Options dialog box, 1068, 1068
contacts
category assignments for, 1061, 1061, 1064
communicating with, 1066–68
defining, 1057, 1058–62
importing from team Web sites, 1065
linking to related information, 1061
locating, 1066
marking as private, 1062
online meetings with, 1067
telephone calls to, 1067, 1081
viewing journal entries for, 1078
Contacts folder, 1057–69
address book accounts and, 1096
customizing, 1068, 1068
defining contacts in, 1057, 1058–62
distribution lists in, 1057–58, 1063–65
privacy options, 1062, 1064, 1065
using existing information in, 1058
Contents tab, Help window, 35, 35
controls (form)
bound, 1340, 1341
calculated, 1351
deleting, 1344
modifying, 1344, 1345–50
property sheets for, 1350, 1350, 1351
unbound, 1344
control structures, 1514
Conversion Wizard, 242–43, 243
converting
appointments to meetings, 1050
bulleted lists to outlines, 378
database objects to data access pages, 1358
documents, 62, 68, 76
embedded objects, 178
Excel lists into Access databases, 794–95
footnotes to/from endnotes, 434
groups of files, 242–43, 243
numbered lists to outlines, 378
personal tasks to assigned tasks, 1072
select queries to crosstab queries, 1329
styles with ConvertStyles macro, 1508–10
ConvertStyles macro, 1507, 1508–10
Convert Text dialog box, 163, 164, 1170–71, 1171
Convert To Web Layout option, 1441
Copy command
Excel program, 635–36
Word program, 278, 279, 279
copying
chart formats, 772
controlling list numbering, 378
database fields, 1283
database records, 1353–54
data between applications, 161–62, 163–65
footnotes and endnotes, 434
formatting in Excel, 665
formatting in PowerPoint, 879
form controls, 1349
graphic objects, 151
icons to commands, 215
items into the Clipboard, 111–12
macros, 410, 1502
Outlook items, 993–96
SharePoint lists, 200
styles, 403–4
table elements, 348, 350
text, 275–80
text boxes, 513–14
undoing, 996
Web page elements, 1170–71
worksheets, 688–89, 689
Copy Items dialog box, 994–95, 994
CopyParagraph macro, 1499–1500
Create Custom Dictionary dialog box, 484, 484
Create Names dialog box, 750, 750
Create New Folder dialog box, 1015–16, 1015
Create New From Existing Publication dialog box, 1387
Create New Style dialog box, 1433, 1433
Create page (SharePoint), 201, 201
Create Style By Example dialog box, 1431–32, 1431
Criteria button, Form command, 780, 780
cropping images, 130–31, 131
in FrontPage, 1220, 1220
in Publisher, 1421, 1421
cross-references in indexes, 437
crosstab queries, 1312, 1328–29, 1331
Crosstab Query Wizard, 1328–29
currency symbol, 658
Custom Animation task pane, 918, 922, 924, 928, 928
Custom AutoFilter dialog box, 790–91, 790
custom backgrounds, 890–92
custom design templates, 857
custom dictionaries, 483–86
activating, 484–85, 485
adding words to, 485–86, 485
creating, 483–84
language options, 486
modifying, 486
removing, 485
Custom Dictionaries dialog box, 484, 484
custom headers and footers, 719–21
Custom Installation Wizard, 23–25, 24, 25
Customize dialog box, 206–22
Buttons tab, 49, 49
Commands tab, 209–12, 210
Keyboard button, 217
Options tab, 219, 219–20, 220
Toolbars tab, 48, 48, 206–8, 207
Customize Keyboard dialog box, 217–19, 217, 1466, 1466
customizing
animation sequences, 921–23
application interface, 205–24
charts in PowerPoint, 904
Clipboard, 112–13, 113
Contacts folder, 1068, 1068
controls on Web forms, 594
data access pages, 1357, 1358–59, 1359
database tables, 1280–90
Datasheet view in Access, 1299–1302
Excel program, 711–31
forms, 594, 1339–54
grammar checker, 492–93
index entries, 438
menus, 205–6, 209–16
My Places bar, 65–67
Office Shortcut Bar, 48–50
Outlook program, 1002–3, 1089–1105
pivot charts, 804, 805
restoring customized settings, 222–24
SharePoint team Web sites, 200–204
shortcut keys, 205–6, 217–19
sort order, 787–88
speech recognition feature, 97–101
spelling checker, 482, 482–83
styles, 385–99
tables, 1280–90
tables of contents, 441
templates, 408–10
toolbars, 205–6, 209–16
custom labels, 568–69
custom lists, 184
custom motion paths, 926–27, 927
custom number formats, 657–58, 659
Custom Shows dialog box, 942, 942
Custom tab, Properties dialog box, 84–85, 84
custom templates
creating, 56
saving, 56–57
custom themes, 1228
custom toolbars
creating, 206–8
deleting, 208
modifying, 208
Custom Views dialog box, 714–15, 714
Cut command
Excel program, 635–36, 635
Word program, 278, 279, 279
D
dataduplicating in Excel, 636–37
embedding, 162, 175–81
entering into databases, 1297–98, 1297
entering into worksheets, 609–19, 641–44, 779–80
forms used for entering, 779–80
importing from the Web, 836–38
linking, 162, 166–75, 689–91
modifying with queries, 1330–32
moving within worksheets, 635–36
sharing between applications, 161–81
statically copying/moving, 161–62, 163–65
validating upon entering, 781–83
Web snapshot of, 840
data access pages, 1266, 1266, 1355–60, 1356
creating, 1357–58
modifying, 1357, 1358–59, 1359
opening, 1356–57
publishing, 1359–60
viewing data in, 1357
database objects, 1264
databases
action queries in, 1330–32
adding fields to, 1281–82
calculated fields in, 1325–27, 1327
closing, 1274
components for storing information in, 1260
converting Excel lists into, 794–95, 795
copying fields in, 1283
creating in Access, 1267–70
creating forms in, 1333–39
creating queries in, 1311–16, 1311
creating reports in, 1361–70
creating tables in, 1277–80
crosstab queries in, 1312, 1328–29, 1331
customizing forms in, 1339–54
customizing tables in, 1280–90
data access pages and, 1266, 1266, 1355–60, 1356
Datasheet view of, 1296–1310, 1296
data types for, 1284, 1285–86
defining queries in, 1317–20
deleting records in, 1298–99
designing and planning, 1263–67
editing data in, 1297–98, 1297
enforcing referential integrity in, 1294–95
entering data into, 1297–98, 1297
Excel lists as, 777–83
field property settings, 1284–90
file formats for, 1275
filtering records in, 1304–10, 1354
finding and replacing text in, 1299
flat-file, 1260–61, 1260
forms used in, 1265–66, 1266, 1333–55
hiding columns in, 1301
modifying queries in, 1316–27
modifying reports in, 1370–75
moving fields in, 1283
opening, 1275
previewing reports, 1375
primary key designation, 1290
printing reports, 1376
queries used in, 1265, 1265
relational, 1260, 1262–63, 1262
removing fields from, 1282–83
renaming fields in, 1284
reports generated from, 1267
resizing columns in, 1300
saving, 1274
setting field properties in, 1284–90, 1285–86
sorting records in, 1303–4, 1310, 1354
subdatasheets used in, 1302–3, 1302
table relationships in, 1291–96
views for working with, 1273
wizards for creating, 1268–69
working with objects in, 1272–73
Database window, 1271–73, 1271
displaying, 1271–72
operations performed in, 1272–73
data files, Outlook program, 1101–5
data series, 756
Datasheet view (Access program), 1273, 1296–1310, 1296
adding and using subdatasheets, 1302–3
automatic data-saving feature, 1274
creating tables in, 1277–78, 1278
customizing, 1299–1302
deleting records in, 1298–99
entering and editing data in, 1297–98, 1297
filtering records in, 1304–10
finding and replacing text in, 1299
running queries in, 1331
sorting records in, 1303–4, 1310
data types, assigning to database fields, 1284, 1285–86
Data Validation dialog box
Error Alert tab, 782–83, 782
Input Message tab, 782, 782
Settings tab, 781, 781
data warehouses, 805
dates and times
entering into Excel, 612–14, 613, 614
inserting into documents, 250–51
supported formats for, 613
Web page component, 1246
Date And Time dialog box, 250–51, 251
Day/Week/Month view, Calendar folder, 1053–54, 1053
Decimal Places property, 1288
decision structures
If...Then, 1506–10
Select Case, 1511–13
Default Language Indicator, 231
Default Value property, 1289
Define Custom Show dialog box, 943, 943
Define Name dialog box, 752, 752
Define Views dialog box, 1003, 1003
Deleted Items folder, 996–97
delete query, 1332
deleting. See also removing
arrows in charts, 773
cells from tables, 344, 345
cells from worksheets, 630–31, 631
Clipboard blocks, 112
comments, 462–63
custom toolbars, 208
database fields, 1282–83
database records, 1298–99, 1354
embedded charts, 763
footnotes and endnotes, 434
formula names, 752
FrontPage webs, 1118, 1130, 1135
graphic objects, 153
menus, 211
pages from publications, 1401
paragraphs using a macro, 1535–36
styles, 398–99
table contents, 345
table relationships, 1293
text boxes, 773
text from documents, 269, 269
text styles, 1434
Web page elements, 1171
worksheets, 686–87
descending sort, 381, 784
Design Checker, 1409, 1409
Design Gallery, 1407–8, 1407, 1450
designing pages
in Publisher program, 1399–1407
in Word program, 509–18, 545–47
designing Web pages
in Excel program, 826–27
in FrontPage program, 1163–68, 1197–1234
in Word program, 573–78
design mode, 593
design templates, 855–57, 856
design time, 1477
design-time controls, 1251
Design view (Access program), 1273
creating data access pages in, 1358
customizing forms in, 1339–50
customizing tables in, 1280–81, 1281
formatting forms in, 1345–50
modifying queries in, 1316–18
modifying reports in, 1370–72
opening tables in, 1278
reports created in, 1361, 1362
desktop publishing
borders, 1398–99, 1399
brochures, 1412–29
bulleted and numbered lists, 1396–97
color fill effects, 1415–18
color schemes, 1413–15
column options, 1396
connecting text boxes, 1391–92, 1391
creating publications, 1382–87
cropping images, 1421, 1421
Design Checker, 1409, 1409
Design Gallery, 1407–8, 1407
drop caps, 1424–26, 1426
entering text, 1387–88, 1389
font schemes, 1393–95
formatting text, 1392–97, 1393
grouping objects, 1424, 1424
headers and footers, 1436–37, 1437
horizontal rules, 1428–29, 1428
hyphenation options, 1429–30
importing text, 1389
inserting and deleting pages, 1401
inserting pictures, 1418
layout guides, 1403–5, 1404
line spacing options, 1395
links to picture files, 1418–19
Master pages, 1402
newsletters, 1430–38
numbering pages, 1402–3
overflow text, 1390, 1390
page layout options, 1399–1407
page setup, 1399–1400
picture options, 1418–22
printing publications, 1400
rulers and ruler guides, 1405–7, 1406
text styles, 1431–34
text wrapping, 1434–36
tracking and kerning options, 1394–95
troubleshooting, 1401
typographic symbols, 1426–28, 1427
watermarks, 1437, 1438
Detect And Repair command, 6
repairing installation errors, 28
DHTML Effects toolbar, 1208–9, 1209
Diagram Gallery, 5, 138, 138, 902
diagrams. See also drawings; organization charts
adding text to, 139
animating, 923–25
inserting into slide presentations, 901–3
modifying, 139–40, 902–3
ready-made, 11
troubleshooting in Word, 135
types of, 138–41
Diagram Style Gallery dialog box, 140, 140
Diagram toolbar, 139, 139
dialog boxes. See also names of specific dialog boxes
building in Visual Basic, 1522–25
shared by Office applications, 4
Dialogs collection, 1535
dictation mode, 93–95, 93–94
dictionaries
custom, 483–86
language options, 480–81
digital certificates, 472
Dim statement, Visual Basic, 1492
direct character formatting, 298–99, 302
directory accounts, 1093–94
finding information for, 1099
troubleshooting, 1095
working with, 1099
disabling AutoCorrect, 266
discussion boards (SharePoint), 184, 192–97, 192
creating, 1133
customizing, 201–2
discussing online documents, 193–96
Internet Explorer access to, 197
participating in, 192–93
Discussion Options dialog box, 194
Discussion Pane, 194–95
Display As Icon option, 169
displaying. See also hiding; viewing
Clipboard task pane, 109, 112
icons for linked data, 169
Open Office Document dialog box, 62
pivot charts, 803–5, 804
styles, 325
task panes, 51–52
toolbars, 208
watermarks on pages, 518–20, 518
Web pages in Outlook, 1085–87
DisplayUser macro, 1497–98
Distribution List form, 1063–64, 1063
distribution lists, 1057–58
defining, 1063–65
privacy options, 1064, 1065
troubleshooting, 1065
dividing lines, 383, 586–88, 1428–29
docking Visual Basic tools, 1478
document libraries (SharePoint), 184, 187–91, 188
accessing with a browser, 187–89
accessing from Office applications, 189–91
assigning templates to, 203
creating, 1131–32
customizing, 201–2
Document Library Properties dialog box, 1133–34, 1134
Document Library View component, 595, 1246
Document Map, 426, 427, 428–29
documents
advanced formatting of, 395–414
attaching templates to, 413
automatically fixing text in, 258–63
automatically formatting, 334–37
basing templates on, 412
bookmarks used in, 289–90
borders used in, 356–66, 547
character formatting, 298–309, 299–301
charts inserted into, 144–46
comments in, 457–64
comparing, 456–57
compound, 162
converting, 62, 68
copying styles to/from, 403–4
copying text in, 275–80
creating, 53–61, 241
date and time in, 250–51
deleting text from, 269, 269
designing pages in, 509–18
display problems with, 240
dividing into sections, 524–25
dividing lines in, 383, 586–88
editing text in, 269–81
empty, 57–58
encrypting, 472
entering text in, 245–46
files used for, 58
finding, 66, 69–74
footnotes and endnotes in, 430–34
formatting, 297–337
forms added to, 470
grammar checker for, 486–93
headers and footers in, 520, 526–35
highlighting text in, 464–66
hyperlinks to, 74
hyphenating words in, 498–504
identifying, 66, 67
indexes generated for, 435–39
language options, 497–98, 497, 504–7
line numbering in, 546–47, 546
lists created in, 372–80
lost versions of, 582
mail merge, 553–62
managing, 64–65, 77
margins in, 536–42
master, 425
merging, 455–56
moving text in, 275–80
multiple document interface, 80–81, 81
navigating, 289–95
newspaper-style columns in, 366–71
online, 571–73
opening, 61–74, 241
Outline view, 415–30
page breaks in, 311–12, 550–51, 550
page layout features for, 227, 509–18, 545–47
page numbering for, 520, 521–23
page orientation for, 536–42
page setup for, 535–47
paper size and source settings for, 544–45
paragraph formatting, 309–18, 311–13
pictures inserted into, 115–31
positioning the insertion point in, 267–68, 268
previewing, 83, 547–48
printing, 548–49
proofing, 475–507
properties for, 82–85
recently opened list, 68–69
recovery features for, 10
reopening, 68–69
repeating text in, 251
replacing text and formatting in, 287–89
reusing text in, 252–58
saving, 74–79, 241–42, 242, 426
searching text and formatting in, 281–86
selecting text in, 270–74, 328–29
shading used in, 356–66
sharing on SharePoint, 187–91
sharing in Word, 466–74
single document interface, 79–80, 80, 81
sketches inserted into, 107–8
smart tags in, 263–66
sorting lists and tables in, 380–83
spelling checker for, 475–86
statistics about, 491, 491, 492
styles applied to, 320–31, 385–404, 407
symbols and special characters in, 246–50
tables in, 339–56
templates for, 54–57, 405–14
themes applied to, 598–99
thesaurus feature for, 494–96
tracking changes to, 445, 446–50
translating text in, 497–98
viewing in Word, 235–37, 235, 240
watermarks added to, 518–20, 518
wizards for customizing, 54
working with multiple, 79–81
document sections, 524–25
page numbering and, 523
varying headers and footers in, 533
watermarks and, 520
Document Subscription dialog box, 196, 196
document templates, 405–14
draft font option, 239–40, 240
dragging-and-dropping. See also copying; moving
cells, 639, 639, 640
clips, 122
FrontPage web files and folders, 1139
Outlook items, 986
text, 275–77
text boxes, 513
troubleshooting, 277
drawing canvas, 134, 512
drawing features, 5
drawing layer, 908–9
Drawing objects, 107
Drawing Pad window, 107–8, 107
creating a sketch in, 107
summary of tasks performed in, 108
drawings. See also graphics; pictures
AutoShapes for creating, 132–34
conceptual, 135–41
grouping, 908
inserting sketches into documents, 107–8
stacking layers for, 908–9
troubleshooting, 907
using in PowerPoint presentations, 905–9
Drawing toolbar, 134, 134
Excel program, 772–74, 773
inserting new graphic objects with, 155, 155
modifying graphic objects with, 152–56, 152, 155, 156
PowerPoint program, 902, 905, 909
Draw menu, 154, 154
Drop Cap dialog box, 1425, 1425
drop caps, 1424–26, 1426
duplicating. See also copying
data in Excel, 636–37
slides in PowerPoint, 866–67
Dynamic Effects component, 1246
dynamic HTML effects, 1208–9, 1229
| Top of Page |
Last Updated: Friday, July 6, 2001