Description of Name-Manager
:
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. 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 h29.95 |
