O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

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

Using Range Names in Formulas

Using range names can sometimes help you create and troubleshoot formulas. The use of range names is especially important if more than one person is going to be working on the file, because names are easier to understand than cell references. For example, a cell named SALES_TAX would make a sales tax calculation easy to understand.

Review the information in Hour 4, “Managing Your Files and Workbooks,” if you need help naming a range.

You must name a range before you can use it in a formula. If you remember the range name, you can type it into the formula in place of a cell reference. Remember, though, that you must ...

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