For Dummies 978-0-470-48953-6 Datasheet

Index• Symbols and Numerics •+ (addition) operator, 62* (asterisk), 220{ } (braces), 66[ ] (bracket), 66, (comma), 56/ (division) operator, 62$ (dolla

382Excel 2010 For Dummies Last Sheet button, 27Last tab scroll button, 231Layout selector (Status bar), 28left alignment, 129, 131legend, chart, 289le

383383 Index#NULL! error value, 67#NUM! error value, 67Num Lock indicator (Status bar), 28numberdate formats, 59–62decimal place, 56–58of degrees, 133

384Excel 2010 For Dummies Paste Link button (Paste Special dialog box), 167Paste Link (N) option (Paste Options palette), 163Paste Options palette, 16

385385 IndexPrint Preview feature, 178print titledeleting, 187report header versus, 185row/column designation as, 186Print Titles button (Page Setup g

386Excel 2010 For Dummies Ribbon interface (continued)components of, 15contextual tool, 16cutting down to size, 34Data tab, 16Developer tab, 16dialog

387387 Indextext box, 301window, 239Size button (Page Setup group), 182Skip Blanks option (Paste Special dialog box), 167SkyDrive  le storage, 360–36

388Excel 2010 For Dummies Table gallery (continued)range indication, 105redisplaying, 106table format, 106–107table formatting thumbnail, 105textaccep

389389 IndexValues and Number Formats option (Paste Special dialog box), 166Values button (Paste Special dialog box), 166Values (V) option (Paste Opti

390Excel 2010 For Dummies worksheet (continued)deleting, 233–235deselecting, 234inserting additional, 234layout protection, 225–226moving between work

374Excel 2010 For Dummies AutoFill feature (continued)copying formula to range of cells with, 157copying with, 73custom services, 76–77description of,

375375 Indexcellactive, 98adding comment to, 210–211beginner basics, 370column letter, 23current cell indication, 23cursor, 23–25, 103moving between,

376Excel 2010 For Dummies clipping, 313–314Close command (File menu), 153closingBackstage View, 14Clipboard, 165Excel, 32, 370Find and Replace dialog

377377 IndexCurrent Data button, 192Current Time button, 192cursor, cell, 23–25, 103custom  ltering, 336–340custom series, AutoFill feature, 76–77Cut

378Excel 2010 For Dummies • E •Edit menu command, Excel 2003 and 2010 equivalent, 35editingabout this book, 3cell versus Formula bar, 70comment, 212–2

379379 IndexFill Series command (AutoFill feature), 73, 75Fill tab (Format Cells dialog box), 113Fill without Formatting command (AutoFill feature), 7

380Excel 2010 For Dummies formatting (continued)Values & Number Formatting (A) option, 163Values & Source Formatting (E) option, 163values beh

381381 Index• H •headeralignment, 189, 192auto, 189–191centered, 189–190custom, 191–193date, 192even and odd page, 195 lename, 193 rst-page, 194font