Add-ins.com home page
Questions? E-mail us or call us 302-234-9857, 8AM to 10PM U.S. East Coast Time 7 days a week
       

Quantity
Discounts

Money back
guarantee

How to manage range names
using the Name Manager for Microsoft Excel

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.

Product: Name Manager     Customers who looked at this product also looked at:
For: Excel 97-2007  

Spreadsheet Assistant - add over 200 time saving features to Microsoft Excel

Sheet Navigator - quickly and easily change to any worksheet

Price: free
by: JKP Application Development Services
Location: Netherlands

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 on the Excel Tools menu if you are using Excel 97-2003.  The menu item is titled "Name Manager".  In Excel 2007-2010, you will find this menu under the Add-ins ribbon.  Clicking on it expands to show the follwing options:

Range name manager options

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

Range name manager main dialog

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 accidently created by copying sheets from one workbook to another.

 


Copyright 2013 Add-ins.com LLC, all rights reserved.  Spreadsheet Assistant is a registered trademark of Add-ins.com LLC.