O'Reilly logo

Microsoft Excel 2010 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

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 ...

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