Download Wiley Excel 2003 Visual Encyclopedia

Transcript
E
e-mail
about, 28
attachments, 28
worksheets, 192–193
edit
database records, 176–177
functions, 223
hyperlinks, 231
Edit menu
Copy, 20
Cut command, 24
paste, 57
Edit Web Query dialog box, 259
elements, chart, 389
Embed command, 29
embed objects in worksheet, 194–195
embedded Uniform Resource Locators (URLs), 44
encyclopedia, 66
equal sign, 39
Equal To option, 94
erase border lines, 117
Error Checking feature, 4, 196–197
errors
checking, 98–101
checking tools, 4
fix, 196
messages, 99
Remove Precedents button, 100
trace, 197
Trace Error button, 101
Trace Precedents button, 100
Evaluate Formula button, 101
Evaluate Formula dialog box, 101
EVEN functions, 183
Expand button, 75
export
about, 30
data, 233
F
fields, 42
file formats
about, 69
export, 30
pictures, 59
File menu, print, 63
files
properties, 64
save to default location, 308–309
fill
about, 31
Drawing toolbar, 27
Fill Color, 31
fill color, formatting, 208
Fill Color button, 31
filter
data, 7
database data, AutoFilter, 106–107
database records, 178–179
find
add-ins, 91
data, 198
Find and Replace dialog box, 32, 198–199
Find tool
about, 32
find data, 198
replace data, 199
fix errors, 196
flip objects, 263
Font button, 33
Font Color command, 34
Font Size buttons, 34
Font tab, 11
fonts
about, 33
sizes, 34
footers, 42
force-quit application, Task Manager, 379
format
3-D effects, 211
apply cell formatting, 200–203
apply conditional, 204–205
arrows, 208–211
bold, 11, 206–207
chart elements, 130–131
copy, 36
dash style, 209
fill color, 208
Format Cells dialog box, 200–203
Format dialog box, 211
italic, 206–207
line color, 208
line style, 209
lines, 208–211
objects, 257
Percent Style, 57
pictures, 270–271
shadow effect, 210
shapes, 208–211
Style dialog box, 74
underline, 206–207
Underline button, 81
Format Axis dialog box, 120
Format Cells dialog box
about, 3
Bold, 11
Borders, 12
Currency Style, 21
decimals, 25
Fill Color, 31
Font Color command, 34
Font Size buttons, 34
fonts, 33
formatting, 200–203
indents, 46, 235
italics, 47
Merge and Center command, 50
Percent Style, 57
underlining, 81
Format dialog box, 211
Format menu
columns, 17
rows, 68
Format Painter, 36
405