Datasheet

386
Excel 2010 For Dummies
Ribbon interface (continued)
components of, 15
contextual tool, 16
cutting down to size, 34
Data tab, 16
Developer tab, 16
dialog box launcher, 15
Formulas tab, 16
group, 15
Home tab, 15
hot key, 17
Insert tab, 15
minimize, 15
Page Layout tab, 15
redisplay, 15
Review tab, 16
selecting commands from, 17–18
tabs, 15
as top ten feature, 367
View tab, 16
right alignment, 129, 131
rotate, 132, 301
row
deleting, 168–169
 ltering, 274–275
height, 123
hiding, 125
pivot table, 270, 274–275
shortening, 123
ruler unit (Page Layout View), 177
running macro, 355–356
• S •
sales increase, 261
Save As command (File menu), 87
Save As dialog box, 88–89
Save button (Quick Access toolbar), 18, 87
Save command
Customize Quick Access Toolbar, 19
File menu, 87
saving
default  le location, changing, 90
frequent, 87, 93
new folder selection, 88
as PDF  le, 91–92
to speci c  le format, 90–91
within subfolder, 89
Scale to Fit feature, 188
scatter chart, 286
Scenario Manager dialog box
Add button, 263
Best Case, 264
Most Likely Case, 263
summary report, 265–266
Worst Case, 265
scienti c notation, 56
scope, 216
screenshot, 313–314
scrolling
horizontal scroll bar, 25
left roller, 25
with mouse, 25
right roller, 25
synchronous, 244
search
case-sensitive, 218
data list record, 326–329
Find and Replace dialog box, 217–220
global search-and-replace operation, 221
online, 223
Research task pane, 222–223
workbook, 150–151
selection. See also cell selection
AutoSelect feature, 100–102
block of cells, 79
font, 125–126
function, 82–83
pattern, 136
worksheet, 233–234
Selection and Visibility task pane, 316–317
selection handle, 288
set cell (Goal Seek feature), 261
shadow effect, 295
shape, 307–308
shared workbook, 227, 359–360
shared worksheet, 358–362
SharePoint Web site, 359–360
Sheet Name button, 192
Sheet Options group, 188–189
Show Margins button (Print panel), 184
Shrink to Fit feature, 134
side-by-side window comparison, 243–244
size
comment text box, 213
font, 42, 125–126
25_489536-bindex.indd 38625_489536-bindex.indd 386 3/23/10 7:56 PM3/23/10 7:56 PM