Excel 2019 Bible

Index Settings tab, Data Validation dialog box, 2, 3–4, 7, 9 shading checkerboard shading, creating, 140 displaying alternate-ro ...

Index source workbooks. See also linking workbooks changing link source, 643 defined, 637 determining for a particular workbook, ...

Index SVG (Scalable Vector Graphics) icons, inserting, 551–552 SYLK (Symbolic Link) files, 581, 611 symbols, in worksheet outlin ...

Index TEXTJOIN function joining columns, 600 joining text strings, 255–256 ThisWorkbook module, 998 tick marks, 505 TIME functio ...

Index Use Automatic Scaling option, Solver Options dialog box, 743 Use PivotTable & PivotChart option, Protect Sheet dialog ...

Index VDB function, 352–354 vector-based images, 563 vertical alignment options, 125 vertical axes. See value axes vertical data ...

Index from Start screen, 153–154 from a template, 166–168 exporting data to Power Query, 852–853 file extension, 4 finalizing, 7 ...

Index naming, 56–57 navigating cells, 179–182 number formatting, 44–50 automatic, 46 custom formats, 50 Format Cells dialog box, ...