Name Manager Plus has been developed by Excel Virtuoso as a new add-in to better manage named range references within an spreadsheet. The add-in permits uses to more easily adjust named range references, names, and permits the assignment of categories.
Note: Name Manager Plus is currently being distributed under a freeware license. The current version of the add-in has been tested on 32-bit editions of Excel 2013 and beyond — we cannot guarantee that it will work as advertised on older versions of 64-bit versions of Excel. Additional license details are provided on the “About” tab within the program.
While the Excel OEM Name Manager allows users to create, edit, and delete named range, it does not provide the flexibility to modify a large number of named ranges simultaneously. If you’re a VBA developer or Excel poweruser who relies heavily on named ranges, many features in the Name Manager Plus
|Feature||Name Manager Plus||Name Manager (OEM)|
|Reassign cell address reference.|
|Create, edit, and delete named range names.|
|Add edit named range comments.|
|Filter by general criteria.|
|Assign categories to named ranges.|
|Single click (and no additional dialog windows) for reference address changes.|
|Easily move or resize individual or multiple named ranges using simple single-click d-pads.|
|Advanced filtering permits additional filter criteria, including name, value, comments, category, and worksheet.|
|Filter and selection tools allow the easy selection of large amount of named ranges for updates.|
In addition to improvements for modifying reference and other meta data associated with named ranges, the Name Manager Plus also permits the assignment of categories to named ranges, a feature not present in the OEM Name Manager.
Download and Installation
Installation is done through a standard windows installer. After installation, the add-in will show up in a new “Name Manager” tab on the Excel ribbon.
You will be directed to the download page by clicking the button below. Files must be extracted from the .zip folder prior to installation. If it does not appear, you may need to restart your computer.
Current compatibility: This add-in is compatible with Excel 2016. Some features work on Excel 2013. We are working to make it fully compatible with Excel 2013.
Name Manager Plus Overview and Tutorial
After successful install, the Name Manager Plus add-in will appear within the Name Manager tab.
Main Dialog Box
Upon clicking on the Name Manager Plus button, a large dialog box will appear. The dialog box will search the active workbook (instance where the Name Manager Plus was opened) for any named ranges and list them in the main listbox. Other panels include filtering and modification controls.
The dialog box is organized into four primary sections, as follows:
- Filter Pane: Contains criteria to filter names within the Name Selection Pane (2).
- Name Selection Pane: Contains the list of all names within the active workbook.
- Category Manager: Permits the addition and modification of categories.
- Name Modification Pane: Contains all controls to modify attributes of named ranges.
The Filter Pane contains criteria to filter select names in the Name Selection Pane. This includes two listboxes (Category and Worksheet), and three textboxes (Range Name, Value, Comments)
Permits the filtering of selected categories. Multiple categories can be selected pressing the “ctrl” or “shift” keys while making selections. The “[All]” option effectively deactivates the filter.
Permits the filtering of named ranges depending on which sheet they are located on. Multiple worksheets can be selected pressing the “ctrl” or “shift” keys while making selections. The “[All]” option effectively deactivates the filter.
This text field can be used to filter names that contain specific words or characters within the “Range Name” column.
This text field can be used to filter any value within any of the cells within listed ranges.
This text field can be used to filter comments that contain specific words or characters.
Name Selection Pane
The Name Selection Pane occupies the most real estate in the dialog box. This is primarily a large listbox containing a list of all Named Range references within the active workbook. Columns–from left to right–include Range Name, Sheet, Address, Category, Value, and Comments. In addition to having a vertical scrollbar to scroll through lists of names, you will need to scroll horizontally to the right (depending on your monitor resolution) to view parts of value and comments.
Above the listbox are three selection buttons which will activate either all names, no names, or an inversion of the current selection. Multiple names can be manually selected by holding the “ctrl” or “shift” key will making selections.
The Category Manager permits the addition and modification of categories. With the Name Manager Plus, categories can be assigned to named ranges.
Enter a new category name in the textbox and press the “Add” button. The new category will be added to the category database and all relevant form controls. At this point, the category will be ready for assignment to any named range you select.
Using the dropdown list, select a category name to modify. Enter a new/updated name in the textbox to the right of the dropdown, then press the “Modify” button. The new name will be updated on all affected named ranges and can be used immediately to assign to new named ranges.
Name Modification Pane
The Name Modification Pane contains many features which can be used to easily modify all attributes of a named range.
This group of controls permit the modification of a named range’s Name, Category, and Comments. Upon entering new data, press the “Modify” button to make changes. You can also delete named ranges by checking off the Delete checkbox. You will not be able to undo this action.
All Modify Name features are active with both single or multiple named range selections, except for the Name field. The name field will only be active when an individual named range is selected.
The Move group of controls contain a d-pad which permit the movement of named ranges in any direction of the spreadsheet. Each selection on the d-pad will move all selected name ranges one cell in that direction. Individual or multiple named ranges can be moved. When multiple named ranges are moved, movement will be simultaneous, meaning each selected range will move the same amount in the same direction. The exception is when a named range reaches the top or left edge of a spreadsheet. In these cases, other named ranges will continue to move (as long as they are not at the boundary), while all named ranges at the boundary will remain stationary.
A checkbox labeled Move Vals exists below the d-pad. When this checkbox is checked, all values (both values and blanks) will move. Keep in mind any cells within the named range encroaching on cells with content will overwrite those cells’ contents. At this time, this feature will not keep formulas intact, but it will move their values.
The Sheet group permits the movement of a named range from one worksheet to another. Using the dropdown list, pick from a list of available worksheets to move the named range too..
The Expand group contains another basic d-pad which permits the named range to be expanded in size. Individual or multiple named ranges can be selected and expanded simultaneously, at a rate of one cell per click. If a cell reaches the boundaries of the spreadsheet, it will stop expanding.
The Contract group contains an inverted d-pad which permits the named range to be contracted in size. Individual or multiple named ranges can be selected and contracted simultaneously, at a rate of one cell per click. If a named range shrinks down to a single cell, it will stop contracting.
Using the Manual Change control group, individual named ranges can be resized to any specified range using A1:A2 format. This control group is deactivated if multiple named ranges are selected.
Other Notes and Known Issues
- Please review license details about this Beta in the “About” tab of the main dialog box. Given its beta state, it is essential that a backup version exists for the file the add-in is being used on.
- Any notifications of bugs or issues would be greatly appreciated. To notify us of any issues, please use the contact form.
- Suggestions or feature requests are welcome, but please note that you will not be entitled to any compensation or royalties if requested features are added.
- Known Issue: This main dialog box fails to launch in some complex workbooks which were originally converted from Excel 2013.
- Download Link
Version 0.71 (01/07/2016)
- First public beta release.
- Ref Error Manager (allows users to correct named ranged with #Ref errors).
- Faster refresh times for large collections.
- General performance enhancements.