O'Reilly logo

Microsoft® Excel Data Analysis and Business Modeling by Wayne L. Winston

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 2. Natural Language Range Names

  • How do I create a name for a range of cells based on a spreadsheet label and use that name in formulas?

  • How do I use natural language range names to incorporate a relationship such as Month(t) Ending Inventory = Month(t) Beginning Inventory + Month(t) Production –Month(t) Demand in a spread-sheet formula?

Microsoft Excel 2002 and Microsoft Office Excel 2003 give you the ability to create "natural language" range names based on labels already present in your spreadsheet. I’ll illustrate the use of natural language range names with two examples.

Note

This feature is available only in Excel 2002 and Excel 2003.

How do I create a name for a range of cells based on a spreadsheet label and use that name in formulas? ...

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