On the Formulas tab, in the Defined Names group, click Define Name. Enter a name and click OK. There's an even quicker way of doing this.
(Choose Formulas > Name Manager, select the Named Range, change the reference in the Refers to box, then click the green arrow to make the change and click Close.) But if the list will grow over time, changing the reference should be done automatically with a dynamic Named Range formula.
Select the range, type the name in the Name box and press Enter. Now you can use this named range in your formulas. For example, sum Prices. Named Constant To create a named constant, execute the following steps. On the Formulas tab, in the Defined Names group, click Define Name.
Enter a name, type a value, and click OK. Now you can use this named constant in your formulas. Note: if the tax rate changes, use the Name Manager to edit the name and Excel automatically updates all the formulas that use TaxRate. Name Manager To edit and delete defined names, execute the following steps. On the Formulas tab, in the Defined Names group, click Name Manager. For example, select TaxRate and click Edit.
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: Customers who looked at this product also looked at: For: Excel 2003-2013 - add over 200 time saving features to Microsoft Excel - 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 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: 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 accidently created by copying sheets from one workbook to another.