Download Wiley Excel 2003 Visual Encyclopedia

Cells, 13
cells
add, 118–119
addresses, 13
data alignment, 96–97
delete contents, 184–185
delete formatting, 184–185
freeze, 218–219
insert comments, 144–145
Name box, 51
references, 13
unfreeze, 218–219
Center alignment command, 3
center data, 248–249
change
background, worksheets, 376
chart type, 125
default file locations, 146
default font, 147
elements, charts, 124
fields, PivotTables, 280
page orientation, 284
PivotTables to PivotChart, 279
position, objects, 254–255
records, database, 176
style, number formatting, 250–251
summary function, PivotTables, 281
tab colors, worksheets, 375
Chart toolbar, 14
Chart Wizard, 14–15, 120–131
Chart Wizard button, 15
Chart Wizard dialog box, 15
charts
about, 120
axes scale, 120–121
axes titles, 122
change elements, 124
change type, 125
create, 126–129
customize, 388
data series, 123, 388
elements, 389
format elements, 130–131
plotting, 388
types, 389
X axis, 120
Y axis, 121
check errors, 98–101
clean cache, 387–389
clip art
about, 16
buying, 133
Clip Organizer, 138–139
download, 132–133
format, 134–135
insert, 136–137
view, 138–139
Clip Art task pane, 16, 77
close task panes, 33
Colors dialog box, 237
column charts, 389
columns
about, 17, 68
add, 140
delete, 141
freezing, 38
hide, 142
print headings, 291
resize, 143
select, 321
subtotals, 75
Comma Style, 18
Command prompt window, 383
commands
Align Left, 3
alignment, 3
Center alignment, 3
Copy, 20, 57
Cut command, 20, 24, 57
Decrease Decimal, 25
Embed, 29
Font Color, 34
Freeze, 38
Freeze Panes, 73
Go To, 40
Import External Data, 45
Increase Decimal, 25
Insert Hyperlink, 44
Italic, 47
Merge and Center, 50
New, 52, 53
Open, 53
Paste, 20, 57
Paste Special, 266–267
Redo, 82, 349
Remove Split, 73
Sort, 71
Split, 73
Toggle Total Row, 75
Undo, 82, 248
comments
about, 19
insert cell, 144–145
compare workbooks, 366
configure folders, 391–393
connect to server, Telnet client, 382–384
construct
arguments, 394
formulas, 214–215
Contents tab, 64
Contract button, 75
Control Panel, 394
control text wrap, 158–159
copy
attributes, 266–267
data, 160–161
formatting, 36
formulas, 216
worksheets, 377
Copy button, 20
Copy command, 20, 57
coworker shape, charts, 54
crop pictures, 268–269
Crop tool, 60
CSV file format, 69
Currency Style, 18, 21
Currency Style button, 21
Custom Borders, 115
403