O'Reilly logo

Excel 2016 In Depth by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

12. Array Formulas and Names in Excel

Long before Microsoft introduced tables and formulas such as =[@Revenue]–[@Cost], spreadsheets have offered the capability to assign a name to a cell, a range of cells, or a formula. The theory is that using a name for a range is easier to understand when used in a formula. For instance, =SUM(MyExpenses) makes formulas more self-documenting than =SUM(Sheet5!AB2:AB99). In Excel 2016, you use the Name Manager interface to assign and use names effectively.

Advantages of Using Names

Names have a variety of uses in a workbook. A name can be applied to any cell or range. Names are also useful for the following:

Making formulas easier to understand and write. Defined names are offered in the Formula AutoComplete ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required