Ways to define names in Excel 2007

You can define names from the Name box, using the Create from Selection command, and using the New Name dialog box.

• Defining from the Name box is the quickest way to define the name.
• Defining name using the Create from Selection command creates names for you automatically based on the selections that you make.
• Defining names using the New Name dialog box provides options like setting the scope level for the names.