Excel Forum

Excel Name Trick #1: Names in Excel 2003 & 2007

Learn the basics of how to create and use an Excel Name in Excel 2003 & 2007. See how some names from Excel 2003 are not allowed in 2007! See the new cell: Sex 1, Sex 2, Sex 3.

See how to name a cell or cell range.
See how to create and use a name in a formula and function.
See how the Excel name ROA2000 must be changed to _ROA2000 for Excel 2003.
Advantages of Excel Names: fewer range selection errors & formulas can be easier to understand.

This is a logical (beginning to end) story about most of the use for Excel Names. In this series you will see 12 amazing uses for Excel Names (14 total Name Tricks).

Got a Question? Ask it Here in the Forum.