18. Using Names in Excel

Long before Microsoft introduced tables and formulas like =[@Revenue]–[@ Cost], spreadsheets have offered the ability to assign a name to a cell, range of cells, or 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). In Excel 2010, you use the Name Manager interface to assign and use names effectively.

Use the Name Box to Define a Name for a Cell

There are a variety of uses for names 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

• Quick navigation

• Forcing a formula reference to remain ...

Get Microsoft Excel 2010 In Depth now with O’Reilly online learning.

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