Defining & Deleting Global Names

 Defining a Name

 Names are used so that you can refer to a single cell or a cell range using something meaningful to you. You can define a name using Excel's menus by following these steps:

1. Select the cell or cell range you want the name to represent.
2. Choose Name from the Insert menu, and then Define from the resulting submenu. Excel displays the Define Name dialog box. 
   
3. Replace the suggested name (if any) with the name you want to use for the cell or cell range you selected in step 1.
4. Click on Add. Your name is now defined.
5. Click on OK to close the Define Name dialog box.

The names you define in Excel can be up to 255 characters in length and contain any numbers or letters, as well as the period, backslash, question mark or underscore. Names cannot contain any other special characters, including spaces. In addition, names must start with either a letter, backslash or the underscore.
You can also define a name by using the formula bar. To use this method, follow these steps:

1. Select the cell or cell range you want the name to represent.
2. Click in the area at the very left of the formula bar.
3. Type the name you want to define, pressing Enter when done.

The name is defined and appears in the formula bar area whenever the cell or cells are selected.

Deleting Names

 

There may come a time when you want to delete names you previously defined and used in Excel. To do this, follow these steps:

1. Choose Name from the Insert menu, and then Define from the resulting submenu. Excel displays the Define Name dialog box. :)  It sounds strange to choose Define when you want to delete something, but that is the way Excel is designed.
2. In the list of available names, select the one you want to delete.
3. Click on the Delete button. The name is removed from the list.
4. Repeat steps 2 and 3 for other names you want to delete
5. Click on OK to close the Define Name dialog box.