Index CO PY RI GH AL RI TE TE D + (addition) operator, 62 * (asterisk), 220 { } (braces), 66 [ ] (bracket), 66 , (comma), 56 / (division) operator, 62 $ (dollar sign), 56 = (equal) operator, 328 = (equal sign), 62, 81, 371 ! (exclamation point), 66 ^ (exponential power) operator, 62 > (greater than) operator, 328 >= (greater than or equal to) operator, 328 - (hyphen), 56 < (less than) operator, 328 <= (less than or equal to) operator, 328 * (multiplication) operator, 62 <> (not equal to) operator,
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 fill 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 filter, 336–340 date filter, 336 number filter, 335–336 opening, 334 operators used in
Index cell active, 98 adding comment to, 210–211 beginner basics, 370 column letter, 23 current cell indication, 23 cursor, 23–25, 103 moving between, 52 name, 213–217 relative cell reference, 158 cell content section (Formula bar), 22 cell formatting Highlight Cells Rules option, 142–143 from Home tab, 107–111 Top/Bottom Rules option, 143 cell pointer moving, 51–52 preventing from moving, 53 cell selection active cell, 98 Add to Selection mode, 104 AutoSelect feature, 100–102 clicking-and-dragging techniqu
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–
Index Current Data button, 192 Current Time button, 192 cursor, cell, 23–25, 103 custom filtering, 336–340 custom series, AutoFill feature, 76–77 Cut command, 161 •D• data bar, 141–142 data entry.
378 Excel 2010 For Dummies •E• Edit menu command, Excel 2003 and 2010 equivalent, 35 editing about this book, 3 cell versus Formula bar, 70 comment, 212–213 data list record, 324–325 drag-and-drop technique, 153–156 function, 84–85 methods, 146 opening workbook file for, 146–150 picture, 305 pivot table, 277–280 Undo feature, 152–153 effect artistic, 306 bevel, 295 font, 126 glow, 295 gradient, 136–137 reflection, 295 text, 295 theme, 314 e-mail, 349, 358–359 E-mail command, 19 embedded chart, 286–289 end
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
380 Excel 2010 For Dummies formatting (continued) Values & Number Formatting (A) option, 163 Values & Source Formatting (E) option, 163 values behind, 118–120 Formatting (R) option (Paste Options palette), 163 Formatting toolbar, 42–43 formula.
Index •H• •I• header 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 print title versus, 185 text, 193 uses for, 189 worksheet, 193 Header & Footer Elements group, 191–193 help window, 32 hiding column, 124–125 graphic object, 316–317 pivot table, 271 row, 125 Home keystroke, 70 Home menu command Home tab Alignment group, 108, 110 cell formatting from, 107–111 contents, 15 Font group
382 Excel 2010 For Dummies Last Sheet button, 27 Last tab scroll button, 231 Layout selector (Status bar), 28 left alignment, 129, 131 legend, chart, 289 less than (<) operator, 328 less than or equal to (<=) operator, 328 line chart, 286, 298 Linked Picture (I) option (Paste Options palette), 163 Live Preview, 11, 367 Local Area Network (LAN), 347 •M• macro assigning button to, 48 assigning to generic macro, 48 assigning to Quick Access toolbar, 357 assigning to Ribbon interface, 356–357 automating comma
Index #NULL! error value, 67 #NUM! error value, 67 Num Lock indicator (Status bar), 28 number date formats, 59–62 decimal place, 56–58 of degrees, 133 dollar amount, 56 fractional, 57 negative value, 56 percentage, 57 positive value, 56 time formats, 59–60 number filter, 335–336 number format Accounting, 115–116, 119 assigning after entered, 113–114 Comma Style, 116 Currency, 115, 121 Date, 120–121 Fraction, 121 General, 114 Number, 121 overflow, 116 Percent, 117 Percent Style, 117 Phone Number, 121 Social
384 Excel 2010 For Dummies Paste Link button (Paste Special dialog box), 167 Paste Link (N) option (Paste Options palette), 163 Paste Options palette, 162–164 Paste (P) option (Paste Options palette), 163 Paste Special dialog box, 165–167 pattern adding fill color to, 136 changing, 136 removing, 137 selection, 136 PDF (Portable Document File), 91–92, 359 Percent format, 117 Percent Style button, 111 Percent Style format, 117 percentage converting decimal to, 117 entering in cell, 117 growth rate, 258 inter
Index Print Preview feature, 178 print title deleting, 187 report header versus, 185 row/column designation as, 186 Print Titles button (Page Setup group), 182 printer, 179 printing chart, 317 comment, 213 current worksheet only, 180–181 ease of, 175–176 formula, 198 help topic, 32 Page Layout View, 176–177 Page Setup group, 181–187 Print Area feature, 180 from Print panel, 177–180 Quick Print button, 180–181 Scale to Fit feature, 188 Sheet Options group, 188–189 Product function, 279 Protect Shared Workboo
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 filtering, 274–275 height, 123 hiding, 125 pivot table, 270, 274–2
Index text box, 301 window, 239 Size button (Page Setup group), 182 Skip Blanks option (Paste Special dialog box), 167 SkyDrive file storage, 360–361 slicer, 275–276 SmartArt, 310, 312–314 Social Security Number number format, 121 Sort Ascending command, 19 Sort Descending command, 19 sorting ascending sort order, 330 data list record, 329–332 descending sort order, 330 down, 330 pivot table, 275–276 sorting key, 330 up, 330 spaced series, AutoFill feature, 75 sparkline, 298–299 Speak Cells button, 172–173
388 Excel 2010 For Dummies Table gallery (continued) range indication, 105 redisplaying, 106 table format, 106–107 table formatting thumbnail, 105 text accepted cell entry as, 54 angled, 133 color, 295 comment, 211, 213 copying throughout cell range, 75–76 date entered as, 59 effect, 295 footer, 193 header, 193 long entry, 132 orientation, 132–134 rotating, 132 spillover, 54–55 time entered as, 59 title, 295 vertical, 134 wrap, 130–132 text box adding a, 300–301 adding arrow to, 301–302 deleting, 301 forma
Index Values and Number Formats option (Paste Special dialog box), 166 Values button (Paste Special dialog box), 166 Values (V) option (Paste Options palette), 163 Var function, 279 VARP function, 279 VBA (Visual Basic for Applications), 351 vertical alignment, 42, 129, 131 vertical split bar, 232 vertical text, 134 View menu command, Excel 2003 and 2010 equivalent, 36 View Side by Side button, 243–244 View tab, 16 Visual Basic for Applications (VBA), 351 •W• Web page query, 342–344 Web site Adobe, 91 Shar
390 Excel 2010 For Dummies worksheet (continued) deleting, 233–235 deselecting, 234 inserting additional, 234 layout protection, 225–226 moving between workbook, 245–248 moving to different location, 236–238 moving within, 23–27 name, 235–236 offscreen view, 369 opening windows on, 238–242 order of, 236–238 selecting specific, 27 selection, 233–234 shared, 358–362 side-by-side comparison, 243–244 space conservation, 50–51 splitting, 204–206 summary, 248–251 switching between, 230–233 tab color, 236 workboo