Name manager |
This tool allows you to perform a series of operations with the named ranges. See tool handling example. The types of names which can be worked with are: |
- Unused |
Observation: |
The tool detects the not used names taking into account they might not be a part of the formulas. |
in the workbook and they might not make reference to ranges of the active workbook. |
You can notice how all the names of the active workbook have been loaded to the list on the right. We can use them to perform a series of operations, such as: - Go to the named range. - Erase all names. - Erase the selected name. - Hide/show the names. - Generate a detailed names report. |