Index

Symbols and Numerics

  1. #DIV/0! error value (formulas), 61
  2. #NAME? error value (formulas), 61
  3. #NULL! error value (formulas), 61
  4. #NUM! error value (formulas), 61
  5. #REF! error value (formulas), 61
  6. #VALUE! error value (formulas), 61
  1. * (asterisk)
    1. formulas, 56, 57
    2. as wildcard, 224–225
  1. / (slash) symbol, formulas, 56
  1. ^ (caret) symbol, formulas, 56
  1. + (plus sign), formulas, 56
  1. = (equal sign), formulas, 56
  1. – (minus sign), formulas, 56
  1. 2-D images
    1. formatting, 320–322
    2. inserting, 319
  1. 3-D images
    1. formatting, 322–323
    2. inserting, 318

A

  1. Access database table, querying, 355–357
  2. Accounting number format, 118–119
  3. active cell
    1. AutoFill and, 70
    2. defined, 98
  4. Add option (Paste Special dialog box), 169
  5. adding
    1. arrow to text box, 314–315
    2. to cells, 100
    3. comments, 214
    4. data labels to charts, 305
    5. data tables to charts, 305–306
    6. gradient effects, 137
    7. headers and footers, 193–194
    8. hyperlinks to worksheet, 363–366, 378
    9. image to SmartArt, 328
    10. non-Ribbon commands to Quick Access toolbar, 24
    11. records to data lists
      1. with data form, 337–340
      2. overview, 336–337
    1. Ribbon commands to Quick Access toolbar, 22–24
    2. sheets to Worksheet area, 32–34
    3. text boxes, 312–313
    4. worksheets, 238
  6. Advanced Filter, data analysis, 396–397
  7. alignment
    1. borders, 134–136
    2. indents, 130
    3. overview, 129–130
    4. reorienting cell entries, 132–134
    5. Shrink to Fit feature, 134
    6. text wraps, 131–132
    7. vertical, 130–131
  8. Alignment group (Home tab), 113
  9. All Except Borders option (Paste Special dialog box), 168
  10. All Merging Conditional ...

Get Excel 2019 For Dummies now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.