Download For Dummies Excel 2010
Transcript
Index Fill Series command (AutoFill feature), 73, 75 Fill tab (Format Cells dialog box), 113 Fill without Formatting command (AutoFill feature), 73 filter buttons, pivot table, 272–273, 275–276 filtering AutoFilter feature, 337–341 column field, 274–275 custom, 336–340 data list record, 333–340 date filter, 336 number filter, 335–336 operators used in, 337–338 pivot chart, 281–282 report, 273–274 row field, 274–275 Find and Replace dialog box closing, 222 Comments option, 219 Find Next button, 217, 220, 222 Find What option, 217 Format button, 219 Match Case option, 218, 221 Match Entire Cell Contents option, 218, 221 No Format Set button, 219 Options button, 217 Preview button, 219 Replace All button, 221 Replace button, 222 Replace With option, 221 First tab scroll button, 231 Fixed Decimal feature, 57–59 font bold, 126 color, 127 comment, 213 default, 125 effect, 126 footer, 193 header, 193 italicized, 126 selection, 125–126 size, 42, 125–126 strikethrough, 126 style, 126 theme, 314 underlined, 126 Font button, 109 Font Color button, 110 Font group (Home tab), 108–110 Font Size button, 109 Font tab (Format Cells dialog box), 113 footer alignment, 189, 192 auto, 189–191 centered, 189–190 custom, 191–193 date, 192 even and odd page, 195 filename, 193 first-page, 194 font, 193 page number, 192 picture, 192 text, 193 uses for, 189 worksheet name, 193 Form button, 321–322 Format As Table feature, 105, 366. See also Table gallery Format Axis dialog box, 296–297 Format button (Find and Replace dialog box), 219 Format Cells dialog box, 112–113, 219 Format menu command, Excel 2003 and 2010 equivalent, 36–37 Format Painter feature, 112, 139–140 Format Picture button, 192 Formats option (Paste Special dialog box), 166 formatting chart, 294–297 clearing all, 167 conditional, 140–143, 365 Fill Formatting Only command, 73 Formulas & Number Formatting (O) option, 163 from Home tab, 107–111 Keep Source Formatting (K) option, 163 with mini-toolbar feature, 111–112 pivot chart, 282 pivot table, 271–273 pivot table value, 272–273 SmartArt graphic, 312–313 text box, 300–301 379