Name-Manager
> FREE TRIAL DEMO
Name-Manager Deluxe
Author Company: OzGrid Business Applications
Name-Manager Deluxe This Excel Add-in will allow you to easily and quickly create and manage all
File Size: kB
OS: Windows 98 / NT / 2000 / ME / XP / VISTA
License: Shareware - Time Limit, free to try, to buy.
Software Developed by OzGrid Business Applications
Description :
Name-Manager Deluxe - This Excel Add-in will allow you to easily a
Go to & View Excel Named Ranges
To go to a range, you simply double click it.
Dynamic Named Range Index Sheet Creator
Will add a Worksheet to your Workbook that will list ALL your named ranges with clickable Hyperlinks for each. The index that is created is dynamic and will automatically update each time you select the Worksheet.
Hide Named Ranges From Others
On this page you select all or some names that you want to hide.
Show or View Hidden Excel Names
You then simply choose some/all to Unhide and click the Unhide button.
Delete Dead, Old, Redundant Names
By accessing the Orphaned Names page. This page will only show those named ranges which have lost their reference. You can then either delete all, or some, or use the Add/Edit/Delete Names button to re-define them.
Create a Map on Worksheets of Your Named Ranges
As the saying goes, "a picture can paint a thousand words".
Create Consecutive Named Ranges.
This feature is a real time saver. There are times when it makes perfect sense to name related ranges with consecutive names. For example, you might have four separate ranges on the one Worksheet that represent each quarter of the year. After selecting the ranges, simply type the name quarter, click Create Names and you instantly get 4 named ranges, Quarter, Quarter2, Quarter3 and Quarter4. Or perhaps you have 52 ranges that represent the Weeks of the year. To do this manually would take quite a while, with the Name Manager it can be done in minutes!
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.
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.
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.
Create Dynamic Named Ranges in Excel Spreadsheets
The Dynamic Ranges page 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.
This is the Shareware version. The full version can be purchased by clicking on the "Buy Now" button below for around $ USD.
Click to buy from RegNow
![]()
![]()
![]()
![]()
![]()
Keywords: Name-Manager Deluxe demo: download Name-Manager Deluxe:Name-Manager Deluxe free download :Name-Manager free download:Name-Manager :Name-Manager review :Name-Manager review::: download Name-Manager Deluxe: : Name-Manager Deluxe
More Products from company OzGrid Business Applications :
- Time Sheet Advanced Deluxe - This extremely easy and simple to use Excel Time Sheet will keep track of your
- Number-Text - Formula Manager Deluxe - Number,Text & Formula Manager is 3 seperate Excel Add-ins bundled together to
- Forms ComboBox Wizard Add-in Deluxe - If you often work in Excel with ComboBoxes from the Forms toolbar this Excel
- Excel Manager Collection Deluxe - Duplication Manager, Number Manager,Text Manager, Named Range Add-in Manager &
- Excel Level 3 - Excel VBA - Excel UserForm Courses Deluxe - CURRENT SPECIAL Was $99.00 Now $49
- Excel Level 2 and 3 Training Deluxe - CURRENT SPECIAL Was $75.00 Now $39
- Time Sheet Advanced Upgrade to Open Source Deluxe - With this version the password for the Worksheets and the VBA code is supplied
- Name-Manager Deluxe - This Excel Add-in will allow you to easily and quickly create and manage all
- Text Manager - The Text Manager will make working with text in your spreadsheet very easy
- OzGrid excel Addins Collection - The OzGrid Add-ins Collection contains all 7 of our Excel Add-ins
- OzGrid Excel Plus Add-in - Formula Report Generator
- Number Manager - The number manager fills in the gaps in Excel when working with numbers
- Formula Ref Changer and Sheet Index Creator - Extremely handy add-in that will instantly change your formulae references from
- Excel and Excel VBA Tips and Tricks - 10 Day Money Back Guarantee.See 33+ Workbook Examples To Save Even More
- Excel VBA UserForm Lessons - CURRENT SPECIAL Was $65.00 Now $49
- Excel VBA Level 1 Lessons - CURRENT SPECIAL Was $65.00 Now $49
- Excel Levels 1 and 2 Training - CURRENT SPECIAL Was $75.00 Now $59
- Excel Level 3 Lessons - CURRENT SPECIAL Was $65.00 Now $49
- Excel Level 3 Excel VBA Excel UserForm Courses - CURRENT SPECIAL Was $75.00 Now $59
- Excel Level 1 2 and 3 Training - CURRENT SPECIAL Was $99.00 Now $79
- Excel Level 1 Lessons - CURRENT SPECIAL Was $65.00 Now $49
- Excel Download Package - This package includes 33 fully accessible Workbook examples that cover topics