Chapter 30. Using Names in Excel
In this chapter
Long before Microsoft introduced tables and formulas like =Revenue-Cost, spreadsheets have offered the ability to assign a name to a cell, to a range of cells, or to a formula. The theory is that using a name for a range would be easier to understand when used in a formula. =SUM(MyExpenses) would make formulas more self-documenting than =SUM(Sheet5!AB2:AB99).
With Excel 2007, ...