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.
This feature is available only in Excel 2002 and Excel 2003.