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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.