Define a name from the Name box in Excel 2007

To define a name from the Name box, click a cell or a range of cells (or) the cell(s) that hold the formulas or constants (or) a table or few cells in a table.
Once the selection is over, click the Name box and type a name. Press the ENTER key to accept the name.

Note:

• When you define a name from the Name box, the scope of the name is global. This means you can use the name from other worksheets.
• You cannot use the defined name from other workbooks.
• You cannot delete the defined name from the Name box.