Training
Certifications
Books
Special Offers
Community




 
Troubleshooting Microsoft® Excel Spreadsheets
Author Laurie Ann Ulrich
Pages 368
Disk N/A
Level Beg/Int
Published 12/06/2000
ISBN 9780735611610
ISBN-10 0-7356-1161-0
Price(USD) $19.99
To see this book's discounted price, select a reseller below.
 

More Information

About the Book
Table of Contents
Sample Chapter
Index
Related Series
Related Books
About the Author

Support: Book & CD

Rate this book
Barnes Noble Amazon Quantum Books

 

Index


H
handles, toolbar, 307
headings, column, 83
height, cell, 92
height, row
    adjusting, 16
    specific, 17
    universal, 17
    zero, 22
Help, 162
hidden
    columns, selecting, 21
    data, 216
Hide command, 22
hiding
    changes, 31
    columns, 20, 21, 216
    comments, 27
    rows, 22, 216
    Track Changes command, 31
    worksheet sections, 15
hierarchy of entries, displaying, 119
Highlight Changes dialog box, 30
Highlight Changes On Screen option, 27, 31
highlighting
    cells referenced in formulas, 149
    conditional formatting, 43
    turning on and off, 27, 31
horizontal category axis, 3
HTML format
    naming conventions, 254
    publishing pages, 254
    saving as, 252–54
hyperlinks. See also links
    changing types, 178
    dead, 176
    determining, 176
    editing, 171, 173, 176, 178
    to e-mail window, 178
    to files, 178
    graphics, 171
    inactive, 176
    inserting, 171, 172
    to intranets, 175
    lists of recently visited, 174
    objects, choosing, 172
    planning, 173
    removing, 179
    ScreenTips, 173
    self-referential, 176
    targets, 173
    targets, entering, 177
    targets, moving or deleting, 171, 176
    renaming, 171
    testing, 172, 175
    text, underlined, 176
    types, 172, 174–5, 177, 178–79
    web, finding addresses, 174, 175, 177
    to web sites, 174, 178
    to worksheets, 172, 178–79

I
icons. See buttons on toolbars
identical
    files, naming, 246
    worksheets, 142
identifying active cells, 80
illegible
    charts, 10
    text, 126
image size, 145
Import command, 85
imported objects, editing, 89
importing tables from Word, 93
Import List From Cells box, 85
inactive hyperlinks, 176
inconsistencies, finding/fixing, 110
inconsistent formatting, fixing, 128, 129
Increase Decimal button, 117
Increase Indent button, 119
increasing
    decimals, 117
    font size, 127
    indent, 119
    text size, 127
increments, moving in, 71
indent, applying/adjusting, 119
ineffective displays, 12
input messages, creating, 111
Insert Comment command, 27, 121
Insert Hyperlink command, 171, 172, 174, 179
Insert Hyperlink dialog box, 172, 174, 178
inserting
    comments, 27, 31, 63, 121
    euro symbol, 51
    hyperlinks, 171, 172
    hyperlinks to e-mail windows, 178
    hyperlinks to files, 178
    hyperlinks to intranets, 175
    hyperlinks to web sites, 174, 178
    hyperlinks to worksheets, 178–79
    logos in automated templates, 302
    objects, 90–91
    page breaks, 313
    source data in PivotTables, 230
    text boxes, 53
    .wav files, 90
Insert Name command, 206, 207, 209
Insert Object dialog box, 90
Insert Picture dialog box, 303
Insert Table command, 92
installing
    Euro currency button, 50
    foreign language dictionaries, 280
    Microsoft Map, 191
    printer drivers, 11
    printers, 11
insufficient memory, 89
    to create PivotTable, 221
    for printers, 11
intercept, setting in charts, 13
Internet Assistant Wizard, 254
interpreting ScreenTips, 179
intersecting ranges, 165
intranets, hyperlinks to, 175
Invoice template
    customizing, 303
    inserting logo, 302
    opening, 295
items with no data. See blank, records

K
keeping. See maintaining
keyboard shortcuts
    adding Shift key, 183
    available characters, 182
    euro symbol, 47
    for long terms, 282
    macros, 181, 182, 185
    Replace dialog box, 110
    reusing, 184
    saving, 111, 187
    selecting entire worksheet, 134

L
labeling
    columns, vs. numbering, 311
    maps, 195
labels, 3. See also labels, column; labels, row; maps, labels
labels, column
    blank, 275
    displaying, 105
    displaying on every page, 240, 241
    formatting, 241
    truncated, 273
    unavailable in Sort dialog box, 272, 273
    using in cell names, 206
    using in cell names across multiple worksheets, 209
labels, row
    displaying on every page, 240, 241
    formatting, 241
    using in cell names, 206
    using in cell names across multiple worksheets, 209
Landscape orientation, 11
    error messages regarding, 243
    printing worksheets in, 237
layout diagrams in PivotTables, 227
left alignment, 118
legends, default placement, 9. See also charts, legends; maps, legends
legible
    backgrounds, 145
    fonts, 125
level buttons on outlines, 213
levels, outline, 218
limiting. See restricting
line charts, 12
Line Color command, 73
lines, 13
linked charts, 98–99
links. See also hyperlinks
    breaking, 89, 100
    between charts and worksheets, 6
    copying, 139
    creating, 139
    improper, 6
    maintaining in charts, 99
    updating, 101
Link To File dialog box, 177
List Entries box, 85
lists
    AutoFilter, 108
    completing automatically, 84
    converting from table, 97
    custom, 84–85
    of dates, creating, 59, 84
    Documents, 250
    entries, editing, 85
    filtering, 23 (see also filtering)
    of functions, 160, 166
    hidden rows in, 23
    of hyperlinks, 174
    of names and cells/ranges to which they apply, 207
    of object types, 90
    pasted, updating, 207
    pasting, 207
    ranges, 113
    of recently used files, 249
    of records, 23
    of records for subtotal reports, 286
    sorting, 23
    of styles available, 129
    updating, 207
    of workbooks, viewing, 185
Location bar, 173, 175
locking
    data, 7
    object positions, 68, (see also protection)
logos, inserting in automated templates, 302
Look In field, 261
lost. See missing
lowering monitor resolution, 126

M
Macro dialog box, 181, 186
macro recorder, 187
macros
    avoiding errors, 187
    conflicting procedures, 184
    copying, 183–84
    deleting, 188–89
    describing, 183, 185, 187
    editing, 183, 186
    enabling/disabling viruses, 181, 189
    error messages, 184
    errors, avoiding, 181
    failure, 182, 184
    finding, 184–185
    formatting, 187
    keyboard shortcuts, 181–183, 185
    making available to all workbooks, 182, 184
    missing, 184
    naming, 182, 184–85
    partially working, 184
    planning, 187
    recording, 182–83, 185–87
    replacing, 184
    reusing names, 184
    running, 185
    security, 189
    Stop Recording button, 183, 185
    storing, 183–85
    testing, 187
    viewing code, 183
    viruses, 189
Macros command, 181, 182, 185–86, 188
maintaining chart links, 99
making. See creating
Map button, 191, 193
Map Features command, 194
Map Features dialog box, 194–95
Map Labels button, 195
Map Labels dialog box, 195
maps
    adding features, 193–99
    applying, 192
    changed content, 198
    creating, 192
    deactivating, 198
    error messages, 191
    features unrecognized by Microsoft Map, 195, 197
    focal points, 198
    grouping with other graphics, 199
    labels, 195–97
    legends, 193
    moving, 199
    plotting, 192
    resizing, 198–99
    selecting data for, 192
    using, 192
margins in AutoShapes, 75
marking rounded numbers, 53
Match Case check box, 260
Match Case option, 263
matching
    case, when searching, 259
    column width, Excel vs. Word, 93
    conditional formatting, 43
    criteria, 112
    Word formatting, 93
measuring text, 93
memory
    checking, 221
    insufficient, 89, 221
    printer, 11
menus
    displaying full, 306, 310
    highlighting, 306
Merge And Center command, 93, 132–33
merged cells, 133, 217
Microsoft Access
    converting column labels into field names, 102
    converting Excel workbooks into, 102
    field names, changing, 103
    sorting Excel lists in, 268
    tables, 103
Microsoft Excel
    lists, soring in Access, 268
    versions, saving as older, 89
Microsoft Excel 97, applying euro symbol in, 51
Microsoft Map, installing, 191. See also maps
Microsoft Map dialog box, 193
Microsoft Visual Basic, 186
Microsoft Visual Basic editor, 183, 187
Microsoft Word, 93
missing
    AutoFilter entries, 108
    buttons, 308
    comments, 25
    data in templates, 300
    files, 250
    Formatting toolbar, 306
    labels, 3
    macros, 184
    records, 106
    rows, 22
Modified date, 246
modifying date/time formatting, 63
monetary symbols, 54
monitor resolution, 126–27
months, displaying entire name, 63. See also dates
mouse pointers, 70
moving
    AutoShapes, 70
    between cells, 79
    buttons, 49, 309
    callout lines/subjects, 72
    cell data, 138
    columns, 18–19, 133
    data, 19, 138–39
    formatting, 138
    hyperlinks, 176 (see also hyperlinks, targets)
    in increments, 71
    maps, 199
    named cells, 207
    named ranges, 207
    pushpin labels, 197
    objects, 71
    rows, 19
    source files, 100
    target files, 100
    templates, 298
    template source data, 300
    text, 92–93, 138
    worksheets, 143
    in worksheets, 81
multiple
    cell names, 203
    conditions, 37–39, 42, 45
    fields, filtering, 107
    fields, searching by, 270
    fields, sorting by, 268, 270
    files, selecting, 243
    operations, 151
    workbooks, opening/closing, 242–43
    worksheets, 142
multiplication sign, 149

N
Name box, 80
names. See also titles
    author (see author name)
    cell, lists of, 207
    cell range, lists of, 207
    creating, 208
    creating shortcuts for, 283
naming
    cell ranges, 204–05
    cells, 202–03, 208
    columns, 273
    fields, 273
    files, 246
    folders, 248
    macros, 182, 184, 185
    PivotTable worksheets, 229
    templates, 296
    web pages, 254
    worksheets, 137, 167
naming conventions, 203
negative numbers, 115, 271
nested
    functions, 168–69
    tables, 95
New dialog box, 293, 295–96, 298–99, 303
nonadjacent columns, selecting, 21
noncontiguous cells, selecting, 204
None AutoFormat, 141
non-numeric characters
    alignment of, 118
    in formulas, 149
    in functions, 165
nonsequential ranges, 64
Normal style, 129
Normal view, 11, 313
notes. See comments
Nudge command, 71
nudging. See moving
number
    alignment, 116, 118–19
    formats, 60, 122–23
Number format, 58
numbering columns, 311
numbers
    changing after formatting, 52
    controlling length of entry, 123
    currency, 48
    dates, 58
    decimal places, 49
    default, 48
    euro currency, 50
    formatting (see numbers, formatting)
    fractions, 120–21
    in functions, 165
    incorrect, 52
    negative, 115, 271
    percentages, 115
    phone numbers, 122
    in PivotTables, 227
    as pound signs, 47, 82
    Social Security numbers, 122
    too large/small, 149
    too long, 82
    too wide, 47
    undisplayable, 149
    zip codes, 122
numbers, formatting, 58, 60
    as currency, 48
    custom, 123
    as dates, 58
    decimal places, 49
    default, 48
    as euro currency, 50–51
    as fractions, 120
    as negative, 115
    as percentages, 115
    as phone numbers, 122
    in PivotTables, 227
numeric
    data, 12
    width columns, 83

O
Object dialog box, 90–91
objects
    charts (see charts)
    copying, 70
    editing, 89
    grouping, 68–69
    imported, editing, 89
    inserting, 90–91
    locking positions, 68
    moving, 71
    multiple, 68–69
    types, 90–91
    ungrouping, 69
Office Assistant, 162–63, 260
Open command, 242–43, 298–99
Open dialog box, 242–43, 249–51, 298–99
opening
    files, 249
    forms, 264
    templates, 293, 295–96
    toolbars, 309
    workbooks, 189, 242–43, 310
    worksheets, 178
operations, mathematic
    multiple, 151
    order, 150
operators, choosing, 37–38
Options command, 29, 84–85
Options dialog box, 29, 84–85, 147, 157, 181, 249, 310, 313
OR criteria, 39
order of operations, 150
orientation, page, 11, 77
ornate fonts, 125
outlines
    adding, 213
    collapsing, 213, 218
    creating, 211–12, 218
    expanding, 213
    level buttons, 212
    levels, 212, 218
    removing, 211, 215
    sorting columns for, 212
    subtotal report as, 215
overflow text, 82, 125
overlapping
    conditions, 37, 42, 45
    map labels, 197
overriding password protection, 246

P
page break preview, 239
Page Break Preview command, 10
Page Break Preview view, 313
page breaks, 313
page orientation, 11, 77
Page Setup dialog box, 235–37
paper clip. See Office Assistant
paragraph text, 130
parentheses
    errors with, 150
    formulas, 149, 151
    multiple operations in, 151
partial dates, displaying, 59
partial worksheets, printing, 238
password protection, 7
    applying, 135, 247
    bypassing, 246
passwords, 134
    applying, 65
    creating, 135
    setting, 135
    workbook, 246
Paste command, 89, 95–96, 98, 299
Paste Function command, 160, 166, 168
Paste Function dialog box, 159–60, 166, 168
Paste Link command, 99, 139
Paste Name dialog box, 207
Paste Special command, 98–99, 138–39
Paste Special dialog box, 99, 139
pasting. See also copying
    borders, 93
    cell shading, 93
    from Excel to Word, 94
    lists, 207
    tables, 92
    text, 96
    from Word to Excel, 92
patterns. See trends
payment function, 163
Percentage format, 58
percentages, formatting numbers as, 115
Percentage Style command, 115
Percent style, 129
Personal Macro Workbook, 183
    copying macros to, 184
    saving, 183, 185
    storing macros in, 183–85
    unhiding, 183, 186, 188
phone numbers, formatting numbers as, 122
phrasing arguments, 165
pie charts, 12–13
PivotTable dialog box, 222
PivotTable Field dialog box, 224, 226–27
PivotTable Options dialog box, 227, 231
PivotTables
    blank records in, 226–27
    copying, 232
    creating, 221–222
    creating new tables from, 229
    creating new worksheets in, 228
    Data section, 228
    default settings, 226–27
    duplicating, 232–33
    editing, 221–22
    failure to update, 230
    fields, 223–24
    field settings, 227
    formatting, 233
    functions, 227
    inserting new data, 221
    layout, 223, 227
    numbers, 227
    redoing, 222
    refreshing, 221, 230–31
    selecting, 230, 232
    source data, 223–25, 230
    updating (see PivotTables, refreshing)
    worksheets, 223, 229
PivotTable toolbar, 222
PivotTable Wizard, 222, 224
    displaying, 224
    Layout dialog box, 223
    rerunning, 230
planning
    hyperlinks, 173
    macros, 187
plotting
    chart options, 3
    data, 4, 5, 13
    features unrecognized by Microsoft Map, 197
    maps, 192
    series, 5
    totals, 4
point size, 93
Portrait orientation, 237
pound signs, 82
    instead of numbers, 47, 82
precedents, 152
    revealing, 153
    tracing, 153, 156
preventing
    changes, 65
    edits, 135
previewing worksheets, 127
print areas
    clearing, 238
    expanding/reducing, 239
    replacing, 239
    searching for, 239
    setting, 238–39
Print command, 11
Print dialog box, 235, 238, 243
printer drivers. See printers
printers, 11
printing
    charts, 10
    comments, 25
    default settings for, 236
    error messages, 243
    euro symbol, 51
    gridlines, 235
    settings, 127
    worksheets, 235–38
print jobs, canceling, 11
Print Preview, 237, 241
Print Preview command, 10
print scale, 127
programs. See software
Project Explorer, 183
Properties command, 29
Properties dialog box, 29, 251
Protect Sheet dialog box, 7, 134
protecting
    data, 7
    templates, 300
    worksheets, 7
protection, 134. See also security
    applying, 65, 247
    bypassing, 65
    cells, 65
    edits, allowing/preventing, 134, 135
    passwords, 134–35
Protection tab, 7
Publish As Web Page dialog box, 253
Publish command, 253
publishing workbooks as web pages, 145, 253
punctuation
    in cell names, 201
    in functions, 167
Purchase Order template, 295
pushpins, 197

Q
quotation marks in formulas, 149

R
R1C1 reference style, 311
random width and height cells, 92
range references, 5
ranges, annotating, 121
ranges, cell. See cell ranges
range statement. See data, range
read-only files, 246
read-only status, 65
realigning text in AutoShapes, 77
reapplying functions in subtotal reports, 290
rearranging
    buttons, 305
    columns, 18
    rows, 19
    toolbars, 305, 307
recently used files, 249, 311
recognizing software, 90–91
recording macros, 182–83, 185–87
Record Macro dialog box, 182, 187
Record New Macro command, 182, 185
records
    blank, 275
    deleting, 275
    disappearing, 106
    excluded by filtering, 106
    filtering, 106
    lists of, 23, 286
    missing, 106
    in PivotTables, 226–27
    searching, 258–59
recycling data, 84
redisplaying
    columns, 20
    comments, 27
redoing PivotTables, 222
reducing
    decimal places, 47
    print areas, 239
    subtotal reports, 289
references, cell. See cell references
Refresh Data command, 230
refreshing
    PivotTables, 221, 230–31
    problems with, 225, 227
regional settings, 54–55
Regional Settings Properties dialog box, 55
reinstalling printer drivers, 11
Reject All command, 33
rejecting changes, 31–33
relocating
    hyperlink targets, 171
    template source data, 300
Remove All button, 215
removing. See also deleting; uninstalling
    Author name, 28–29
    comments, 26
    conditional formatting, 44
    decimal places, 47, 52–54
    filtering criteria, 107
    filters, 109
    hyperlinks, 179
    outlines, 211, 215
    rounding, 52–53
    subtotals, 215
    user names, 28
    words from spelling checker dictionary, 279
renaming
    files, 100, 251
    hyperlinks, 171
    trendlines, 12
    workbooks, 245
reordering
    columns, 18
    formulas, 150
    rows, 19
    worksheets, 143
repeating data, 84
Replace All command, 111, 257, 262–63
    failure, 257
    reversing, 262
    setting up correctly, 263
    undoing, 262
Replace dialog box, 110, 263
replacing, 110
    cells, 149, 257
    macros, 184
    matching case and, 257
    print areas, 239
    subtotals in subtotal reports, 288
reports
    creating based on filtering results, 113
    subtotal (see subtotal reports)
rerunning Pivot Table Wizard, 230
resizing
    AutoShapes, 70, 74–75
    callouts, 72
    charts, 3, 8–9, 11
    columns, 15, 23, 47, 92, 131
    fonts, 3
    labels, 3
    maps, 198–99
    rows, 16–17, 22, 23, 92, 130
    tables, 92
    text, 3
    WordArt, 77
restricting entries, 79, 111
restoring
    default formatting, 141
    formula references, 149
    regional settings, 55
restricted
    commands, 81
    searches, 261
restricting data, 87
reusing keyboard shortcuts, 184
revealing
    columns, 21
    formulas, 153, 155
    precedents/dependents, 153
    records, 106
    truncated data, 83
reversing
    cell entries, 81
    Replace All command, 262
reviewing
    cell names, 205
    changes, 32–33
right alignment, 119
roads. See maps, adding features
rotating AutoShape and WordArt to same angle, 76–77
Rotation spin box, 77
rounded numbers. See rounding.
rounding, 52–53
row labels
    displaying on every page, 240–41
    formatting, 241
    using in cell names, 206
    using in cell names across multiple worksheets, 209
Row Height command, 17
Row Height dialog box, 17
rows, 17
    blank, 267, 274, 286
    centering title across top, 132
    excluding from sort, 133
    filtering, 23, 108
    grouping, 219
    headings, 105
    height, 16–17, 22, 23, 192, 130
    hiding, 22, 216
    in lists, 23
    missing, 22
    moving, 19
    out of order, 19
    rearranging, 19
    reordering, 19
    resizing, 16–17, 23, 92
    selecting, 4, 15–16, 219
    sorted, 213
    sorting, 23
    top, centering across, 132
    ungrouping, 219
    unhiding, 22–23
rules, data validation, 86–87
running macros, 185

S
Save As command, 247, 250, 252
Save As dialog box, 89, 135, 247, 252–53, 293, 296–97
Save As HTML command, 253
Save As Web Page command, 253
Save command, 248, 295
Save Options dialog box, 135, 247
Save Template dialog box, 303
saving, 111
    default location, 248–49
    to different folders, 252
    error messages, 246
    failure, 246
    as HTML, 252
    keyboard shortcut, 111, 187
    macros, 183–85
    Personal Macro Workbook, 183, 185
    read-only files, 246
    spelling checker dictionary, 279
    templates, 293, 295, 298
    too much data, 252
    as web page, 145
    workbooks, 89, 245
    worksheets as web pages, 145, 252
scaling worksheets, 237
scanning viruses, 181, 189
scatter charts, 12
Scientific format, 58
ScreenTips
    creating, 173
    interpreting, 179
    testing, 172
    text, 173
searchable databases, 205
search criteria, 250–51
    checking, 260
    no matches, 260
searching, 109. See also checking; finding
    in comments, 261
    database, 109
    error messages, 260
    by example, 264
    for files, 250–51
    with forms, 264–65
    for functions, 160
    for macros, 184–85
    in multiple worksheets, 261
    numbers, 265
    for print areas, 239
    for records, 258–59
    single letter/number, 109
    web, 175, 177
    for web site, 175, 177
    for workbooks, 250
search operators, 265
sections. See ranges
security. See also protection
    hyperlinks to intranets, 175
    macros, 189
    password protection, 246–47
segmented lines, 13
Select All command, 83
Select Changes to Accept or Reject dialog box, 32
Select Entire Table command, 230, 232
selecting. See also choosing
    AutoShapes, 75
    axes, 9
    cell names, 207
    cell ranges, 40, 230
    cells, 57, 113
    chart axes, 9
    charts, 12
    chart types, 3
    columns, 19, 21, 219, 259, 272
    conditional formatting, 41
    data, 5, 192
    files, 243
    fonts, 9, 125
    improperly, 4
    noncontiguous cells, 204
    objects, 68
    PivotTables, 230, 232
    ranges, 4–5, 17, 36, 40, 64, 112–13, 129, 224
    rows, 4, 15–16, 219
    tables, 97, 230, 232
    visible cells, 216
    worksheets, 15, 17, 21, 23, 83, 134, 209, 261
selections, sorting, 271
Select Objects command, 68–69
self-referential hyperlinks, 176
separating
    sections, 16
    toolbars sharing a row, 307
sequence, correct for filtering, 107
series
    data, 13
    plotting, 5
Set Hyperlink Screen Tip dialog box, 173
Set Intercept, 13
Set Item dialog box, 101
Set Print Area command, 239
setting
    criteria, 112
    default AutoShapes, 67
    passwords, 135
    print areas, 238–39
    validation rules, 123
settings for regional currency formatting, 54
setting up
    conditional formatting, 36, 38–39
    databases, 274
    Replace All command, 263
severing links, 100
shading, applying, 80, 137
sharing author name, 29
Shift and Move command, 19
Shift Down And Move, 19
Shift key, adding to keyboard shortcuts, 183
Shift Right And Move command, 19
Shortcut Key dialog box, 182
shortcuts. See keyboard shortcuts
Show All command, 107, 109–10
Show Auditing Toolbar command, 157
similar data, 84
size of text, 16, 93, 127
sizing. See resizing
Snap To Grid command, 71
Social Security numbers, 122
software
    checking whether installed, 90
    recognizing, 90–91
    uninstalling, 90–91
Sort Ascending button, 268, 270–71
Sort command, 23, 133, 267, 271–72, 274
Sort Descending button, 268, 270
Sort dialog box, 133, 268–69, 271–73, 291
    column labels unavailable in, 272–73
    field names in, 273
    levels, 268
    options, 269
sorted columns as outline levels, 212
sorted rows, breaking into groups, 213
sorting
    ascending vs. descending order, 269–70, 272
    blank cells, 271
    blank rows, 267
    case-sensitive, 269
    columns for outlines, 212
    data, 267
    error messages, 267, 274
    Excel lists in Access, 268
    excluding header row, 133
    failure, 274
    by field, 268
    fields with numeric content, 271
    hidden rows, 23
    lists, 23
    by multiple fields, 268, 270–71
    negative numbers, 271
    order, 268
    rows, blank, 267
    selected ranges, 271
    selection outside database, 272
    unexpected results, 270
    worksheets, 219
sort order, 268
Sort Warning dialog box, 133
source data, 4, 6
Source Data command, 4
Source Data dialog box, 4, 7
source files, 98
    changing, 101
    deleting, 100
    links to target files, 98
    moving, 100
    renaming, 100
source worksheet, 217
spaces in cell names, 201, 203
spacing charts, 9
Special button, 216
Special format, 122
spelling checker, 278
    adding words to, 278
    deleting words from, 279
    dictionary, saving, 279
    dictionaries, switching, 281
    editing, 279
    failure to flag all errors, 278
    foreign languages, 280
    ignoring uppercase, 277–79
Spelling dialog box, 277–79, 281
split cells, 92
standard font, 311
Stop Recording button, 183
storing
    decimal places, 52
    macros, 183–85
structural errors in formulas, 164
structure of databases, correct, 274
Style command, 129
Style dialog box, 129
styles, 129
Subtotal command, 213, 215
Subtotal dialog box, 213, 215, 285, 288, 290–91
subtotal reports
    content for, 286–87
    creating, 215, 287
    criteria for, 286
    data in, 287
    deleting, 285
    displaying entire list, 289
    error messages, 286
    expanding/collapsing, 289
    fields, too many, 291
    functions, 288, 290–91
    list of records, 286
    as outlines, 215
    reducing to single field, 289
    reducing to subtotals, 289
    subtotals, replacing, 288
    subtotals in wrong place, 288
    too many fields, 291
subtotals, removing, 215
Subtotals command, 285–86
subtotals records functions, incorrect, 290
Sum function, 213
Summarize By dialog box, 223
summary data, 216
summary worksheet formulas, 156
switching windows, 175
symbols
    currency, 49, 54–55
    euro, 51
    monetary, 54
system resources, freeing up, 89

T
table text, moving, 92, 93
Table To Text command, 97
tables
    Access, 103
    borders, 16
    creating, 229
    elements in Word, 97
    importing from Word, 93
    moving text, 92
    nested, 95
    pasting, 92
    PivotTables (see PivotTables)
    resizing, 92
    selecting, 97, 230, 232
    text, moving, 92, 93
    Word, 92, 94, 97
tabular lists, converting from table, 97
target
    cells, deleting, 149, 165
    files, 98, 100
    hyperlinks (see hyperlinks, targets)
    worksheet, 217
templates
    automated, customizing, 303
    converting workbooks into, 295
    copying, 299
    customizing, 303
    editing, 293
    finding, 298
    folder, 293
    missing data, 300
    moving into correct folder, 298
    naming, 296
    opening, 293, 295–96
    protecting, 300
    saving, 293, 295, 298
    source data, 300–01
    user-created vs. automated, 295
    when to use, 297
testing
    cell names, 209
    formulas, 150
    functions, 163
    hyperlinks, 172, 175
    macros, 187
    ScreenTips, 172
text. See also data
    in AutoShapes, 74–77
    boxes, ScreenTip, 173
    boxes, transparent, 131
    in charts, jumbled, 8
    colors, 145
    copied, formatting, 128
    copying, 96
    cut off, 16, 82–83
    formatting, 134
    in formulas, 149
    hyperlink, 176
    illegible, 126
    invisible, 125
    labels, formatting, 9
    measuring, 93
    moving in table, 92–93
    moving without formatting, 139
    overflow, 82, 125
    paragraph, 130
    pasting, 96
    point size, 93
    removing formatting from, 139
    resizing, 3
    ScreenTips, entering, 173
    size, 16, 93, 127
    table, moving, 92–93
    too much, 82
    too small, 126
    too wide, 125
    truncated, 82–83
    unrecognizable, 149, 165
    wrapping, 83, 92, 131
Text Box command, 53, 131
text boxes, 131
    backgrounds, clear, 131
    creating, 131
    inserting, 53
    transparent, 131
time, displaying/formatting, 63
time format, 55
title bars, toolbars, 307
titles. See also names, 133
    centering, 132
    choosing, 133
toolbar buttons. See buttons on toolbars
Toolbar dialog box, 309
toolbar handles, 307
toolbars
    adding buttons, 191, 308–09
    creating, 309
    displaying, 307
    docking, 307
    dragging, 307
    floating, 306–07
    icons, 313
    missing buttons, 308
    moving buttons, 309
    opening, 309
    rearranging, 305, 307
    sharing a row, 306–07
    title bars, 307
tools, Freeform line, 13
totals, plotting, 4
Trace Dependents command, 149, 157
Trace Precedents command, 149, 153, 156, 301
tracing
    dependents, 157
    precedents, 153, 156
Track Changes command, 26, 28, 30
    changes, 31–33
    comments, changing, 26
    comments, hiding, 27
    deactivating, 31
    hiding, 31
    highlighting, 26–27, 31
    settings, 30
    turning on and off, 30–31, 33
    viewing, 31
transparent text boxes, 131
transposed dates, 60
trendlines
    adding, 12
    drawing, 13
    renaming, 12
trends
    complex, 13
    displaying, 12
truncated
    column headings/field names, 273
    text, 82
turning off Office Assistant, 163

U
unavailable
    cells referenced in functions, 164
    commands, 81, 144
    object types, 91
underscores, in cell names, 203
understanding
    functions, 162
    ScreenTips, 179
undisplayable numbers, 149
Undo command, 33, 48, 51, 95, 233, 262, 270
undoing
    currency formatting, 48
    left alignment, 118
    Replace All command, 262
Unfreeze Panes command, 105
Ungroup command, 69, 219
ungrouping
    columns, 219
    objects, 69
    rows, 219
    worksheets, 143, 144, 209
Ungroup Sheets command, 143, 261
Unhide command, 21–22, 183
unhiding
    columns, 20–21, 23
    Personal Macro Workbook, 183, 186, 188
    rows, 22–23
uninstalling software, 90–91
universal formatting, 57
unrecognizable text, 149, 165
unwanted decimal places, 47
updating
    charts, 98
    conditional formatting, 42
    formulas, 152
    links, 101
    list of recently used files, 249
    PivotTables (see PivotTables, refreshing)
    ranges, 207
    worksheets, 6
uppercase letters, in spelling check. See spelling checker
URLs, 175
Use Function list, 213
user name. See author name
using. See also applying
    Help, 162
    maps, 192

V
validating data, 123. See also data validation
validation rules, setting, 123
value text box, 41
values
    comparison, 39 (see also conditional formatting)
    copying, 139
verifying location of template source data, 301
vertical value axis, 3
viewing
    cells referenced in formulas, 149
    external cell references, 157
    formulas, 147, 157
    formulas vs. results, 313
    list of workbooks, 185
    macro code, 183
    page breaks, 313
    precedents/dependents, 153
    Project Explorer, 183
views
    Normal, 11, 313
    Page Break Preview, 313
viruses
    macros, 181, 189
    protection software, 189
    scanning for, 181, 189
visible gridlines, 137

W
.wav files, 90
web addresses, 175. See also hyperlinks, web
    searching for, 175, 177
web browsers, 125, 177
web pages
    backgrounds, 145
    naming, 254
    publishing, 254
    viewing in default browser, 253
    workbooks as, 145
    worksheets as, 145, 252
web sites, hyperlinks to, 174, 178
white space, 16
wide columns, 83
widening columns, 21, 82–83, 131
wide numbers, 47
wide text, 125
width
    cells, random, 92
    columns, 83
wildcard character, 265
windows
    switching, 175
    color, 306, 310, 312
Word. See Microsoft Word
Word tables. See tables, Word
WordArt
    adding to AutoShapes, 76
    deselecting, 77
    resizing, 77
    rotating to same angle as AutoShape, 77
WordArt Gallery dialog box, 76
wording, 165
workbooks. See also worksheets
    active, running macros in, 182
    converting into Access, 102
    converting into templates, 295
    copying between, 139
    default number of worksheets, 310
    default save location, 248–249
    filename extensions, 245
    graphics, 145
    hyperlinks to, 172
    identical, creating (see templates)
    missing, 250
    multiple, 242–43
    opening, 189, 242–43, 310
    password-protected, 246
    publishing as web pages, 145, 252
    read-only, 246
    renaming, 245
    saving, 89, 245–46
    saving as HTML, 252
    saving location, 248, 250
    scanning for viruses, 189
    searching for, 250
    vs. worksheets, as web pages, 145
worksheets. See also workbooks
    backgrounds, 144
    borders, 16
    copying between, 139
    creating, 142
    creating outlines with, 212, 218
    data, plotting on maps, 192
    default number, 310–11
    duplicating, 142
    formatting, 142
    in formulas, deleting, 149
    formulas, summary, 156
    gridlines, color, 312–13
    grouping, 142–44, 208–09, 261
    hiding sections, 15
    hyperlinks to, 178–79
    moving to beginning, 81
    multiple, 142, 261
    naming, 137, 167
    new, opening with hyperlinks, 178–79
    opening, 178
    password protection, 7
    PivotTables, 223, 228–29
    portions, outlines of, 211
    previewing, 127
    printing, 235–238 (see also print areas)
    protecting, 7, 134–135
    rearranging, 143
    scaling, 237
    as searchable databases, 205
    selecting, 15, 17, 21, 23, 83, 134, 209, 261
    sorting, 219
    source, 217
    subtotal reports, checking content for, 286
    target, 217
    titles, 133
    too long, 237
    ungrouping, 143–44, 209
    updating, 6
    as web pages, 145
    vs. workbooks as web pages, 145
Wrap Text command, 93
wrapped text, 92, 131
wrapping text, 83

Y
years, four-digit, 64. See also dates

Z
zero height, row, 22
zeros, disappearing, 116
zip codes, formatting numbers as, 122


Previous




Top of Page


Last Updated: Friday, July 6, 2001