Page 359 - Excel Workbook for Dummies
P. 359
43_798452 bindex.qxp 3/13/06 7:42 PM Page 342
342 Excel Workbook For Dummies
• E • errors
finding with Text to Speech, 58–59
E-mail address locating and eliminating formula, 101–104
adding hyperlinks to a, 277–278 preventing with data validation, 312
as a destination for a hyperlink, 274 trapping, 313
EDATE function, 110 Esc key
Edit Hyperlink dialog box, 279 clearing characters in a cell with the, 16
Edit mode, 57 as a data entry shortcut key, 317
Edit Web Query dialog box, 272 editing with the, 57, 321
Edit WordArt Text dialog box, 198–199 ESQuotes (Gilmore Software), 326. See also
editing installing CD files
actions in the Protect Sheet dialog box, 224–225 EXAMPLE icon, 5
charts, 182–183 Excel
data entries, 57–58 copying Workbook Folder to My Documents, 5
data lists using a data form, 205–206 launching, 9–10
with the Esc key, 57, 321 versions supported in this book, 2
features for aiding in, 54–55 Excel All-In-One Desk Reference For Dummies
with Find and Replace and Spell Checking, 66–68 (Harvey), 6
group, 68–69 Excel For Dummies (Harvey), 6
hyperlinks, 279 exponentiation operator (^)
multiple worksheets as a group, 69 precedence of, 82
a recorded macro in the Visual Basic Editor, used in formulas, 74, 76
295–297 exporting a Web page to Excel, 269–270
records with the data form, 206–207 external data table query, 216–220
selecting ranges for, 56–57 External Data toolbar, 220, 271
shortcut keys, 321 External Range Properties dialog box, 271
embedded chart external reference link
cluster bar, 179 creating a, 85
creating a new, 176–179 using a, 84–86
definition, 173
versus chart sheet, 173
Enter key, 16, 227, 317, 321 • F •
entering
F2 (Insertion point) for editing, 57
data into a cell range, 18–20
F10 for activating menus, 1
data into a single cell, 16–18
F12 and Save As dialog box, 25
EOMONTH function, 110
FALSE function, 149–150
equal to operator (=)
fields (columns) sorting in a data list, 209–211
importance of using the, 73
file installation, 325–326
precedence of, 82
File Search dialog box
used on data forms, 206
Advanced tab on the, 59
used in formulas, 73–74
searching for workbook files with the, 51–52
Error Checking dialog box, 103
tabs on the, 51
error-trapping formulas, 156–159
file search feature, 51
error values
filename
#DIV/0!, 77, 156
as a destination for a hyperlink, 274
#NAME?, 77, 162
temporary, 10
building formulas that trap, 157–159
filename extension
finding the source of in formulas, 102–104
.iqy (Internet Query), 272
with formulas, 73–74
of template files, 11
listed, 73–74
of workbook files, 11
suppressing with the IF function, 156–157
.xls, 11
.xlt, 11
.xml (Extensible Markup Language), 269
