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 to Show Rows/Data That Meet Multiple Criteria for One Field - AutoFilter
Macro: This free Excel macro filters data in Excel based on multiple criteria for one field in th...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.