Download Wiley Excel 2003 Visual Encyclopedia

Index
Custom tab, 64
Custom View, 22
Custom View dialog box, 22
custom views, 352–353
Custom Views dialog box, 353
Customize, 23
customize
AutoCorrect, 103
AutoFill, 105
AutoShapes, 111
cell comments, 144–145
change default file locations, 146
change default font, 147
charts, 388
create new menu, 148–149
desktop themes, 389–391
dialog box, 23
menus, 152–153
new toolbar, 150–151
program windows, 154–155
Taskbar, 380
Text to Speech tool, 339
toolbars, 156–157
tracking, 345
Cut button, 24
Cut command, 20, 24, 57
cut data, 160–161
D
dash style formatting, 209
data
alignment, 3
center, 248–249
control text wrap, 158–159
copy, 160–161
cut, 160–161
dates, 162–163
export, 233
import, 232
indent, 234–235
link, 240–241
merge, 248–249
paste, 160–161
rotate, 164–165
shortcuts, 161
times, 162–163
Data Analysis dialog box, 92
Data Analysis tools
add-ins, 92–93
functions, 92–93
Help files, 93
Data Connection Wizard, 45
data entry tasks, 6
data series
AutoFill, 104
charts, 123, 388
data validation
remove, 167
set rules, 166–167
database
add records, 168–169
add subtotal, 170–171
404
change records, 176
create database table, 172–175
data form, 168–169
delete records, 177
edit records, 176–177
filter records, 178–179
sort records, 180–181
database table, 172–175
dates, 162–163
dBASE, 30
DBF file format, 69
Decimal button, 182
decimals
about, 25
Decimal button, 182
decrease decimal points, 182–183
increase decimal points, 182–183
Decrease Decimal command, 25
decrease decimal points, 182–183
Decrease Indent button, 46
Default Messaging Programs options, 193
defaults
location, save files, 308–309
text alignment, 3
define print area, 285
delete
cell contents, 184–185
cell formatting, 184–185
columns, 141
database records, 177
hyperlinks, 231
objects, 256
rows, 305
Watch Window, 355
words, AutoCorrect, 103
workbook sheets, 378
workbooks, 368
Delete Files dialog box, 388
desktop themes, 389–391
Device Manager window, 394
Diagram Gallery dialog box, 26, 54
diagrams
about, 26
insert, 186–187
dictionary, AutoCorrect, 5
Disk Cleanup, 386, 389
display
task panes, 332
toolbars, 340–341
Documents and Settings folder, 78
dollar signs, 21
doughnut charts, 389
downloads
clip art, 132–133
Microsoft Office Web site, 2
draw
AutoShapes, 110–111
borders on worksheets, 116–117
objects, 188–189
text boxes, 190–191
drawing space, 26
Drawing toolbar
about, 9, 16, 27
WordArt, 86