O'Reilly logo

Special Edition Using Microsoft® Office Excel® 2007 by Bill MrExcel 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

Chapter 30. Using Names in Excel

In this chapter

Defining a Name for a Cell by Using the Name Box 842

Naming a Cell by Using the New Name Dialog 843

Using the Name Box for Quick Navigation 844

Using Scope to Allow Duplicate Names in a Workbook 845

Using Named Ranges to Simplify Formulas 846

Managing Names 854

Using a Name to Hold a Value 856

Assigning a Formula to a Name 857

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

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