|
|
 |
|
|
|
Troubleshooting Microsoft® Office XP
|
|
|
Author |
|
Nancy Stevenson and Elaine Marmel
|
|
|
Pages |
576
|
|
Disk |
N/A
|
|
Level |
Beg/Int
|
|
Published |
01/02/2002
|
|
ISBN |
9780735614918
|
|
ISBN-10 |
0-7356-1491-1
|
|
Price(USD) |
$29.99
To see this book's discounted price, select a reseller below.
|
|
|
|
|
|
|
|
|
Index
' (apostrophes), 136, 152
* (asterisks), 21, 80, 144, 152, 171
^ (caret signs), 144, 152
: (colons), 171
. (decimals), 148, 156-57
/ (divider signs), 171
$ (dollar signs), 142
= (equal signs), 160
- (hyphens), 136
- (minus signs), 171
¶ (paragraph marks), 36, 37, 432, 464, 483, 516
+ (plus signs), 171
# (pound signs), 148, 170-71, 327
#... errors, 171
? (question marks), 21, 80
\? sign, 144
" (quotation marks), 85, 144, 152, 163
; (semicolons), 20, 163
\ (slash), 152
_ (underscore characters), 498
2-D or 3-D charts, 133
3-D effects, 310
borders and, 26, 140
colors and, 141
in Excel, 135
removing, 27
shadows and, 313
3-D Settings toolbar, 311, 313
3-D styles, 509
16 Bit color settings, 363
A
absolute cell references, 142, 509
Access
exporting data to Excel, 174, 178-81
exporting data to Word, 95
importing data from Excel, 182-83
importing data from Word, 86, 94-95, 420-23
PivotTables, 174, 178-79
acronyms, AutoCorrect and, 39
action buttons, 339, 509
actions, 259, 339, 385
activating objects, 91
active cells, 509
Add Clips To Organizer command, 23
Add Network Place Wizard, 110, 394
Add To Favorites command, 253
add-in templates, 485
add-ins, 509. See also macros
COM, 486-87
deleting, 477
Microsoft digital signatures in, 478
updating list of trusted sources, 480
warnings about, 112-13
Add/Remove Programs, Control Panel, 474
Address Book command, 207
address books, 509
delays in resolving names, 208-9
digital IDs in, 268
excluding from searches, 208-9
opening contacts folders, 210-12
permissions, 211
reordering list, 213
selecting, 207
troubleshooting flowchart, 206-7
addresses, 509
editing for mail merge, 438
on envelopes, 412-13, 419
Advanced Search task pane, 80
advancing slides, 509
aligning and arranging objects, 509
Align feature, 294
Excel numbers, 158-59
PowerPoint
aligning and distributing, 298-99
grayed-out commands, 295
overlapping objects, 296-97
rotating or flipping, 300-301
troubleshooting flowchart, 294-95
Word items, 489, 506
analyzing data with Excel, 181
animation, 509
Excel cell borders, 144, 153
PowerPoint
animated GIF files, 314
animation schemes, 386
custom sequences, 325
letters or words, 385, 390
mouse-click animations, 388-89
Normal view and, 348
order of effects, 386-87
sound and, 340
troubleshooting flowchart, 384-85
Web presentations, 390-91
Word printing problems, 468
Animation Schemes command, 385
apostrophes ('), 136, 152
Apple QuickTime, 335, 336, 338-39
applications. See programs
appointments at wrong times, 286-87
archiving Outlook files, 218, 509
arguments in functions, 173, 509
arranging objects
aligning or distributing, 298-99
overlapping items, 296-97
rotating or flipping, 300-301
troubleshooting flowchart, 294-95
arrow keys, 134, 143, 154, 294
.asc files, 95
.asd files, 9
ASK fields, 432
.asp files, 502
aspect ratios, 30
asterisks (*), 21, 80, 152, 171
attaching templates, 493
attachments to e-mail
correct commands for, 68
file formats, 216
forwarding messages, 220-21
missing changes in, 218-19
printing, 214-15
problems opening, 216-17
troubleshooting flowchart, 214-15
Web slide shows, 393, 398
audio. See sound
Audio Video Interleaved files, 336
auditing formulas, 73, 169
authentication, 268, 481, 509
auto macros, 485
AutoArchive feature, 280
AutoCaptions feature, 70
AutoContent Wizard, 510
AutoCorrect feature, 38-39, 510
adding words, 39
AutoText entries, 491
misspelled entries in, 98
options, 38, 104, 344
removing words from, 104
AutoFit feature, 344
AutoFormat feature, 344
automatic actions
correcting text, 38-39
envelope feed, 414-15
Office Clipboard, 34
page breaks, 452
automatic updates
dates or times, 455
links, 321
styles, 494-95
AutoRecover feature
enabling, 5
finding recovered files, 8-9
lost changes in files, 10-11, 449
restoring damaged files, 6-7
running at specified intervals, 10
troubleshooting flowchart, 4-5
"AutoRecover save of..." files, 9
AutoShapes, 510
borders, 26
copying, 114
fitting text into, 380-81
resizing, 31, 380, 381
rotating or flipping text in, 378-79
shadows, 141
troubleshooting flowchart, 376-77
unlocking, 191
AutoText feature, 482, 490-91
AVI format (.avi files), 336
axes on Excel charts, 126-27, 130-31, 132
B
background colors, 27, 70, 403
Background command, 27, 330, 403
background error checking, 168
Background Printing feature, 62
background processes, 276-77
background saving, 448
backgrounds on slides, 307, 330, 510. See also Slide Masters
backgrounds on Word pages, 403, 462, 465, 510
backing up files, 4, 116-17, 251, 484
balloons in reviewed documents, 71
barcodes, 412, 418-19
Basic Search task pane, 78, 80
basing styles on existing ones, 115, 495
.bat files, 216
binary e-mail formats, 216
bitmaps, 317
black-and-white printing, 350, 352
blank lines
deleting in handouts, 346-47
mail-merged documents, 432-34
blank spaces, underlining, 492, 498
blocking meeting responses, 248-49
blue boxes under words, 38
bold text, 409
bookmarks, 510
borders
drawing objects, 24, 26-27
in Excel, 134, 140, 144, 153
in PowerPoint, 350, 356
in Word
around pages, 406-7, 411, 465
around paragraphs, 407
around tables, 322, 323
troubleshooting flowchart, 402-3
as underlining, 498
Borders And Shading dialog box, 26, 323, 406-7, 411, 465
box-shaped bullets, 408
bringing objects forward, 297
broadcast presentations, 392, 393, 510
browsers. See Web browsers
bulk mail sorting, 426
bulleted or numbered lists
bold text, 409
Click and Type feature, 489
inconsistent formatting, 410
numbered headings, 404-5
omitting bullets or numbers, 402
strange characters, 408-9
Word troubleshooting flowchart, 402
Bullets And Numbering dialog box, 404, 408-9
busy times in schedules, 246
buttons. See tools and toolbars
C
calculations, displaying in Excel, 169
Calendar Options dialog box, 286, 287
calendars. See schedules and calendars
Call Using command, 242
Call Using NetMeeting command, 243
capitalization in AutoCorrect, 39
Caps Lock key, 39
caret signs (^), 144, 152
CDs, music from, 340
cell ranges
copying into PowerPoint, 308-9
in History worksheet, 203
names, 171, 192, 234, 235, 427
passwords, 192
protecting, 184, 192-93
saving for FrontPage, 177
cell references, 142, 171, 510
cells. See also cell ranges
borders and shadows, 140-41
conditional formatting, 160-61
drag-and-drop editing, 37
formulas and, 142, 190
hidden information in, 150-51, 190
number and date formatting, 148
references to, 142, 171, 510
unlocking or locking, 190
in Word tables. See tables
Certificate Import Wizard, 477
Certificate symbols, 270, 271
certificates. See digital certificates and signatures
Change All command, 99
change tracking. See also History worksheet, reviewing changes
change history defined, 510
deleting workbook history, 188
in Excel workbooks, 72, 74-75, 196-97, 202
printing or copying history, 189
in shared workbooks, 196-97
specifying days to keep history, 197
tracked changes defined, 518
in Word documents, 70-71
characters
bulleted lists, 402, 408-9
Excel symbols, 144
file names, 119
formatting, 492
Office Assistants, 40, 43, 44-45
replaced after saving, 444
wildcards, 21, 80
chart areas, 510
Chart Options dialog box, 130-31
chart sheets, 129, 510
Chart toolbar, 131
charts
axes on, 126-27, 130-31, 132
chart areas, 510
chart sheets, 129, 510
dates on, 130-31
font size, 132, 133
labels on, 132
plot areas, 133
resizing, 132
saving, 177
troubleshooting, 126-27
updating, 126, 128-29
user-defined types, 126
checking errors. See errors
checking spelling. See spelling checkers
clear text signed messages, 266
clearing Office Clipboard, 35
Click and Type pointers, 482, 488-89, 510
clicking to trigger animation, 388
clip art, 510. See also Clip Organizer
adding to Clip Organizer, 22-23
as animation triggers, 389
collections, 16, 17
file names, 21, 389
finding, 14, 16-17, 20-21
grouping or ungrouping, 18-19
inserting on notes pages, 348
keywords, 16-17
pieces of, 15, 18-19
resizing, 15
selecting, 19
troubleshooting flowcharts, 14-15
user profiles and, 16
Clip Art task pane, 20
Clip Organizer
adding pictures to, 14, 22-23
creating new collections, 17
finding clip art, 16-17
narrowing search results, 20-21
problems with, 14-15
reinstalling, 15
sound files in, 340
clipboards, 32-35, 239, 518
clock face characters, 408
closing
background programs, 467
Master view, 307, 331
spelling checker prematurely, 100
codes
barcodes, 412, 418-19
custom formats in Excel, 164
field codes in Word, 434, 466, 512
HTML tags, 502
ZIP codes, 426
collaborating on documents
Excel workbooks
abrupt disconnection, 200-201
change history, 75, 196
change tracking, 196-97
missing changes in files, 202-3
other users opening files, 188
read-only access, 198-99
security, 188
shared workbooks defined, 517
troubleshooting flowchart, 194-95
unsharing files, 188
links to shared locations, 69
SharePoint Team Services, 66, 67, 82
troubleshooting flowchart, 64
Word documents, 70-71, 110-11
collapsing grouped tasks, 252
collections of clip art, 16, 17, 21, 22-23
colons (:), 171
color depth, 362, 363
color-coded sheet tabs, 147
Color/Grayscale command, 352
colors
3-D objects, 311
background colors, 27
depth, 362, 363
e-mail messages, 262
Excel data, 150, 160-61
fills in objects, 141
fonts and backgrounds, 356
grayscale printing and, 353
on-screen display, 25
printing, 62
problems, 24
shadows, 312, 313
transparency, 297
column breaks in Word, 452
columns in Excel, 73, 127, 149, 151, 234
COM add-ins, 486-87
combining files. See merging
commands. See menus and commands; names of specific commands
comma-separated files, 94, 422, 510
comments, 66, 70-71, 510
comparing
compare feature defined, 511
formatting in text, 496
versions of Excel files, 7, 201
compressed files, 216
Computer Management, Control Panel, 82
conditional formats, 156, 160-61, 511
conditional mail merges, 432
conditions, 80, 81, 259, 261
confirming file conversions, 7, 502
connections
to networks, 200-201
to printers, 58
between Word sections, 460
connectors, 511
contacts, 511
delays in resolving names, 208-9
digital IDs, 268
e-mail formats for, 217, 237
permissions to folders, 211
problems opening folders, 210-12
reordering address books, 213
searching for, 85
selecting address books, 207
troubleshooting flowchart, 206-7
contacts folders, 210-12
contents, retrieving from files, 6
controls, unlocking in Excel, 191
Convert dialog box (Outlook), 241
Convert File dialog box (Word), 503
converting
cell references, 142
files
installing converters, 445
large files to smaller ones, 448
to text or RTF, 94
to Word formats, 444, 502, 503
fonts, 447
graphics, 446-47, 506
hours to days or weeks, 288-89
objects, 18, 91, 240-41, 316-17
shared lists from Excel 95, 198
text
automatic data to non-updating, 455
to hyperlinks, 504
to numbers, 159
tables to text, 94, 422
copies
of documents, e-mailing, 69
of e-mail messages, 222
of files on local hard drives, 202
Copy Rule To dialog box, 263
copying
animation effects to slides, 387
cells, 138-39, 142
e-mail messages, 214
e-mail rules, 262, 263
Excel History worksheet, 189
files
portions of into e-mail, 238-39
into public folder, 254
read-only files, 198-99
objects, 239, 302, 331
Office Clipboard problems, 35
permissions information, 193
PowerPoint troubleshooting flowchart, 302-3
slides, 304-5
styles or formats, 114-15, 493, 497
text or data
AutoText entries, 490
Excel chart sheets, 129
formulas, 134, 142
into FrontPage, 176
multiple copies of Excel data, 153
number series, 139
numbers, 134
corrupted files. See AutoRecover feature
courtesy reply mail option, 418
crashes, 4, 64-65, 66-67
criteria in searching, 81, 82
cropping pictures, 310, 314-15
.csv files, 95, 422, 510
current pages, printing, 57
Custom Animation task pane, 324-25, 340, 385, 386, 388
custom commands, 474
custom dictionaries, 98, 102-3
custom number formats, 162-64
custom slide shows, 354, 511
custom templates, 106, 108-9
custom toolbars, 52, 53
custom views, 253, 281
Customize dialog box, 52, 53, 486-87
cutting
large files into smaller ones, 448, 476
slides, 305
D
damaged files. See AutoRecover feature
Data Form dialog box, 437
data labels, 511
data ranges, 128
data series, 511
data sources, 427-28, 436, 511
Database window (Access), 180, 511
Date And Time command, 455
dates or days
AutoCorrecting names of, 39
digital ID expiration dates, 271
Excel
charts, 130-31
errors, 170
formats, 137, 164
incorrect display, 144, 148-49
Outlook, 247, 285, 288-89
PowerPoint slides, 327
Word headers or footers, 454-55
Daylight Saving Time settings, 287
days. See dates or days
decimals (.), 148, 156-57
defaults
address books, 207
digital certificates, 273
printers, 215
security settings, 270
shadow colors, 313
delays
in e-mailing, 206, 274
in resolving names, 208-9
in sending or receiving e-mail, 282
sound clips in PowerPoint, 325
delegates, 245, 275
Delete Columns command, 347
Delete Frames command, 501
Deleted Items folder, 248, 249
deleting
3-D effects, 27
address books, 208-9
backgrounds or shading in Word, 403
borders on notes pages, 356
change history from workbooks, 188
Clipboard items, 32, 35
contacts folders, 212
e-mail
automatically, 280-81
meeting responses, 244, 249
recalled e-mail messages, 279
from servers, 222
files, 256, 485
by filtering, 71, 253, 281
graphics
ruled lines on handouts, 346-47
on slides, 374-75
watermarks, 403
macros, 477, 485
page or column breaks, 452-53
personal file information, 65
placeholders, 328-29, 372
recurring appointments, 290, 291
Registry keys, 486
reminders, 290
search indexes, 79
slides, 305
styles or formatting, 159
text
AutoCorrect entries, 104
decimal points from numbers, 157
e-mail headers, 69
footer text on slides, 327
page numbers, 457
while dragging, 139
words from dictionaries, 102-3
tools from toolbars, 53
Web frames, 500, 501
delivery point barcodes, 412, 418-19
demoting headings in outlines, 405
dependents in Excel formulas, 169
design templates, 511
designing slides
moving or deleting graphics, 374-75
replacing fonts, 368-69
too many placeholders, 372-73
troubleshooting flowchart, 366-67
Device Manager, 360
dictionaries, 98, 102-3
different first pages, 454, 457
digital certificates and signatures
adding to trusted sources, 472
add-ins, 112
definitions, 511
expiration, 270, 271, 476-77
Microsoft signatures, 478
obtaining for recipients, 268
security labels and, 272
SelfCert tool, 481
S/MIME IDs, 267
trust levels, 270-71
unauthenticated, 481
updating, 476-77
updating list of trusted sources, 480
warnings about, 472, 476-77
digital IDs. See digital certificates and signatures
digital video movies, 338
directional keys, 134, 143, 154
directories. See folders
directory services, 209
disabling features. See turning features on or off
disappearing items. See also hiding
reviewer names, 64-65
text, 482, 483
disconnection messages, 200-201
disk space, 63, 448
dismissing reminders, 290
display. See on-screen display
Display dialog box, 363
displaying
all information in cells, 150-51
calculations in Excel, 169
colors, 25, 313
dates and values in Excel, 148-49
drawings, 24, 28-29
embedded objects in Outlook, 233
Excel charts, 129
field codes in Word, 434
field shading in Word, 450-51
Full Screen view, 54-55
hidden slides, 354-55
hidden text, 101
left pane of Help window, 46
line numbers, 458
magnified views, 54
movie files as icons, 337
multiple address books, 213
Office Assistant, 40-41
Office Clipboard, 34-35
page break markers, 452
personalized or full menus, 50
picture placeholders, 29
red wavy underlines, 98
Reviewing toolbar, 71
Style area, 493
toolbars, 48, 51
tracked changes, 70
worksheet tabs, 146-47
Distribute feature, 294, 295, 511
#DIV/0! error, 171
divider sign (/), 171
.doc files, 425, 445
Document Recovery task pane, 5, 7, 9. See also AutoRecover feature
documents. See files
dollar signs ($), 142
.dot files, 108. See also templates
dots per inch (dpi), 362
downloading
clip art collections, 22
fonts, 351
QuickTime player, 338
dpi (dots per inch), 362
draft e-mail messages, 221, 282, 511
draft fonts, 468, 469
draft output printing, 469
Drafts folder, 221, 282
drag-and-drop editing, 36, 37
dragging
cells with Fill handle, 138-39
columns in Excel, 149, 151
scroll bar splitters, 146
drawing borders, 26-27
drawing objects, 515
3-D effects. See 3-D effects
adding to notes pages, 348
converting objects to, 91
cropping, 314-15
displaying, 28-29
editing, 316-17
grouping or ungrouping, 18-19
on PowerPoint notes, 342
print settings, 466
resizing, 24, 30-31
shadows, 312-13
troubleshooting flowchart, 24-25, 310-11
Drawings view (Word), 28
drivers, 60, 360
duplicate appointments, 290
duplicate contacts, 269
duplicate slides, 511
DVD movies, 338
E
Edit Address Block command, 438
Edit Greeting Line command, 438
Edit Hyperlink command, 504, 507
Edit In Formula Bar command, 169
Edit Keywords command, 17
editing
AutoCorrect feature, 38-39, 104-5
custom dictionaries, 102-3
drag-and-drop editing, 36, 37
e-mail attachments, 218-19
Excel data
arrow and directional keys, 143
borders on cells, 140
Fill handles, 138-39
formulas, 168-69
missing changes in files, 202-3
preventing editing, 186
problems with formulas, 142
shadows on cells, 141
sorting data, 136-37
troubleshooting flowchart, 134-35
HTML files, 88-89
hyperlinks, 504, 507
objects or pictures
clip art, 15
embedded objects, 233, 316-17, 322
keywords, 17
linked pictures, 121
troubleshooting flowchart, 310-11
Office Clipboard behavior, 34-35
Registry, 484, 486
selecting text, 36-37
troubleshooting flowchart, 32-33
Web slide shows, 393, 396-97
Word documents
AutoText entries, 490-91
bulleted or numbered lists, 402
Click and Type feature, 488-89
envelope text styles, 416-17
extended selection mode, 483
mail merge addresses and greeting lines, 438
mail merge source files, 437
missing changes in files, 449
page numbers, 457
troubleshooting flowchart, 482-83
Effect Options command, 340
effects. See 3-D effects; special effects
e-mail accounts, 511
choosing software, 277
forwarding mail to, 228-229
logging on to servers, 226-27
rules for, 259, 260-61
searching directories, 209
Send/Receive Groups, 277
server timeouts, 230-31
settings for sending, 282
troubleshooting flowchart, 222-23
undeliverable mail, 224-25
e-mail attachments
forwarding, 220-21
missing changes in, 218-19
problems opening, 216-17
sending review documents, 64, 68-69
sending Web slide shows, 393, 398
troubleshooting flowchart, 214-15
e-mail messages
coloring with rules, 262
delays after addressing, 206
deleting headers, 69
Drafts folder, 221
formats, 217, 236, 266-67
hidden or deleted, 280-81
inserting portions of files, 238-39
links to shared locations, 69
meeting responses, 245
missing objects in, 236-37
moving to folders automatically, 249
notifications of changed files, 67
opening forwarded messages, 275
opening secure messages, 270-71
problems sending, 222, 282-83
review documents, 64, 68-69
security, 266-67, 272-73
sending Web sites, 121
settings for sending, 282
troubleshooting flowchart, 274-75
trust levels, 270
undeliverable mail, 224-25
E-Mail Options dialog box, 245
E-Mail Properties dialog box, 217, 237
e-mail servers, 222, 230-31
embedded fonts, 70, 370-71
embedding objects, 512
charts, 128-29, 132, 133, 511
editing
in PowerPoint, 316-17
problems, 240-41
problems opening objects, 90-91
without original program, 310
Excel data in PowerPoint, 309
missing in e-mails, 236-37
multimedia, 318
object linking and embedding, 254
Outlook troubleshooting flowchart, 232-33
portions of files in e-mail, 238-39
PowerPoint troubleshooting flowchart, 318-19
printing from PowerPoint, 382
sound clips, 324-25
spelling in objects, 101
table gridlines missing, 322-23
troubleshooting flowchart, 86-87
updating automatically, 303
enabling features. See turning features on or off
encoding e-mail, 217, 512
encryption
expired digital IDs, 270, 271
passwords, 186
public key encryption, 268
security policies and e-mail, 272
sending e-mail, 267, 268-69
END notation, 143
entering data (Excel)
directional keys and, 154, 483
hidden information in cells, 150-51
multiple copies of data, 153
special characters in cells, 152
troubleshooting flowchart, 144-45
values and dates, 148-49
worksheet names, 146-47
entering text, 482, 483, 488-89
Envelope Options dialog box, 415
envelopes
addresses, 412-13
changing fonts, 416-17
manual or automatic feed, 414-15
POSTNET barcodes, 418-19
styles, 416-17
troubleshooting flowchart, 412-13
equal signs (=), 160
erroneous e-mail messages, 278-79
error checking in Excel, 158, 168
error messages
digital signatures, 476-77
Excel error values, 136
importing data into Outlook, 234-35
joining meetings, 243
linked or embedded objects, 86, 90-91, 240-41
macro warnings, 472, 478-79
public folder conflicts, 256-57
saving files in Word, 444, 448
security policies, 267
server timeouts, 230-31
errors. See also spelling checkers
formulas, 166, 168-69
green indicators, 159
pound signs (#), 170-71
values, 149
Evaluate Formulas command, 169
even-numbered headers or footers, 451
Excel
AutoRecover settings, 10-11
cell ranges
copying, 308-9
in History worksheet, 203
names, 92, 171, 192, 234, 235, 427
passwords, 192
protecting, 184, 192-93
cells
borders and shadows, 140-41
conditional formatting, 160-61
drag-and-drop editing, 37
formulas and, 142, 190
hidden information, 150-51, 190
hiding formulas, 190
number and date formatting, 148
references, 142, 171, 510
references to, 142, 171, 510
unlocking or locking, 190
charts
dates on, 130-31
labels on, 129, 132
resizing, 132
resizing fonts, 132, 133
time-scale axes, 131
troubleshooting charts, 126-27
updating, 128-29
editing data
arrow and directional keys, 143
checking spelling, 100
drag-and-drop feature, 37
Fill handles, 138-39
missing changes in files, 64-65
problem tracking changes, 72-73
problems with formulas, 142
sorting data, 136-37
troubleshooting flowchart, 134-35
e-mailing documents, 68
entering and selecting data
AutoCorrect settings, 38-39
directional keys and, 154
hidden information, 150-51
multiple copies of data, 153
special characters, 152
troubleshooting flowchart, 144-45
values and dates, 148-49
worksheet names, 144-45, 146-47
Excel 95 shared lists, 198
exporting data
to Access, 182-83
to FrontPage, 176-77
to Outlook, 86, 92-93, 234-35
to PowerPoint, 308-9
troubleshooting flowchart, 174-75
to Word, 420-21
formatting worksheets
borders on cells, 140
conditional formatting, 160-61
numbers, 158-59, 162-64
shadows on cells, 141
styles, 115
troubleshooting flowchart, 156-57
formulas and functions
help with, 168-69, 172-73
hiding, 142, 150-51, 190
problems with, 142
troubleshooting flowchart, 166-67
graphics, 29
History worksheet
changes missing, 64-65, 74-75
changes tracked in, 73
problem tracking changes, 72-73
protected workbooks, 188, 189
importing data
Access data, 178-79, 180-81
troubleshooting flowchart, 174-75
Open And Repair command, 6
protecting workbooks
commands unavailable, 188
permissions, 193
portions of worksheets, 190-91
preventing opening or editing, 186
preventing structural changes, 187
troubleshooting flowchart, 184-85
unprotecting ranges, 192-93
sharing workbooks
change tracking, 64-65, 72-75, 196-97
disconnections, 200-201
missing changes in files, 64-65, 202-3
read-only access, 198-99
troubleshooting flowchart, 194-95
Web Discussions feature, 66
startup folder, 45
templates folder, 108
exceptions
for AutoCorrect feature, 39
in rules, 259
Exchange, 68, 245, 278-79
Exchange Client, 210, 236
Exchange Server, 224, 231, 256, 266
excluding
address books from searches, 208-9
recipients in mail merge, 428, 437
weekends from printed calendars, 284
.exe files, 216
Expand All command, 383
expanding
group tasks in Outlook, 252
groups of items in Outlook, 280
menus, 50-51
outlines, 382-83
text in shapes, 380
expired digital certificates, 270, 271, 476-77
exporting, 512
Access data
to Excel, 178-79, 180-81
as text or RTF, 95
Excel data
to Access, 182-83
to FrontPage, 176-77
to Outlook, 234-35
to PowerPoint, 308-9
troubleshooting flowchart, 174-75
to Word, 426-28
FrontPage files to Word, 424-25
Outlook rules, 264
troubleshooting flowchart, 86-87
Word troubleshooting flowchart, 420-21
EXT in status bar, 154, 483
extensions, file, 119, 444, 445, 502
external data, 95, 182, 423
external references, 512
F
"failed" rules, 265
FALSE values, 136, 160, 171
Fast Saves, 12
Fast Searching feature, 78
FAT32 file system, 15
Favorites folder, 253, 512
feeder trays for envelopes, 414-15
Field dialog box, 491
field results, 512
Field Shading feature, 450-51
fields
Access databases, 182
Excel names, 92, 234
Outlook's definition of, 234
Word
AutoText in, 491
displaying codes, 434
field codes defined, 512
field results defined, 512
mail merge, 430, 432, 450-52
page numbers, 457
printing problems and, 466
shading, 450-51
File Conversion dialog box, 94, 423
file extensions, 119, 444, 445, 502
file formats
available Word formats, 444
e-mail, 217, 237
movies, 335, 336
text, 217
Web formats, 506
file names
characters in, 118-19
clip art, 389
double extensions, 444, 445
extensions, 119, 444, 445, 502
long and short, 118, 119
searching by, 21
file repair. See AutoRecover feature
file size
embedded fonts and, 371
file too large error messages, 448
graphics and, 348
sound files and, 340
file too large error messages, 448
File Transfer Protocol (FTP), 216, 398
files
attaching templates, 493
backing up, 4
copying styles, 497
dividing into smaller ones, 448, 466
e-mailing for review, 64, 68-69
finding recovered files, 8-9
formats. See file formats
linking and embedding, 254, 320-21
names. See file names
opening on Web, 116
pictures for Web sites, 120-21
in public folders, 250
repairing. See AutoRecover feature
saving regularly, 8
searching for, 80-81, 82-83
slow search performance, 76, 78-79
storing within Outlook, 218
types of, 88
versions of, 4, 7
fill colors, 512
effects, 25
in objects, 141
placeholders, 356
problems, 24
transparency and, 297
Fill handles, 134, 138-39, 512
filtering. See also rules
copying data in Access, 179
e-mail, 280-81
Outlook views, 252
removing filters, 71, 281
filters for graphics, 446
FIM-A courtesy reply mail, 418-19
Find Printer button, 59
finding. See searching for items
Finding Help Topics pane, 47
firewalls, 47
first pages of documents, 454, 457
fitting
calendars on pages, 285
pictures to Photo Album slides, 377
printouts on paper, 470
text into AutoShapes, 31
text into shapes, 380-81
five-day weeks, 288-89
flipping objects, 300-301, 376, 378-79
floating objects, 515
floating toolbars and menus, 42
flowcharts. See troubleshooting flowcharts
folders, 512
contacts folders, 210-12
indexing files in, 78
locations for recovery files, 9, 11-12
public folders. See public folders
scanning for clip art, 23
startup folders, 45
fonts
converted Word files and, 447
dark fill colors and, 356
draft, 469
embedded, 70
envelope styles, 416-17
Excel charts, 132, 133
hidden text attributes, 433
licenses for, 370
numbers to use, 368
PowerPoint error messages, 350
replacing, 368-69
resizing, 126, 132, 133
slide problems, 326, 332-33, 366-67, 370-71
strange bullet characters, 408-9
substitutions, 447, 469
TrueType, 370-71, 469
Word printing problems, 468-70
footers on pages, 512
changing in all sections, 460
dates or times in, 454-55
page numbers, 457
problems with, 454-55, 457
troubleshooting flowchart, 450-51
Web pages, 454
footers on slides, 327
Format AutoShape dialog box, 29, 297
Format Cells dialog box
borders, 140
conditional formatting, 161
date formats, 148
number formats, 148, 162-64
protection feature, 190
removing formats, 150
text formats, 136-137
wrapping text, 151
Format Painter tool, 114, 161
Format Placeholder dialog box, 356
formats for files. See file formats
formatting
AutoShapes, 29, 297
cells
borders, 140
conditional formats, 156, 160-61
dates, 148
numbers, 137, 148, 156, 158-59, 162-64
problems in Excel, 134
removing formats, 150
text, 136-37
wrapping text, 151
copying to objects, 114-15, 161
pages
PowerPoint notes pages, 343
Word troubleshooting flowchart, 450-51
slides
after copying and pasting, 302, 304-5
placeholders, 356
text, 332
unwanted changes to, 370-71
text
bullets or numbers, 409, 410
characters, 492
Click and Type indicator, 489
copying styles, 497
envelope text, 412
paragraph marks as hidden text, 432
Reveal Formatting task pane, 496
on slides, 332
Style area, 493
subscripted text, 499
tables, 318, 322
troubleshooting flowchart, 492-93
underlining problems, 498-99
unwanted style changes, 494-95, 496
worksheets, 75, 156-57
Formatting toolbar, 55
forms, 180-81, 424-25
Formula Auditing command, 169
Formula bar, 512
formulas in Excel, 512
auditing, 73, 169
conditional formatting, 160
copying, 134
displaying calculations, 169
functions, 172-73
help with, 168-69
hiding, 190
pasting into multiple worksheets, 147
pound signs, 170-71
precedents, 169
problems with, 142
protecting, 184
special characters in, 152
tracking recalculations, 73
troubleshooting flowchart, 166-67
forwarding, 512
e-mail messages, 214
e-mail to other accounts, 228-29
meeting responses, 244
opening forwarded messages, 275
fractions in Excel, 164
frames, 500-501, 507, 512
free disk space, 63
freeing up memory, 467
freezing programs. See crashes
From File command, 348
FrontPage documents, 97, 174, 176-77, 420-21, 424-25. See also HTML files
FTP (File Transfer Protocol), 216, 398
full menus, 50
Full Screen view, 54-55
Function Arguments dialog box, 173
functions in Excel, 166-67, 172-73
G
gaps in dates, 130
Get A Digital ID command, 268
Get External Data command, 95, 182, 423
GIF format (.gif files), 120, 177, 314, 506, 513
global settings in PowerPoint, 372
gradient fills, 25
grammar in hyperlinks, 505
Graph program, 320
graphics accelerators, 363
graphics and pictures. See also clip art; drawing objects
adding to Clip Organizer, 14, 22-23
animation, 384
converting while saving, 446-47
cropping, 314-15
drawing problems, 24-25
editing embedded objects, 316-17
file sizes and, 348
as fill patterns, 25
installing filters for, 446
missing on slides, 330-31
moving or deleting on slides, 374-75
on notes pages, 342, 348-49, 367
pasting Excel data as, 308
pieces of, 18-19
PowerPoint troubleshooting flowchart, 310-11
printing in Word files, 462, 466-67
problems displaying, 28-29, 358
proportionally resizing, 31
shadows, 312-13
on Slide Masters, 326
sorting with Excel cells, 137
unlocking in worksheets, 190, 191
unwanted location changes, 500, 506
Web formats, 506
grayscale, defined, 513
grayscale printing, 352
green error indicators, 159
green rotation handles, 301
green wavy underlines, 505
Greeting Line dialog box, 438
greeting lines, 438, 451-52
grids, 298-99, 513
grouping, 513
objects, 310
pieces of clip art, 18-19, 310
tasks in Outlook, 252
text and AutoShapes, 378-79
groups of items in Outlook, 280
guides, 513
H
handles
cropping, 315
rotation, 301
Handout Master, 307, 328
handouts, 513
deleting ruled lines, 346-47
Handout Master, 307, 328
troubleshooting flowchart, 342-43
hard drive space, 63, 448
hardware
graphics accelerators, 363
projector problems, 364
sound equipment, 360
<HEAD> code, 502
Header And Footer toolbar, 455, 456, 457, 460
headers on pages, 513
changing in all sections, 460
dates or times in, 454-55
page number problems, 457
problems with, 454-55
troubleshooting flowchart, 450-51
Web pages, 454
headings, 97, 402, 404-5, 513
help
displaying left pane, 46
Excel formulas and functions, 166-69, 170, 172-73
natural language searches, 84-85
Office Assistant, 40-43, 46-47
ScreenTips, 48
troubleshooting flowchart, 40-41
Help On This Error command, 169, 170
hidden borders
on cells, 140
on objects, 26
hidden commands, 50
hidden data
in Access, 179
in cells, 144, 150-51
hidden e-mail messages, 280-81
hidden page numbers, 456
hidden slides, 354-55
hidden text, 513
checking spelling, 101
in outlines, 382-83
page break markers as, 464
hidden tools on toolbars, 48-49
Hide Slide command, 355
hiding
AutoCorrect Options buttons, 39
background objects on slides, 307
drawings, 28
formulas, 190
graphics on Slide Masters, 375
Office Assistant, 40-41
Office Clipboard, 35
paragraph marks, 432
rows or columns in Excel, 73
screen elements to free memory, 467
slides, 355
sound icons, 324-25
spelling errors, 105
High Color (16 Bit) settings, 363
Highlight Changes dialog box, 72-73, 74, 189, 202
highlighting changes on screen, 73
History worksheet, 513
change history, 189
deleting from workbooks, 188
identifying changes in, 203
restoring changes in files, 202
specifying days to keep, 197
types of tracked items, 73
horizontal scroll bar, 146, 500-501
hours, 164, 288-89
<HTML> code, 502
HTML e-mail format, 216, 267
HTML files (.htm, .html), 513
displaying tags, not content, 500, 502-3
exporting from Excel, 176-77
headers and footers in, 454
opening, 122-23
outlines in HTML format, 97
problems opening, 86, 88-89
saving PowerPoint slide shows as, 390-91, 393
titles in browser bars, 396
troubleshooting flowchart, 116-17
viewing source codes, 502
HTTP (Hypertext Transfer Protocol), 227, 230
.htx files, 502
hyperlinks, 513
compared to linked objects, 320
to frame pages, 507
problems, 86, 96-97, 500, 504-5
on slides, 319
Hypertext Markup Language. See HTML files
Hypertext Transfer Protocol (HTTP), 227, 230
hyphens (-), 136
I
icons. See also tools and toolbars
displaying movie files as, 337
for embedded files, 233, 324-25
Office Clipboard, 32, 34, 35
IF fields, 432, 433
Ignore Words In UPPERCASE feature, 101
ignoring errors in Excel, 168
images. See graphics and pictures
IMAP (Internet Message Access Protocol), 227, 230
Import dialog box, 182
Import Rules command, 265
Import Spreadsheet Wizard, 182-83
Import Text Wizard, 95, 423
importing, 513
Access data into Excel, 178-79, 180-81
clip art, 16-17, 21
digital IDs, 269, 477
embedded objects. See embedding objects
entire files into other files, 122
error messages, 92-93
Excel data
into Access, 182-83
error messages, 92-93
into FrontPage, 176-77
into Outlook, 234-35
into PowerPoint, 308-9
troubleshooting flowchart, 174-75
into Word, 426-28
files into Outlook, 232
FrontPage data into Word, 424-25
graphics into PowerPoint, 310
hyperlink problems, 96-97
movie files into PowerPoint, 337
Outlook objects into other objects, 221
problems opening objects, 90-91
rules, 258, 264-65
troubleshooting flowchart, 86-87
Word data
into Access, 94, 95
outlines into PowerPoint, 97, 303
tables into Access, 94, 422-23
troubleshooting flowchart, 420-21
Inboxes, 259, 262, 513
INCLUDETEXT fields, 448, 466
incorrect page numbers, 462
indents, 405, 489
indexing fields in Access, 183
indexing files with Fast Searching, 78
Indexing Services, 78
inkjet printers, 406
inline objects, 515
Insert Address Block dialog box, 438
Insert Clip Art task pane, 16-17, 21
Insert File icon, 221
Insert Object dialog box, 87
inserting objects. See clip art; drawing objects; embedding objects; exporting; importing; links and linked objects
insertion points, 489
inside borders on pages, 140
installing
digital signature updates, 476-77
Fast Searching feature, 78
file format converters, 445
graphics filters, 446
Office Assistant characters, 43, 44-45
Recover Text Converter, 6
Visual Basic for Applications, 474
interactive triggers, 388
Internet. See also Web publishing
e-mail providers, 227
problems accessing help, 47
SSL (Secure Sockets Layer), 66
Internet E-Mail Settings dialog box, 222, 227
Internet Explorer, 66
Internet Format dialog box, 217
Internet Message Access Protocol (IMAP), 227, 230
intervals for AutoRecover, 10-11
intranet hyperlink destinations, 96
invalid digital IDs, 272
invalid number formats, 171
J
joining meetings, 242-43
journal feature, 514
JPEG format (.jpg files), 120, 506, 514
K
keyboard settings, 38
keys on keyboard, 137, 143
keys in Registry, 486
keywords, 16-17, 20-21
kiosks, 514
L
labels
barcodes, 412, 418-19
on columns in data sources, 437
on Excel charts, 129, 132
on Excel columns, 137, 182, 234, 427
security, 266
landscape pages, 57, 60
language detection, 491
language settings, 51
laser printers, 406
last-saved files, 8
layers of objects, 296-97
layout, defined, 514
layout of pages
headers and footers, 454-55, 460
line numbering, 458-59
page breaks, 452-53
page number problems, 456-57
troubleshooting flowchart, 450-51
layout of slides
missing font styles, 370-71
moving or deleting graphics, 374-75
reapplying layout, 333, 373
replacing fonts, 368-69
scaling pages to fit paper, 61
switching, 372
too many placeholders, 372-73
troubleshooting flowchart, 366-67
LDAP directories, 208-9, 211
leading (line spacing), 28-29, 450
letters, animating, 384, 385, 390
Letters And Mailings command, 427
levels of security
adding trusted sources, 480
changing levels, 472, 473
trust levels, 270-71
licensing fonts, 370
Lightweight Directory Access Protocol (LDAP), 208-9, 211
limiting searches to properties, 80-81
limits
Click and Type feature, 489
conditional formatting, 161
custom dictionaries, 103
Office Clipboard, 35
public folders, 251
slide images on handouts, 343
line breaks, 453, 498
line numbering, 450, 458-59
line spacing, 28-29, 450
lines. See also borders
around notes pages, 356
border colors, 26
deleting on handouts, 346-47
linking outline levels to styles, 405
links and linked objects
Access PivotTables, 178-79
animation on Master slides, 386
availability of linked files, 309
changing sources, 91, 321
in e-mail messages, 237
Excel worksheets and charts, 128-29, 308-9
hyperlinks, 320, 504-5
inserting files in Outlook, 232
inserting portions of files, 238-39
linked files defined, 514
movie clips, 338
multimedia objects, 318
object linking and embedding, 254
opening linked objects, 90-91
pictures on Web pages, 118-19
PowerPoint troubleshooting flowchart, 318-19
shared locations, 69
sound clips and icons, 324-25
troubleshooting flowchart, 86-87
updating linked objects, 320-21
Links dialog box, 91, 321
lists, bulleted or numbered. See bulleted or numbered lists
local hard drives, 202, 449
locale settings, 137
locations
links to shared locations, 69
of recovery files, 9, 11-12
saving to network or local drives, 449
saving to shared locations, 398
shortcuts to net locations, 110-11
of Word templates, 479
locking
aspect ratios, 30, 31
Caps Lock key, 39
Excel cells and objects, 190
Excel controls, 191
Scroll Lock mode, 143
unlocking AutoShapes, 191
logging on
to e-mail accounts, 223
to POP3 servers, 226-27
long file names, 118
loops, 514
Lotus 1-2-3, 143, 152
M
Macro Security button, 478, 480
macros, 514
add-ins, 45
auto macros, 485
Click and Type feature, 489
deleting, 477
digital signatures, 476-77
disabled in templates, 478-79
Microsoft digital signatures, 478
Office Assistant and, 44-45
problems running, 472
security levels, 112-13, 472
SelfCert tool, 473, 481
in templates, 110
troubleshooting flowchart, 472-73
turning off, 45
updating list of trusted sources, 480
upgrading Word and, 474-75
warning about, 112-13, 472-73
Macros dialog box, 485
magnifying view, 54
mail. See e-mail messages; mail merge projects
mail merge projects
blank lines in output, 432-34
change tracking and, 70
from earlier versions of Word, 426
excluding recipients, 428, 437
exporting Excel data, 426-28
exporting HTML data, 424-25
Mail Merge Wizard, 427-28
missing recipient information, 436-37
restoring merged files as Word documents, 430
troubleshooting flowchart, 430-31
unwanted information in output, 450-52
Mail Merge Recipients dialog box, 428, 436
Mail Merge toolbar, 431
Mail Merge Wizard, 427-28
Mail Recipient (As Attachment) command, 68
Mail Recipient command, 68-69
Mail Recipient (For Review) command, 68, 69
main documents, 514
manual actions
feeding envelopes, 414-15
updating dates or times, 455
updating links, 321
manual page breaks, 452, 453, 462, 464
MAPI-compliant e-mail programs, 68
margins
changing, 61
headers and footers, 455
line numbering and, 458
mirroring, 60
page borders and, 406
pages, 60, 407
printing problems, 470
marking up documents. See change tracking; comments
master documents, 11, 448, 462-63, 466
Master Layout command, 329
Master view (PowerPoint), 307, 328, 331
Masters, 514
deleting placeholders, 328-29
displaying graphics on, 331
font problems, 332-33
master slides. See Slide Masters
restoring placeholders, 329
troubleshooting flowchart, 326-27
types of masters in PowerPoint, 307
matching fields in data sources, 437
media clips, 324-25, 337
Media Player, 336-37
Meeting Minder, 514
meetings
delegates, 245
NetMeeting settings, 246-47
responses, 244-45, 248-49, 249
troubleshooting flowchart, 242-43
memory
clip art and, 22
error messages and, 448
freeing up, 467
opening embedded objects and, 240
opening files and, 90
printing graphics and, 466
slow e-mail and, 276-77
system settings, 276
menus and commands
adding commands, 52
COM add-ins, 486-87
custom commands, 474
hiding, 54
missing commands, 50
personalized menus, 50
troubleshooting flowchart, 48-49
merging
digital ID data into contacts, 269
mail merge. See mail merge projects
saved changes into network files, 201
versions of files, 256
Message Security Properties dialog box, 270, 271
Messaging Application Programming Interface (MAPI), 68, 514
metafiles, 18
MHTML files, 88-89, 121, 398, 514
Microsoft Clip Organizer. See Clip Organizer
Microsoft digital signatures, 478
Microsoft Excel. See Excel
Microsoft Exchange. See Exchange
Microsoft FrontPage. See FrontPage documents
Microsoft Graph, 320
Microsoft Internet Explorer, 66
Microsoft Office. See Office
Microsoft Office Tools On The Web site, 47
Microsoft Office XP Language Settings command, 51
Microsoft Outlook. See Outlook
Microsoft Outlook Express, 68
Microsoft PowerPoint. See PowerPoint
Microsoft Query, 426
Microsoft Script Editor, 502, 503
Microsoft SharePoint Team Services. See SharePoint Team Services
Microsoft Windows Me, 394-95
Microsoft Windows Media Player, 336-37
Microsoft Windows Printers folder, 58
Microsoft Word. See Word
MIDI settings, 341
MIME encapsulated aggregate HTML document. See MHTML files
MIME format in e-mail, 216
minus signs (-), 171
minutes, custom formats for, 164
mirror margins, 60
missing items
AutoText entries, 490-91
borders, 26, 403, 406, 411
changes
in attached documents, 218-19
in files, 202-3
in recovered files, 10-11
in reviewed files, 64-65
in saved Word files, 444, 449
in shared files, 200-201
copies of e-mail messages, 222
data in Access PivotTables, 179
elements in Excel charts, 126
embedded objects, 236-37
errors in spell checking, 100-101
files in public folders, 250
fonts, 370-71, 447
formatting in Word tables, 318
graphics, 366, 367, 446-47
gridlines on tables, 322-23
headers or footers, 454-55
numbers on headings, 402
objects in e-mail, 233
page numbers, 450, 456-57
placeholders on Slide Masters, 327
recipient information, 430, 436-37
templates, 495
misspellings, 98-99, 505
Modem Troubleshooter, 47
monitors. See on-screen display
monochrome printing, 350, 352
months, custom formats for, 164
mouse-click animations, 388-89
movement of Office Assistant, 42-43
Movie action buttons, 339
movies, 334, 336-37, 338-39
moving
add-ins, 45
aligning objects, 298-99
cells associated with formulas, 142
graphics on slides, 374-75
linked files, 320
messages into folders, 249
objects, 294, 302-3, 306-7
Office Assistant, 43
page numbers, 456
pieces of clip art, 18
unwanted repositioning after saving files, 506
MPEG files, 336
MS-DOS text formats, 445
multimedia
embedded objects, 318
movie files, 336-37, 338-39
sound files, 340-41
troubleshooting flowchart, 334-35
multiple address books, 213
multiple copies of Excel data, 153
multiple e-mails, forwarding, 220
multiple objects
copying, 302
selecting, 295
multiple worksheets, pasting into, 147
multiple-level category labels, 514
Multipurpose Internet Mail Extensions (MIME), 216
music files. See sound
Musical Instrument Digital Interface settings, 341
mute buttons, 360
My Collections folder, 23
My Computer icon, 63
My Network Places, 395
Next
Last Updated: December 12, 2001
|
