For Dummies Excel 2010 978-0-470-48953-6 User Manual
Product codes
978-0-470-48953-6
374
Excel 2010 For Dummies
AutoFill feature
(continued)
copying formula to range of cells with, 157
copying with, 73
custom services, 76–77
description of, 72–73
Fill Formatting Only command, 73
fi ll handle, 73
Fill Series command, 73, 75
Fill without Formatting command, 73
months row, 73
sample of series created by, 75
sequential series, 73
spaced series, 74–75
worksheet after copy example, 158
copying with, 73
custom services, 76–77
description of, 72–73
Fill Formatting Only command, 73
fi ll handle, 73
Fill Series command, 73, 75
Fill without Formatting command, 73
months row, 73
sample of series created by, 75
sequential series, 73
spaced series, 74–75
worksheet after copy example, 158
AutoFilter feature
custom fi lter, 336–340
date fi lter, 336
number fi lter, 335–336
opening, 334
operators used in, 337–338
date fi lter, 336
number fi lter, 335–336
opening, 334
operators used in, 337–338
AutoFit feature
column adjustment, 122–123
row adjustment, 123
row adjustment, 123
automatic recalculation mode, 223–224
AutoRecover feature
AutoRecover feature
opening recovered version, 93
retaining fi les for later viewing, 93
shortening/lengthening time interval,
retaining fi les for later viewing, 93
shortening/lengthening time interval,
92, 371
AutoSelect feature
deselecting with, 102
how to use, 100–101
how to use, 100–101
AutoSum feature, 85–87
Average function, 279
AVERAGE
Average function, 279
AVERAGE
function, 85, 278
• B •
background
graphic image or photo to use as, 182
picture, 305
picture, 305
Background button (Page Setup group), 182
Backspace keystroke, 70
Backstage View
Backspace keystroke, 70
Backstage View
at-a-glance stats, 13
closing, 14
Info option, 14
left side pane, 14
opening, 12, 40
closing, 14
Info option, 14
left side pane, 14
opening, 12, 40
Recent option, 14
right side pane, 14
as top ten feature, 367
right side pane, 14
as top ten feature, 367
bar chart, 286
basic entry, 51–53
BASIC programming language, 351
begins with operator, 338
bevel effect, 295
binary fi le format, 91
block of cells (range), 79
Bold button, 109
bold font, 126
border
basic entry, 51–53
BASIC programming language, 351
begins with operator, 338
bevel effect, 295
binary fi le format, 91
block of cells (range), 79
Bold button, 109
bold font, 126
border
adding to cell selection, 134–135
all four edge, 135
chart title, 291
color, 136
drawing, 135
line style, 135–136
line thickness, 135–136
outside edge only, 135
removing, 136
all four edge, 135
chart title, 291
color, 136
drawing, 135
line style, 135–136
line thickness, 135–136
outside edge only, 135
removing, 136
Border tab (Format Cells dialog box), 113
borderline, 134
Borders button, 109
Bottom Align button, 42, 110, 129
braces ({ }), 66
bracket ([ ]), 66
Breaks button (Page Setup group), 182
button
borderline, 134
Borders button, 109
Bottom Align button, 42, 110, 129
braces ({ }), 66
bracket ([ ]), 66
Breaks button (Page Setup group), 182
button
adding to Quick Access toolbar, 19
assigning to macro, 48
Formula bar, 22
grouping, 21
on mini-toolbar feature, 112
moving in Quick Access toolbar, 20
removing from Quick Access toolbar,
assigning to macro, 48
Formula bar, 22
grouping, 21
on mini-toolbar feature, 112
moving in Quick Access toolbar, 20
removing from Quick Access toolbar,
19, 21
• C •
Calculate Now button, 224
calculation
calculation
automatic recalculation mode, 224
formula recalculation, 64
manual recalculation, 223–224
formula recalculation, 64
manual recalculation, 223–224
capitalization, 171
cascade window arrangement, 241–242
case-sensitive search, 218
cascade window arrangement, 241–242
case-sensitive search, 218
25_489536-bindex.indd 374
25_489536-bindex.indd 374
3/23/10 7:56 PM
3/23/10 7:56 PM