Name Manager Filters

Name manager has four filters you can use to control the names that are shown in the Names Listbox. The filters act in combination: names shown must meet all four of the filter criteria.

Name Scope filter

Select one of the items (All, Global, Local to any sheet, Local to Active Sheet) in this listbox to restrict the names shown.

And/Or option buttons

If And is selected (default) only names are shown to which all chosen criteria in the “Type filter” apply. With “Or“ selected, names are shown to which any of the selected Type filter criteria apply.

Invert Filters

If the Invert Filters checkbox is ticked the filters are inverted so that, in this example, visible cells that Refer to selected cells are excluded rather than included.

NameType(s) filter

Select the type(s) of names you want shown. You can select more than one type of filter by holding the control or shift key while clicking in this listbox. When you select more than one type Name Manager will filter either names that match ALL the types selected (And) or names that match ANY of the types selected (Or).

Filter names containing Checkbox

Check this checkbox to only show names that contain the string you entered in the search edit box below. This box is checked automatically once you enter anything in the edit box. Of course the other filters will also apply.

Search Editbox

Enter any combination of characters you want the shown names to match to (including the usual wildcards).

The search string is matched against both the names and their refers-to properties.

When your workbook contains less than 100 names, the listing will be updated as you type. Because filtering the names can take a lot of time, when there are more than 100 names the listing will be updated when you leave the “Match filter” edit box by pressing the Tab key or enter or by clicking on another control, such as the Refresh button.

Unused names checkbox

Check this box to have the Name Manager only show names that are not used in any formula or any other name in the workbook, or as string constants in VBA.

 Name Manager does NOT check some areas that can contain names:

VBA code that uses string concatenation to create names.

Names constructed using INDIRECT

…

Make sure before you delete unused names that the names are not used in a way that this filter cannot detect: it is advisable to make a backup save before deleting.

Due to the heavy searching needed this option may take quite some time on large workbooks.

The other criteria will also apply!

This checkbox is cleared whenever one changes other filter criteria or when one changes the refers-to property.

Copyright © 2020 Decision Models Ltd