Download For Dummies Excel 2010
Transcript
376 Excel 2010 For Dummies clipping, 313–314 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 clustered column chart, 290 Collapse Dialog Box button, 76 collation, 180 color border, 136 fill, 136 font, 127 picture, 306 text, 295 theme, 314 worksheet tab, 236 color scale, 141–142 column AutoFit feature, 122–123 best-fit, 122 deleting, 168–169 filtering, 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 dialog box), 166 comma (,), 56 Comma Style button, 111 Comma Style number format, 116 command automation, 350–354 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 printing, 213 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 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 markers, 141–142 Conditional Formatting button, 140 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 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 correction. See also AutoCorrect feature keystrokes for, 70 manual, 67 replacement entry, 69 Count function, 279 COUNT function, 85, 278 Count Numbers function, 279 cover page, 194 crash, computer, 92–93 Currency number format, 115, 121 currency symbol, 78