|
|
 |
|
|
|
Troubleshooting Microsoft® Excel 2002
|
|
|
Author |
|
Laurie Ann Ulrich
|
|
|
Pages |
432
|
|
Disk |
N/A
|
|
Level |
Beg/Int
|
|
Published |
04/03/2002
|
|
ISBN |
9780735614932
|
|
ISBN-10 |
0-7356-1493-8
|
|
Price(USD) |
$19.99
To see this book's discounted price, select a reseller below.
|
|
|
|
|
|
|
|
|
Index
: (colon), formulas and, 181
$ (dollar sign), referencing cells, 5
= (equal to) operator, 46, 299
! (exclamation point), referencing cells, 5
> (greater than) operator, 46, 299
< (less than) operator, 46, 299
( ) (parentheses)
formulas and, 181, 185
functions and, 203
+ (plus sign), expanding worksheets, 341
# (pound sign), when numbers appear as, 57
? (question mark), help feature, 197
* (wildcard) operator, 299
A
Accept or Reject Changes dialog box, 43
Access
Excel databases, sorting in, 312
Excel data, importing into, 134-35
Excel date formats, compatibility, 84-85
pasting content to, 20-21
sorting capacity of, 312
active cell, selecting, 110-11
Add Shape button, Diagram toolbar, 91
Add Trendline dialog box, 12
Add/Delete Word(s), Speech Recognition toolbar, 326-27
add-ins, downloading from Web, 366-67
Add/Remove Hardware, 211
Add/Remove Programs, 123, 208-09
Advanced Filter, 144-45, 339
Advanced Search link, 307
Align Left, Formatting toolbar, 150
Align Right, Formatting toolbar, 151
Allow Cell Drag And Drop, Options dialog box, 79
Always Show Full Menus check box, 371-72
And/Or criteria, 49
Answer Wizard, 362
arrow keys, moving objects, 100-101
Arrow tool, Drawing toolbar, 13, 103
Assistance Center, Tools on the Web, 361
auditing formulas, 180
Auto Outline
error messages, 248-49
"Modify the current outline" message, 249
outlining worksheets, 246
AutoComplete, overriding, 108
AutoCorrect
in Microsoft Word, 16
terms, adding, 334
terms, removing, 335
unwanted spelling corrections from, 329
AutoFill, 79
AutoFilter
blank fields, finding, 137
database records, finding, 292-93
database requirements and, 339
records, missing criteria, 140-41
AutoFormat
diagrams, 89
editing, 172-73
PivotTables, 267
removing, 173
automatic updates, 130
AutoShapes tool
diagrams, 88, 93
Freeform tool and, 13
shapes, changing, 97
shapes, creating default AutoShape, 96
shapes, selecting, 89
size changes when moving, 100
text boxes and, 90
text, fitting text into AutoShape, 104-05
text rotation and, 106-07
when missing from Format menu, 97
axis labels, 12-13
axis titles, 9
B
bar charts, 12
blank data, PivotTables, 260-61
blank fields, filtering records, 137
blank workbook, hyperlinks creating, 222-23
blinking insertion points, 111
blue drop-down arrows, filters, 138-39
blue triangle
indicating edited cells, 41
indicating Track-Change comments, 36, 38
turning on/off, 37
bold format, row height and, 26
Break Link button, 132
browsing
default browser, 360
hyperlinks and, 219, 221
C
calculator, discrepancy with formulas, 184-85
callouts
comments vs., 102
fraction formatting and, 153
not pointing to correct items, 102-03
Caps Lock, accidental use of, 335
Case Sensitive check box, Sort dialog box, 313
cell names, 234-43
column and row labels, converting into names, 240-41
flowchart, 234-35
locating cells and, 236
in multiple worksheets, 242-43
naming ranges of cells, 238-39
renaming/deleting old names, 237
rules for, 241
steps in, 237
cell ranges
content, entering into, 109
naming, 238-39
PivotTable reports, 258
referencing, 5
selecting noncontiguous, 46
Cell Reference box, 217
Cell Value Is, 47-48
cells
active, selecting, 110-11
comment symbols in, 36
conditional formatting and, 50, 51
content, cutting/copying, 22-23
content, entering into range of cells, 109
content, moving, 125
content, risk of replacing during moves, 29
formats of, 84
moving cell without moving formatting, 170-71
referencing, 181
referencing functions in, 200-201
referencing ranges in, 5
selecting active, 110-11
shading, 169
when cell reference changes but formula results don't, 186-88
Change Button Image, toolbar buttons, 373
chart objects, resizing, 8-9
Chart Wizard, 5
charts
columns, selecting noncontiguous, 5
exporting into Word, 130-33
flowchart, 2-3
printing, 10-11
protecting, 7
resizing, 8-9
types, 2, 3, 12-13
unwanted data, 4-5
updating, 6-7, 131
circular references, formulas, 181
clip art
installing, 208-09
organizing, 212-13
sources of, 208
Clip Gallery, 206-07
Clip Organizer
accessing, 212
clip art, organizing, 212-13
collection categories, 213
searching for graphics, 206-07
clipboard
cutting/copying content, 22-23
flowchart, 14-15
interactive buttons on, 16-17
links, creating/severing, 18-19
memory capacity and, 22
pasting content from, 20-21
removing items from, 22
text, moving between diagrams, 95
Web content, saving to, 288
clipboard task pane, 21
colon (:), formulas and, 181
color
of diagrams, 92-93
of gridlines, 376
Line Color button, 103
of text, 376
column and row labels
in Access, 135
cell names created from, 240-41
not appearing in Sort dialog box, 316-17
not appearing on all pages of printout, 274-75
repeated in multiple worksheets, 243
column charts, showing trends, 12
columns and rows
columns, hiding/unhiding, 30-31,
columns, moving contiguous, 29
columns, out of order, 28-29
columns, resizing, 124
columns, risk of replacing content during moves, 29
columns, width of, 112-13
flowchart, 24-25
rows, height adjustments, 26-27
rows, hiding/unhiding, 32-33
rows, out of order, 29
comment box, removing user name from, 38-39
comments, 34-43. See also Track-Change comments
callouts vs., 102
comment box, removing name from, 38-39
conditions, defining, 49
date formats, defining, 83
flowchart, 34-35
fraction formats, defining, 153
inserting, 37
popping up when not wanted, 36-37
conditional formatting, 44-55
changing/deleting, 54-55
comments and, 49
flowchart, 44-45
formats not updated when worksheets are edited, 52-53
multiple conditions, 48-49
setting up, 46-47
starting over, 51
when it doesn't work, 50-51
Conditional Formatting dialog box, 46, 47, 51
content
cutting/copying, 22-23, 127-28
diagrams, changing on, 87
moving between cells, 125
pasting, 20-21, 127
range of cells, entering into, 109, 319
risk of replacing during moves, 29
Web content, saving to clipboard, 288
cookie cutters. See templates
Copy. See also cutting/copying content
content, risk of replacing during moves, 29
Ctrl+C shortcut, 128
links between blocks of cells, 19
Create Names dialog box, 240, 243
Criteria button, Form dialog box, 298-99
cross-shaped pointer (AutoFill handle), 79
CryptoAPI, 281
cryptography, 305. See also encryption
Ctrl key
column selection, 5
noncontiguous cell range selection, 46
Ctrl+A, worksheet selection, 33, 141
Ctrl+C, Copy, 128
Ctrl+F, Find, 141, 293-94
Ctrl+H, Find and Replace, 142
Ctrl+O, Open, 283
Ctrl+S, Save, 142
Ctrl+V, Paste, 127
Ctrl+X, Cut, 95, 127
Ctrl+Z, Undo, 127
currency, 57-65
currency formatted numbers, searching for, 299
Currency Style button, undoing effects of, 58-59
customizing formats, 59
Decimal Places settings, 62-63
euro currency, 60-61
flowchart, 56-57
foreign currency, 64-65
Custom AutoFilter feature, 138
custom charts, 3
Custom Dictionaries dialog box, 331
custom formats
currency, 59
dates, 82-83
numbers, 154-55
Custom Lists, 114-15
custom spell checking, 329
custom templates, 354-56
custom workspace. See workspace customization
Customize dialog box, 371
Cut command, 29
Cut, Ctrl+X, 95, 127
cutting/copying content, 22-23, 95, 127-28
D
dashed lines, around copied cells, 14
data analysis, 66-75
data table setup error, 68-69
flowchart, 66-67
Goal Seek feature, 74-75
Scenarios tool, 70-71
Solver, 72-73
data entry, 108-19
active cell, selecting, 110-11
charts, removing unwanted data from, 4-5
column width, 112-13
custom lists, 114-15
data validation rules, 116-17
flowchart, 108-09
symbols, 118-19
Data menu
Filter, 33, 339
Group and Outline, 247, 253
PivotTable and PivotChart Report, 258
Refresh Data, 264
Sort, 33, 315-16
Subtotals, 338
Data Range, charts, 4, 6
data, sorting
database not set up properly for sorting, 318-19
fields, sorting by more than one, 312-13
flowchart, 310-11
Sort dialog box, column labels not appearing in, 316-17
unexpected results, 314-15
data tables
building, 68-69
defined, 68
removing, 69
data validation
applying, 143
checking, 116-17
conditional formatting and, 52-53
database content and, 319
not working, 116
number formatting and, 155
databases
content requirements, 319
finding records, 292-93
saving after edits, 142
sorting, 311, 318-19
structural requirements of, 318
subtotal report requirements, 338-39
Date format, Format Cells dialog box, 78-79
dates, 76-85
Access, compatibility with Excel formats, 84-85
adding time to, 83
cell formats and, 78-79
customizing formats, 82-83
day and month transposed, 80-81
default General formats, 79
flowchart, 76-77
format options, 81
day and month transposed, date formats, 80-81
day of the week options, 81
decimals places
currency and, 62-63
Format Cells dialog box, 59
setting number of, 148-49
Decrease Decimal, Formatting toolbar, 62, 148-49
defaults, customizing, 375
Define command, naming cells, 238-39
Define Name dialog box, 237-38, 242-43
Delete Comment, 35
Delete Conditional Formatting dialog box, 55
dependent cells, formulas, 186-88
Diagram Style Gallery, 92-93
Diagram toolbar, 88, 90, 91
diagrams, 86-100
building from scratch, 93
content, 87
flowchart, 86-87
layout and color, 92-93
organization charts and, 95
reformatting, 90
resizing, 89
shapes, adding, 90
shapes, changing, 87
text, does not fit in allocated space, 89-90
text, placement, 94-95
types, 86-87
dial-up status, 360-61
dictation errors, 324-25. See also speech recognition
dictionaries, checking spelling
foreign languages and, 332-33
misspelled words, removed from, 331
Display Properties dialog box
gridline color, 376
monitor resolution, 158-59
#DIV/0!, formula/function errors, 181, 198
dollar sign ($), referencing cells, 5
Download Center, updates and add-ins from, 366-67
drag-and-drop/dragging
cell content, moving, 125
cell content, moving content without moving formatting, 171
columns, widening, 30
objects, moving, 100
PivotTables, rearranging, 259
turning on, 79
Draw menu, Nudge option, 101
drawing shapes and lines, 96-107
AutoShape, changes size when moving, 100
AutoShape, text fitting and, 104-05
AutoShape, text rotation and, 106-07
callouts, not pointing to correct items, 102-03
flowchart, 96-97
grouping objects and, 98-99
objects, techniques for moving, 100-101
Drawing toolbar
Arrow Style, 103
displaying, 97
Group, 99
inserting text boxes, 63
Line Color button, 103
Line or Arrow tools, 13
multiple objects, selecting and grouping, 98-99
Text Box, 163
drivers, reinstalling, 210-11
drop-down arrows, blue, 138-39
E
Edit Comment command, 38
Edit Hyperlink command, 220, 222
Edit menu
Find, 293-94
Links, 132
Undo, 296
e-mail, regional settings, 65
encryption, 281. See also cryptography
Enter (keyboard shortcut), moving between cells, 111
environmental noise, speech recognition and, 322
equal to (=) operator, 46, 299
Error Alert tab, data validation, 143
errors
Advanced Filter feature, 144-45
Auto Outline, 248-49
conditional formatting, 51
data table setup, 68
dictation, 324-25
Find command, 294-95
formulas, 180-82
functions, 198-99
imported objects, editing, 120
macros, 228, 230-31
sorting data, 311, 318
spelling, 330-31
subtotal reports, 338-39
euro currency, 60-61
Euro Currency Tools add-in, 60
exclamation point (!), referencing cell ranges and, 5
export/import, 120-35
Access tables, exporting Excel data into, 134-35
flowchart, 120-21
object types supported, 122-23
Word documents, exporting charts into, 130-33
Word tables, exporting Excel cells into, 126-28
Word tables, importing into Excel, 124-25
F
field names, sorting data and, 317
File menu
Close, 277
Open, 276
Print Preview, 271
Save As, 286-87
File Properties dialog box
keyword searches, 307
name, changing/removing, 306-07
files
finding, 350-51
naming, 281, 286-87
protecting, 280-81, 303
read-only option, 281
Recently Used File List, 283, 375
saving as templates (.xlt files), 351
saving to new locations, 286-87
searching for, 284-85
filters, 136-45
Advanced Filter feature, 144-45
AutoFilter, missing criteria, 140-41
data inconsistencies and, 142-43
Data menu, 33
flowchart, 136-37
tips for applying, 139
when all records disappear, 138-39
Find and Replace (Ctrl+H), 142
Find and Replace feature, Word, 128
Find command/Find dialog box
database records, 141, 292-93
error messages, 294-95
Match Case and Find Entire Cell Only, 293
options of, 295
workbooks/files, 284-85
worksheets, searching all, 291
Find (Ctrl+F), 141, 293-94
Fit To option, Page Setup dialog box, 270-71
floating toolbars, 371
folders
creating, 282
organizing, 282-83
Program Files folder, 122
Font tab, Format Legend dialog box, 9
fonts
euro symbol and, 61
ornate, 157
row height and font size, 26
standard, 375
foreign currency formats, 64-65
foreign words, spelling, 332-33
Form dialog box, search criteria in, 298-99
Format AutoShape dialog box, 105
Format Cells dialog box
Custom, 80-83
Date, 78-79
format, changing selected, 58-59
formatting options, 47
Indent feature, 151
Number tab, 58, 64, 152, 154
Protection tab, 7, 31, 85, 166-67
symbols and meanings, 59
Format Legend dialog box, 9
Format menu
AutoFormat, 172-73
Conditional Formatting, 47
Style, 161
Format Painter button, 149, 171
Format Report command, 267
formats, 210-11. See also conditional formatting
checking applied, 84
cutting/copying content, 23
dates, 77, 78-79
foreign currency, 64-65
General format, 79, 148
graphic images, 205, 211
PivotTables, 267
Web content, 288
Word tables, converting into Excel, 125
formats, numbers, 146-55
custom, 154-55
decimals places, 148-49
flowchart, 146-47
fractions, 152-53
right alignment, 150-51
formats, text, 156-67
flowchart, 156-57
inconsistencies, 160-61
paragraphs, 162-63
protecting settings, 166-67
titles, 164-65
when too small, 158-59
formats, worksheets, 168-75
AutoFormat, 172-73
flowchart, 168-69
moving cells without moving cell formatting, 170-71
multiple worksheets and, 174-75
Formatting toolbar
adding euro currency, 60-61
Align Left, 150
Align Right, 151
charts, 3, 9
diagrams, 91
Increase/Decrease Decimal Places, 62, 148-49
when missing, 370
Formula bar, 190, 194
Formula Is, 47-48
formulas, 178-91
conditional formatting, 47
dos/don'ts, 181
error messages, 180-82
flowchart, 178-79
functions, combining, 202-03
precedent and dependent cells in, 186-88
viewing formulas instead of results, 377
when cell references change but results don't, 186-88
when getting different result than with a calculator, 184-85
when summary formulas are incorrect, 190-91
fractions, formats of, 152-53
Free Rotate tool, 107
Freeform tool, 13
FrontPage
cutting/copying content from, 23
pasting content to, 20-21
Function Arguments dialog box, 195-96, 200-201, 203
functions, 192-203
building/rebuilding, 193
constructing, 194-95
defined, 194
error messages, 198-99
flowchart, 192-93
formulas, combining in, 202-03
help features for, 196-97
nesting, 202
referencing in cells, 200-201
subtotal reports and, 341
when wrong function applied to subtotals, 342-43
G
General format
date defaults, 79
number defaults, 148
General tab, Options dialog box, 282-83
Get Help Using Office Products link, Tools On The Web, 361
.gif files, 205, 211
Goal Seek feature, 74-75
graphics, 204-13
clip art, 208-09
Clip Organizer, 212-13
flowchart, 204-05
formats, 205, 211
free images on Web, 209
as hyperlinks, 214
keyword searches for, 206-07
scanning images, 210-11
greater than (>) operator, 46, 299
grid surrounding cells, external dependence/precedence, 188
gridlines
changing color, 375-76
printing, 268
Group
grouping groups, 99
grouping objects, 98-99
grouping rows or columns, 247
grouping worksheets, 174
performing common action on selected group, 99
Group and Outline, Data menu, 247, 253
Guess button, Solver, 73
H
handles
charts, resizing, 8
plot area, resizing, 9
text boxes, resizing, 163
Hardware Wizard, 210, 211
Header Row option, Sort dialog box, 317
help features
? (question mark), 197
function information in, 196-97
Search On Web button, 362-64
hidden columns and rows
columns, 30-31
rows, 32-33
Hide command, 32
Highlight Changes dialog box, 37, 40-41
HTML (Hypertext Markup Language) format, 286-88
Hyperlink dialog box, 217
hyperlinks, 214-23. See also links
flowchart, 214-15
graphic images as, 214
object types and, 216
Screen Tips and, 217
targets, 218-19, 222
when it creates a blank workbook, 222-23
when it doesn't work, 220-21
when target has moved, 215
Word text as, 216
workbooks, linking to, 216
Hypertext Markup Language (HTML) format, 286-88
I
images, editing, 204. See also graphics
import. See export/import
Increase Decimal button, Formatting toolbar, 62, 148-49
Indent feature, 151
Input Message tab, data validation, 143
Insert Comment command, 37
Insert Function button, 194, 200, 203
Insert Hyperlink dialog box, 218-19
Insert Options buttons, 17
insertion point, blinking, 111
interactive buttons, clipboard, 16-17
J
.jpg files, 205, 211
K
keyboard shortcuts
Ctrl+A, worksheet selection, 33, 141
Ctrl+C, copying, 128
Ctrl+F, Find, 141, 293-94
Ctrl+H, Find and Replace, 142
Ctrl+O, Open, 283
Ctrl+S, Save, 142
Ctrl+V, Paste, 127
Ctrl+X, Cut, 95, 127
Ctrl+Z, Undo, 127
for macros, 225
for symbols, 119
keywords
changing/adding, 207
searching for files, 307
searching for graphics, 206-07
L
labels. See column and row labels
Landscape orientation, Page Setup dialog box, 271
Large Icons option, 377
layout
diagrams, 92-93
PivotTables, 256-59
left alignment, numbers, 150-51
legend text
placement of, 9
reducing font size of, 9
less than (<) operator, 46, 299
Line Color button, Drawing toolbar, 103
Line tool, Drawing toolbar, 13
lines. See drawing shapes and lines
Link Spreadsheet Wizard, 134
links. See also hyperlinks
between blocks of cells, 19
Paste Link button, 171
between worksheets, 18-19
worksheets to charts, 6, 131-32
Links Dialog box, 133
Links, Edit menu, 132
lists, data entry, 114-15
logos, adding to templates, 354
M
macros, 224-33
deleting, 232
errors, 230-31
flowchart, 224-25
keyboard shortcuts for, 225
locating, 229
Personal Macro Workbook, 227
Record New Macro, 226-27
viruses, scanning for, 225, 233
when it doesn't work at all, 228-29
when it doesn't work in active workbook, 226
margins, adjusting, 105
Margins tab, Format AutoShape dialog box, 105
Match Case and Find Entire Cell Only, Find dialog box, 293
memory capacity, clipboard, 22
menus. See also by individual type
Always Show Full Menus check box, 371
speech recognition, 322
Merge And Center command, 28, 164-65
Merge formatting, 28
merged cells, 28
Microphone Wizard, 323
microphones, speech recognition and, 322
Microsoft Access. See Access
Microsoft FrontPage. See FrontPage
Microsoft Office XP. See Office XP
Microsoft Outlook. See Outlook
Microsoft PowerPoint. See PowerPoint
Microsoft Web site, 359
Microsoft Word. See Word
misspelled words, 331
mmmm, date format, 83
"Modify the current outline" messages, Auto Outline, 249
monitor resolution, 157-58
month and day transposed, date formats, 84-85
month formats, 81, 83
mouse pointers
options for, 100-101
pointing finger, as a, 217
right mouse button, 29, 84
selecting active cell with, 111
two-headed mouse pointer, 31, 32
My Computer, 360
N
#N/A, formula/function errors, 181, 198
Name box feature, 236-37
#NAME?, formula/function errors, 181, 198
names. See also cell names
AutoCorrect, inserting with, 335
comment box, removing from, 38-39
field names and sorting data, 317
files, 281
multiple users and, 38
workbooks, 279
worksheets, 169
negative numbers, 146, 314
nesting functions, 202
None AutoFormat, 173
Normal view, Page Setup dialog box, 270-71
#NULL!, formula/function errors, 199
#NUM!, formula/function errors, 181, 199
Number tab, Format Cells dialog box, 58, 64, 152, 154-55
numbers
decimal place settings, 62
dictating in speech recognition, 325
format options, 58
numeric patterns, creating and filling, 109
percentages, converting into, 146
positive vs. negative, 146
pound signs, appearing as, 57
rounding off, 63
sorting data and, 314
O
Object Dialog box, 122
objects
chart objects, resizing, 8-9
grouping, 98-99
moving, 100-101
software support for types of, 122-23
Office 2000, 21
Office 97, 21
Office Assistant, showing/hiding, 197
Office XP
buttons highlighted when activated, 58
clipboard in, 21
cutting/copying content, 23
interactivity of, 16
Online Collaboration feature, 358
online help, 362-64
online status, checking, 360-61
Open command/Open dialog box
Ctrl+O shortcut, 283
File menu, 276
workbooks/files, finding, 284-85
operators, 46, 47, 299
Options dialog box
Allow Cell Drag And Drop, 79
Comments, 37
General tab, 282-83
User Name, 38-39
order of operations, formulas, 184-85
organization charts, 95
outlining, 244-53
Auto Outline error messages, 248-49
flowchart, 244-45
outline levels, not making sense, 252-53
worksheets, 246-47
worksheets, copying summary data between, 250-51
Outlook, 20-21
P
Page Break Preview, 10, 273, 377
page breaks, inserting/changing views, 377
Page Setup dialog box
Fit To option, 270-71
Landscape option, 271
Print Titles option, 275
printouts, including comments in, 35
paragraph formats, 162-63
parentheses ( )
formulas and, 181, 185
functions and, 203
Password To Modify text box, 281
Password To Open text box, 281
passwords
cryptography and, 305
foolproof, 167
forgetting, 308-09
hidden columns, protecting, 31
protecting date formats, 85
protecting files, 280-81
tips for choosing, 304, 308
workbooks, protecting, 305
worksheets, protecting, 7, 167
Paste
to clipboard, once, 20
to clipboard, repeatedly, 20-21
content, 127
content, between worksheets, 16
content, risk of replacing, 29
Ctrl+V shortcut, 127
Paste function, 192
Paste link, 19, 171
Paste options, clipboard, 17
Paste Special
export/import and, 130-31
Paste Link button, 19, 171
separating formatting from content when copying/moving, 170-71
Percentage Style button, 58
percentages, turning numbers into, 146
Personal Macro Workbook, 226-27, 228
pie charts, 13
PivotTable and PivotChart Report, Data menu, 258
PivotTable Field dialog box, Show Items With No Data check box, 260
PivotTable toolbar, 259
PivotTable Wizard
functions of, 256
layout changes, 256-57
range of cells, selecting for PivotTable report, 258
PivotTables, 254-67
blank data in, 260-61
copying and reusing, 266-67
double-clicking cells creates new worksheet, 262-63
flowchart, 254-55
layout changes, 256-59
PivotTable toolbar, 259
refreshing data, 264-65
Show Pages feature, 263
plot area, charts, 8-9
plus sign (+), expanding worksheets, 341
.png files, 205, 211
pound sign (#), numbers appearing as, 57
PowerPoint
content, pasting to, 20-21
cutting/copying content from, 23
diagrams in, 88
Excel charts in, 121
precedent cells, formulas, 186-88
Print Area feature, 272-73
Print dialog box, 272
Print Preview button, 11, 271, 275
Print Titles, Page Setup dialog box, 275
printers
drivers, installing, 11
euro symbol, ability to print, 61
reinstalling, 11
printing, 268-77
charts, 10-11
column and row labels, 274-75
comments, 35
flowchart, 268-69
multiple workbooks, 276-77
subtotal reports, 341
worksheets, 159
worksheets, printing on single page, 270-71
worksheets, printing sections of, 269, 272
worksheets, when only part prints, 272-73
Program Files folder, 122
Protect Sheet dialog box, 7, 85
protection. See also security
date formats, 85
hidden columns, 31
worksheets, 7, 22, 85
Protection tab, Format Cells dialog box, 7, 31, 85, 166-67
Publish As Web Page, 287
Q
question mark (?), help feature, 197
R
range of cells. See cell ranges
read-only option, files, 281
Recently Used File List, 283, 375
Record Macro dialog box, 226, 231
Record New Macro, 226-27, 229
records, searching for, 292-93. See also filters
red triangle, indicating comments, 36, 38
#REF!, formula/function errors, 181, 199
Refresh Data command, PivotTables, 264
Refresh On Open, PivotTables, 265
Regional Options, Windows 2000, 65
reject changes, Accept or Reject Changes dialog box, 43
Replace All feature, 291, 296-97
Replace command/Replace dialog box, 296-97
Replace Current Subtotals, 340
resizing. See sizes
resolution. See monitor resolution
RICI Reference Style, 375
right alignment, numbers, 150-51
right mouse button
cell formats, checking, 84
content, safe technique for moving, 29
Row Height dialog box, 27
row labels. See column and row labels
rows. See also columns and rows
height adjustments, 26-27
hiding/unhiding, 32-33
out of order, 29
resizing, 124
skipped, finding, 140
S
Save As, 286-87
Save As Web Page, 287
Save (Ctrl+S), 142
Save Options dialog box, 281
saving, 278-89
flowchart, 278-79
organization of workbook folders and, 282-83
when not able to find workbooks, 284-85
when not able to save workbooks, 280-81
workbooks in HTML format, 286-88
Scaling section, Page Setup dialog box, 270-71
scanners, not detecting, 210
scanning images, 210-11
Scenario Values dialog box, 71
scenarios
applying/undoing, 71
deleting and starting over, 70
setting up, 70-71
Screen Tips
checking, 222
creating, 217
Search button, Standard toolbar, 307
Search dialog box
Advanced tab, 285
finding files, 350-51
Search For A Function text box, 195
Search On Web button, help feature, 362-64
search operators, 299
Search pane, 300-301
searches, 290-301
database records, 292-93
error messages, 294-95
flowchart, 290-91
keyword searches, graphics, 206-07
keyword searches, workbooks, 307
online help, 362-64
Replace All feature, 296-97
Search pane, 300-301
searches by example, 298
techniques, 207
Web, for clip art, 209
workbooks/files, 284-85
searching by example, 298
security, 302-09. See also protection
File Properties dialog box, changing/removing name, 306-07
File Properties dialog box, keywords and, 307
flowchart, 302-03
passwords, applying to workbooks, 305
passwords, forgetting, 308-09
preventing others from opening workbooks, 304-05
Select Changes to Accept or Reject dialog box, 42
Set Intercept =, trendlines, 13
shapes. See also AutoShapes tool; drawing shapes and lines
diagrams, adding, 90
diagrams, changing, 87
Shift And Move command, 29
Shift Down And Move command, 29
Shift key
grouping worksheets, 174
resizing charts, 8
Shift Right And Move command, 29
shortcut menu, Edit Hyperlink, 220
shortcuts. See keyboard shortcuts
Show Items With No Data check box, PivotTables, 260
Show Pages feature, 263
Size button, Formatting toolbar, 3, 9
size handles. See handles
sizes
charts, 8-9
columns, 124
diagrams, 89
fonts, 9, 26
plot area, 9
rows, 27, 124
text boxes, 163
toolbar icons, 377
Snap To Grid, 101
software
uninstalling, 123
verifying presence on computer, 122
Solver
Guess button, 73
setting up, 72-73
Solver Parameters dialog box, 72
Sort Ascending/Sort Descending buttons, 312, 315
Sort command/Sort dialog box
column labels, not appearing in, 316-17
Data menu, 33, 315-16
database records, finding, 292-93
Header Row option, 317
multiple field sorts, 315
Options button, 313
sorting by up to three fields, 312
sorting data. See data, sorting
Source Data dialog box, charts, 4, 6
speech recognition, 320-27
dictating numbers, 325
dictation errors, 324-25
flowchart, 320-21
retraining, 324-25
training, 322-23
when words are not recognized, 326-27
Speech Recognition toolbar
Add/Delete Word(s), 326-27
training, 324
Voice selection, 327
spelling, 328-35
abbreviations as typing shortcuts, 334-35
customizing spell checking, 329
flowchart, 328-29
foreign words, 332-33
spelling checker isn't catching all errors, 330-31
Spelling dialog box, 330, 333
Standard toolbar
Drawing, 63
Format Painter, 171
Print Preview, 11
Search, 307
Sort Ascending/Sort Descending, 315
styles, editing, 161
Subtotal dialog box
Remove All, 342
Replace Current Subtotals, 340
subtotal reports, 336-43
error messages, 338-39
flowchart, 336-37
numbered buttons, meaning of, 341
printing, 341
subtotals in wrong places, 340-41
worksheets, deleting and restoring, 336
wrong function applied, 342-43
summary data, copying between worksheets, 250-51
summary formulas, incorrect results from, 190-91
Symbol dialog box, 119
symbols, 118-19
foreign currency, 64
Format Cells dialog box, 59
functions of, 118
selecting, 119
System Properties dialog box, 210
T
Tab key, moving between cells, 111
Table dialog box, 68
tables, converting to text, 128
targets, hyperlinks, 215, 216, 222
Task pane
clipboard, 21
controlling when appears, 377
search version of, 300
teamwork support, 36
templates, 344-57
applications of, 348
applying, 348
creating, 347-48
editing, 345
Excel defaults vs. user created, 349
flowchart, 344-45
locating and updating, 352-53
missing data in, 352-53
when template doesn't appear in Templates dialog box, 345, 350-51
workbooks, recreating, 346
Templates dialog box, 348, 350-51
text
AutoShapes and, 104-05
color, 376
converting tables to, 128
diagrams, does not fit in allocated space, 89-90
diagrams, placement in, 94-95
text boxes
inserting, 63
paragraphs, including in worksheets, 163
text, formatting. See formats, text
text rotation, AutoShape, 106-07
time, adding to date format, 83
titles
formatting, 164-65
Print Titles section, 275
toolbar buttons
Change Button Image, 373
customizing, 369, 374
removing, 369
toolbar icons, changing size, 377
toolbars
creating, 373
customizing buttons, 372-73
displaying, 371
Tools menu
Auditing, 180
Customize, 372
Large Icons, 377
Macros, 227
Spelling, 330
Tools On The Web, 360-61
Tools On The Web, 360-61
Trace Precedents
formulas, auditing, 180, 187-88, 190-91
templates, locating and updating, 352-53
Track-Change comments. See also comments
changes, accepting/rejecting, 42-43
comment box, removing name from, 38-39
covering tracks, 41
tracking changes made by others, 40-41
turning on/off, 36-37
Track Changes While Editing, 40-41
trendlines, charts, 12-13
two-headed mouse pointer, 31, 32
typing shortcuts, 334-35
typos, filtering for, 140
U
Undo
Ctrl+Z shortcut, 127
Edit menu, 296
Unhide command
columns, 31
rows, 32-33
Uniform Resource Locators (URLs), 218
Unprotect Sheet command, 22, 31
updates
automatic, 130
downloading from Web, 366-67
uppercase words, spell checking, 330-31
URL (Uniform Resource Locator), 218
User Name box, 38-39
user name, editing, 39, 375
V
validation rules. See data validation
#VALUE!, formula/function errors, 181, 199
View defaults, 377
View menu, 227, 229
viruses, scanning macros for, 225, 233
Visible Cell Only option, 250-51
Visual Basic, editing macros, 230-31
Voice selection, Speech Recognition toolbar, 327
W
Watch window, keeping track of formulas, 182
Web addresses, hyperlinks to, 218
Web browsing, 219, 221
Web, free graphic images on, 209
Web pages
hyperlinks to, 219
publishing, 287-88
saving files as, 287
Web tools, 358-67
flowchart, 358-59
online help, 362-64
Tools On The Web command not working, 360-61
updates and add-ins, getting from Web, 366-67
what-if scenarios, 70-71
white space, 26
wildcard (*) operator, 299
Windows Explorer, 122
Windows Regional Settings, 64-65
Windows-based applications, 23
Word
charts, exporting to, 130-33
content, cutting/copying from, 23
diagrams in, 88
Excel cells, exporting to, 126-28
interactivity of, 16
pasting content to, 20-21
text, as hyperlinks, 216
Word tables, importing into Excel, 124-25
WordArt, 106-07
workbooks
customizing number of worksheets displayed in, 374
Excel, making accessible for earlier versions, 120
folder organization, 282-83
keyword searches for, 307
linking to blank, 222
linking to current, 216
multiple, opening/printing, 276-77
passwords, applying to, 305
protecting, 304-05
renaming, 279
saving before altering data, 73
saving for use in other application(s), 279
saving in HTML format, 286-88
templates of, 346-48
when not able to find, 284-85
when not able to save, 280-81
worksheets. See also formats, worksheets
cells, finding on, 236
columns, charting noncontiguous from, 5
editing images, 204
formatting consistency, 160-61
grouping/ungrouping, 174-75
losing/replacing while moving, 29
naming, 169
naming multiple, 240-41
outlining, 246-47
plus sign, clicking to expand, 341
printing, adjusting for single page, 270-71
printing, scaling for, 159
printing, sections of, 269
protecting, 7, 166-67
rearranging, 175
selecting, 33, 141
summary data, copying between, 250-51
when double-clicking PivotTable cell creates new, 262-63
when only part of prints, 272-73
workbooks, number of blank worksheets in, 374
workspace customization, 368-77
customizing defaults, 375
floating toolbars, 371
flowchart, 368-69
Formatting toolbar missing, 370
gridlines, changing color of, 375-76
toolbar icons, changing size of, 377
toolbars, creating, 373
toolbars, customizing buttons on, 372-73
toolbars, displaying, 371
View defaults, 377
workbooks, customizing number of worksheets displayed in, 374
Wrap Text feature
data entry and, 113
paragraphs, including in worksheets, 162-63
X
.xlt files (templates), 347, 351
Y
year formats, two vs. four digits, 84
Last Updated: April 7, 2002
|
