View Cart

Quantity
Discounts

Money back
guarantee

Range names can be a very useful in Microsoft Excel.  You can use them for quick navigation to any location by pressing F5 and selecting a range name. Or you can use them in formulas, making the formulas easier to understand.  If you have just a few range names, they are easy to manage.  But when you have a lot, having a way to manage them becomes important and that is where the Name Manager is very helpful.

Memory usage:  The Name Manager is a VBA add-in.  It fully opens all the time.  Little impact on memory.  One can have many VBA excel add-ins open at one time.  Opening just several COM add-ins at one time can cause problems (all of our add-ins are VBA add-ins).

Download and Installation:  The download is a zip file.  Unzip it to a folder in your My Documents.  We put ours in My Documents\Excel add-ins\Name Manager.  You can install manually by opening the Excel add-ins dialog and then clicking on the Browse button, navigating to the installation folder and selecting Name Manager.xla.  Or, if you allow macros to run (the default is no run; no warning), then you can use the install workbook "Setup Name Manager.xls" instead. 

When installed, you will find a new menu under the Add-ins ribbon.  Clicking on it expands to show the following options:

When the menu item "Name Manager..." is clicked, a dialog like the following appears:

Mousing over the buttons does provide tooltip help. For help on using, there is a word document in the zip file titled "Name Manager Manual 41.doc".  It is fairly extensive. Using the filter "Local to any sheet" showed range names that are sheet specific versus workbook global.  Such sheet specific names can be accidentally created by copying sheets from one workbook to another.