Wiley Excel 2003 Visual Encyclopedia 978-0-471-78346-6 Benutzerhandbuch
Produktcode
978-0-471-78346-6
402
Index
A
absolute references, formulas, 212, 393
Accept Changes dialog box, 67
active cells, 13
add
Accept Changes dialog box, 67
active cells, 13
add
3-D effect, objects, 252
borders to cells, 114–115
cells, 118–119
columns, 17, 140
comments, worksheets, 19
decimals, 25
footers, 282–283
headers, 282–283
misspellings, 102
rows, 304
shadows, 252
subtotals, 170–171
Watch Window, 354–355
worksheets, 374
borders to cells, 114–115
cells, 118–119
columns, 17, 140
comments, worksheets, 19
decimals, 25
footers, 282–283
headers, 282–283
misspellings, 102
rows, 304
shadows, 252
subtotals, 170–171
Watch Window, 354–355
worksheets, 374
add-ins
about, 2
Analysis ToolPak, 90
Data Analysis tools, 92–93
find, 91
install, 2, 90–91
load, 90–91
remove, 91
Solver, 90, 94–95
uninstall, 91
Analysis ToolPak, 90
Data Analysis tools, 92–93
find, 91
install, 2, 90–91
load, 90–91
remove, 91
Solver, 90, 94–95
uninstall, 91
Add-Ins dialog box, 2, 90
advanced search, 319
Align Left command, 3
align objects, 253
alignment
advanced search, 319
Align Left command, 3
align objects, 253
alignment
about, 3
buttons, 3
cell data, 96–97
commands, 3
Horizontal alignment, 3
buttons, 3
cell data, 96–97
commands, 3
Horizontal alignment, 3
Analysis ToolPak add-in, 90, 92–93
Applications tab, 379
apply
Applications tab, 379
apply
cell formatting, 200–203
conditional formatting, 204–205
templates, 334–335
conditional formatting, 204–205
templates, 334–335
area charts, 389
arrange windows, workbooks, 364–365
arrow style, 210
arrows
arrange windows, workbooks, 364–365
arrow style, 210
arrows
Drawing toolbar, 27
formatting, 208–211
formatting, 208–211
ASCII characters, 76
assign
assign
file properties, 294–295
workbook passwords, 296–299
workbook passwords, 296–299
assistant shape, charts, 54
attachments, e-mail, 28
attributes, copy, 266–267
audit
attachments, e-mail, 28
attributes, copy, 266–267
audit
about, 4
error checking, 98–101
error checking, 98–101
AutoCalculate sum cells, 113
AutoCorrect
AutoCorrect
about, 5, 72
add misspelling, 102
customize, 103
delete words, 103
spelling, 102–103, 327
add misspelling, 102
customize, 103
delete words, 103
spelling, 102–103, 327
AutoCorrect dictionary, 5
AutoFill
AutoFill
about, 6
customize, 105
data series, 104
number series, 105
customize, 105
data series, 104
number series, 105
AutoFill handle, 105
AutoFilter
AutoFilter
about, 7
Custom View, 22
filter database data, 106–107
Custom View, 22
filter database data, 106–107
AutoFormat
about, 8
customize, 109
preset formatting, 108–109
customize, 109
preset formatting, 108–109
AutoFormat dialog box, 8
AutoShapes
AutoShapes
about, 9
customize, 111
drawing, 110–111
customize, 111
drawing, 110–111
AutoShapes palette, 9
AutoSum
AutoSum
about, 10
total data, 112–113
total data, 112–113
AutoSum function, 75
AVERAGE function, 39
axes titles, charts, 122
AVERAGE function, 39
axes titles, charts, 122
B
balloons, comment, 19
bar charts, 14, 389
Basic File Search task pane, 318–319
bold
bar charts, 14, 389
Basic File Search task pane, 318–319
bold
about, 11
formatting, 206–207
formatting, 206–207
Bold button, 11
borders
borders
about, 12
add to cell, 114–115
Custom Borders, 115
draw on worksheets, 116–117
erase border lines, 117
Quick Borders, 114
add to cell, 114–115
Custom Borders, 115
draw on worksheets, 116–117
erase border lines, 117
Quick Borders, 114
Borders button, 12
bubble charts, 389
build functions, 220–223
bubble charts, 389
build functions, 220–223
C
canvas, 26, 54
CDs, install add-ins, 2
CDs, install add-ins, 2
53_783463 bindex.qxd 4/12/06 7:37 PM Page 402
COPYRIGHTED MATERIAL