In the Name Comparison Report dialog shown in the Compare and Merge Names topic you can:

• edit names
• delete names
• move names from one workbook to another

These actions can be executed from the right-click menu or keyboard shortcuts:

To edit name you should double-click on the or use the Edit menu item from the right-click menu:

In this dialog you can modify name or reference to which this name points. Please note, to edit name's properties you must select single name in the list. This command cannot be applied to multiple selection.

Delete key or Delete item in the right click menu removes selected names. You can select multiple names to be removed.

Add to another workbook command copies names from one workbook to another. You can select the names you need to copy and apply this command to all names at once.

If name is already present in the another workbook xlCompare only changes it's reference.

When name is moved to another workbook you must select scope (workbook, sheet) into which this name is copied:

xlCompare offers 3 options:

• Keep source sheet names - each name is pasted into sheet with same name. Names from the workbook scope are copied into workbook scope too.
• Keep source sheet indexes - your workbook may have different sheet names. In this case names from the first sheet are copied into first sheet in the target workbook, ... Names from the workbook scope are copied into workbook scope too.
• Copy all names into this scope - you select scope into which names will be pasted. This option allows you to copy names between worksheets.