For Dummies Excel 2010 978-0-470-48953-6 User Manual
Product codes
978-0-470-48953-6
376
Excel 2010 For Dummies
clipping, 313–314
Close command (File menu), 153
closing
Close command (File menu), 153
closing
Backstage View, 14
Clipboard, 165
Excel, 32, 370
Find and Replace dialog box, 222
saving changes before, 32
window, 243
Clipboard, 165
Excel, 32, 370
Find and Replace dialog box, 222
saving changes before, 32
window, 243
clustered column chart, 290
Collapse Dialog Box button, 76
collation, 180
color
Collapse Dialog Box button, 76
collation, 180
color
border, 136
fi ll, 136
font, 127
picture, 306
text, 295
theme, 314
worksheet tab, 236
fi ll, 136
font, 127
picture, 306
text, 295
theme, 314
worksheet tab, 236
color scale, 141–142
column
column
AutoFit feature, 122–123
best-fi t, 122
deleting, 168–169
fi ltering, 274–275
hiding, 124–125
pivot table, 270, 274–275
unhiding, 124–125
width, 122–123
best-fi t, 122
deleting, 168–169
fi ltering, 274–275
hiding, 124–125
pivot table, 270, 274–275
unhiding, 124–125
width, 122–123
column chart, 286, 298
Column Widths option (Paste Special
Column Widths option (Paste Special
dialog box), 166
comma (,), 56
Comma Style button, 111
Comma Style number format, 116
command
Comma Style button, 111
Comma Style number format, 116
command
automation, 350–354
selecting from Ribbon interface, 17–18
selecting from Ribbon interface, 17–18
comment
adding to cell, 210–211
clearing, 168
deleting, 213
displaying in cell, 211
editing, 212–213
font, 213
marking location of, 211
placement, 212
preview, 211–212
clearing, 168
deleting, 213
displaying in cell, 211
editing, 212–213
font, 213
marking location of, 211
placement, 212
preview, 211–212
printing, 213
text, 211, 213
text box size, 213
uses for, 209–210
text, 211, 213
text box size, 213
uses for, 209–210
Comments option (Paste Special dialog
box), 166
Compare Side by Side dialog box, 243–244
compression, 306
computer crash, 92–93
computer memory, 51
conditional formatting
compression, 306
computer crash, 92–93
computer memory, 51
conditional formatting
clear rule, 141
color scale, 140–142
data bar, 140–142
directional icon, 142
formatting rules, 140
highlight cells rule, 140
icon sets, 141
manage rule, 141
new rule, 141
as top ten feature, 365
values with sets of graphic scales and
color scale, 140–142
data bar, 140–142
directional icon, 142
formatting rules, 140
highlight cells rule, 140
icon sets, 141
manage rule, 141
new rule, 141
as top ten feature, 365
values with sets of graphic scales and
markers, 141–142
Conditional Formatting button, 140
constant name, 216–217
contains operator, 338
contextual tool, 16
Copy Cells command (AutoFill feature),
constant name, 216–217
contains operator, 338
contextual tool, 16
Copy Cells command (AutoFill feature),
73, 76
copying
with AutoFill feature, 73, 75
cell formatting with Format Painter
cell formatting with Format Painter
feature, 139–140
cell style, 138–139
with Cut and Paste command, 161
text throughout cell range, 76
worksheet, 238
worksheet to other workbook, 245–248
with Cut and Paste command, 161
text throughout cell range, 76
worksheet, 238
worksheet to other workbook, 245–248
correction. See also AutoCorrect feature
keystrokes for, 70
manual, 67
replacement entry, 69
manual, 67
replacement entry, 69
Count function, 279
COUNT
COUNT
function, 85, 278
Count Numbers function, 279
cover page, 194
crash, computer, 92–93
Currency number format, 115, 121
currency symbol, 78
cover page, 194
crash, computer, 92–93
Currency number format, 115, 121
currency symbol, 78
25_489536-bindex.indd 376
25_489536-bindex.indd 376
3/23/10 7:56 PM
3/23/10 7:56 PM