Datasheet

378
Excel 2010 For Dummies
• E •
Edit menu command, Excel 2003 and 2010
equivalent, 35
editing
about this book, 3
cell versus Formula bar, 70
comment, 212–213
data list record, 324–325
drag-and-drop technique, 153–156
function, 84–85
methods, 146
opening workbook  le for, 146–150
picture, 305
pivot table, 277–280
Undo feature, 152–153
effect
artistic, 306
bevel, 295
font, 126
glow, 295
gradient, 136–137
re ection, 295
text, 295
theme, 314
e-mail, 349, 358–359
E-mail command, 19
embedded chart, 286–289
ends with operator, 338
Enter button, 52
Enter mode, 51–52
entry
arrow key, 52
AutoComplete feature, 71–72
AutoFill feature, 72–77
basic, 51–53
beginner basics, 370
calculated  eld, 321
cell pointer, 52
color, 127
guidelines for, 50
insertion point, 52
moving between cell, 52
replacement, 69
speeding up, 80
equal (=) operator, 328
equal sign (=), 62, 81, 371
error. See also AutoCorrect feature
formula, 66–67
manual correction, 67
Text to Speech feature, 172–174
Excel 2003 command, 35–39
Excel 2010 transition
adding buttons to Quick Access toolbar,
43–46
basic description of, 33
cutting Ribbon down to size, 35
Excel 2003 menu command equivalents,
35–39
Formatting toolbar button equivalents,
42–43
macro use, 48
new  le formats, 47–48
Standard toolbar button equivalents,
39–41
Excel Binary Workbook  le format, 91
Excel Web App application, 360–362
exclamation point (!), 66
Existing Worksheet button, 268
Exit command (File menu), 32, 370
Expand Dialog Box button, 77
exponential power (^) operator, 62
external data query, 340
Extract Data button, 152
• F •
Favorite Links section (Open dialog box),
147
 le format
binary, 91
dealing with new, 47–48
saving to speci c, 90–91
XLS, 47, 91–92
XLSB, 91
XLSX, 47, 91–92
File Name button, 192
File Path button, 192
File tab, 12–13
 ll color, 136
Fill Color button, 110
Fill Effects dialog box, 136–137
Fill Formatting Only command (Auto Fill
feature), 73
25_489536-bindex.indd 37825_489536-bindex.indd 378 3/23/10 7:56 PM3/23/10 7:56 PM