» Defining a Range Name in Excel 2007

CATEGORY - Excel Formula and Function VERSION - Microsoft Excel 2007

To define a range Name, use one of the following techniques:

Type the text directly in the Name box:
1. Select cell A1.
2. In the Name box, type the text, and then press Enter.
Or
Select a cell, right click and select Name a Range.
Or
Select a cell, press Ctrl+F3 and click New Name button.
Or
Select Formulas -> Name in a Range (in Named Cells Group) -> New Name.