Excel Forum
Similar Content
Easy Way to Manage Names in Excel
Tutorial: How to manage Names in Excel so they are easy to view and change as needed. This is a li...
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
Macro: This free Excel macro illustrates all of the possible parameters and arguments that yo...
Filter Data in Excel - AutoFilter
Macro: This free Excel macro filters data in Excel using the autofilter feature in an Excel macro...



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.