MS Office Tools





MODEL ADVISOR Business Software for Everyone  
Why Buy with Us
Check Out
Advanced Search

Related Sponsors
  Excel Named Range Manager    



Buy Now
What is this Product?

This Excel add-in will allow you to easily and quickly create and manage all Excel named ranges and constants. You can delete all redundant or broken names, create named constants, dynamic named ranges (ideal for charts and Pivot tables), create Worksheet level names, consecutive named ranges and more.

If you work with Microsoft Excel® Spreadsheets you are no doubt aware of the benefits of using named ranges as opposed to range addresses. For example =SUM(Year_2005_Figures) is much better than =SUM($A$2:$D$5000). The use of named ranges also means you can get to the named ranges very quickly and easily. Unfortunately most Excel users don't get past using named ranges in this manner and realize their full potential.

With the Excel Named Range Manager you will be able to realize the full potential of named ranges.

All feature are extremely easy to use. No help file like a phone book, just to-the-point explanations. The code behind the Excel Add-in will guide you through any steps.

1. Go To & View Named Ranges: This is the first page of the add-in. From here you can see all named ranges, constants & formulas. To go to a range, you simply double click it.

Excel Named Range Manager

2. Dynamic Named Range Index Sheet Creator: By simply clicking a button the Name Manager will add a Worksheet to your Workbook that will list ALL your named ranges. Along with the Refers to range of each name, there is also a clickable Hyperlink for each. The index that is created is dynamic and will automatically update each time you select the Worksheet. In other words, you simply add the sheet once and it will keep up-to-date with all added/deleted names in the Excel Workbook.

Excel Named Range Manager - OzGrid Business Applications

3. Create Same Name Sheet Level Names: Sheet Level Names allow you to use the exact same name to refer to a range on many different Worksheets. For example, you can have the name ThisMonth represent the range A1:A10 on many different Worksheets. Then, if you used =SUM(ThisMonth) the SUM would always sum A1:A10 of the sheet the formula resides on. If using the sheet level named range in VBA code, it will always refer to the ActiveSheet at the time, assuming it has been specified.

Excel Named Range Manager - Model Advisor

4. Create Named Constants with Values: Named Constants are ideal for use in a large spreadsheet where common values are used in calculations. Once a name has been assigned to a value, the name can be used in formulae. For example if the number 0.15 (or 15%), with the text TaxRate, is a Named Constant with the value of 0.15 or 15%. This could then be used in calculations like =A1*TaxRate. Then, if the tax rate changes, you simply make the change to the Named Constant and all your formulae will update to reflect the new value.

Excel Named Range Manager - Excel add-ins

5. Create Named Formulas in Excel Spreadsheets: Named Formulas can be used to create your own custom functions. Once created, they save you having to re-enter the formula name, correct formula syntax, parenthesis and formula reference range over-and-over. The functions you can choose from are: AVERAGE, COUNT, COUNTA, COUNTBLANK, MAX, MIN and SUM.

You can choose a Function and have that Function calculate the Formula Range relative to the Relative Cell. For example, if you choose SUM and the Formula Range A1:A10, the Relative Cell A11 and the Name MySum, you can then use: =MySum anywhere on row 11 on the chosen Worksheets. The result will be the SUM of rows 1:10 of the column the Named Formula resides in.

Excel Named Range Manager - Model Advisor

6. Create Dynamic Named Ranges in Excel Spreadsheets: is arguably the add-ins most powerful and useful feature. Dynamic Named Ranges are ranges that will expand/contract according to the data in the range. The great part about this is your named ranges will only include those cells that house data. This makes them ideal for Pivot Tables, Charts, Validation Lists, and restricting formula calculations.
There are 8 different types of Dynamic Ranges you can create: Numbers Only, Text and Numbers, Last Text Entry, Last Numeric Entry, Monthly, Weekly, Day of Month, Linked to Single Cell.

Excel Named Range Manager - OzGrid Business Applications

OzGrid Business Applications

Unconditional 30 day money back guarantee.

System Requirements

MS Excel 2000 or more required.


US$29.95 Excel Named Range Manager

Buy Now


Related Sponsors
Our Sponsors

Related Sponsors

Help, Comments, Suggestions? Tell Us at:

©2003-2012 MODEL ADVISOR is a registered trademark of JABS All rights reserved.
Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation.