Microsoft Excel 2019 Inside Out

Chapter 12Array Formulas and Names in Excel

Advantages of Using Names

Naming a Cell by Using the Name Dialog Box

Using the Name Box for Quick Navigation

Avoiding Problems by Using Worksheet-Level Scope

Using Named Ranges to Simplify Formulas

Retroactively Applying Names to Formulas

Using Names to Refer to Ranges

Adding Many Names at Once from Existing Labels and Headings

Using Intersection to Do a Two-Way Lookup

Using Implicit Intersection

Using a Name to Avoid an Absolute Reference

Using a Name to Hold a Value

Assigning a Formula to a Name

Using Power Formula Techniques

Combining Multiple Formulas into One Formula

Long before Microsoft introduced tables and formulas such as =[@Revenue]–[@Cost], spreadsheets have offered the capability to ...