Name Manager

This function gathers and manages defined names. Check defined names on a list and edit, delete or rename them.

Steps

To define and delete a name

  1. Click Formula-Name-Name Manager.
  2. In the Name Manager dialog box, click the Add Name icon .
  3. In Add Name dialog box, type Test in Name. After selecting the cell A1 in Reference Area and click OK.
  4. In the Name Manager dialog box, select “Test” from the list and click the Delete Name icon .
  5. You are prompted to confirm the deletion.
  6. Click Yes. The name “Test” will be deleted from the list.
  7. Click Cancel in the Name Manager dialog box.

More Information

Name Manager Dialog Box

Name Manager List

If you define a name, the name will be added to the name manager list. The list displays the name, and reference area of defined names.

Details on Icons

The following icons are displayed at the bottom of the list in the Name Manager dialog box.

Icons Name Comment
Add Name Adds a new name to the name manager list.
Edit Name Selects and modifies names added to the name manager list.
Delete Name Delete names added to the name manager list.

Add Name Dialog Box

Name

Define the selected area a name. If you type a name and click OK, the new name will be added.

You can use duplicate names in different rage, but you cannot use duplicate names in the same range.

Range

Select a range for the defined name. If you select a certain sheet or workbook, you can use names defined in the sheet or workbook.

Reference Area

Check the cell area to which the name refers, and specify your own if necessary.

Edit Name Dialog Box

Name

Define the selected area a name. If you type a name and click OK, the new name will be added.

Range

Select a range for the defined name. If you select a certain sheet or workbook, you can use names defined in the sheet or workbook.

Reference Area

Check the cell area to which the name refers, and specify your own if necessary.

Notes

Checking defined name in name box

If you click the drop-down arrow next to the name box, you can check a list of defined names. Up to 100 defined names are displayed in the name box. When there are more than 100 defined names, you can check them in the Name Manager dialog box.

See Also

Use in Formula, Create from Selection

www.hancom.com