Name-Manager

This Excel Add-in will allow you to easily and quickly create and manage all Excel named ranges and constants.

Description of Name-Manager:

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

See Also: All products from OzGrid Business Applications

1. Excel Color Manager
   Excel Color Manager is an add-in that allows you to: •  Create your own unique color palettes quickly and easily •  Create various kinds of gradient color palettes •  Change quickly the current color palette i...
2. Model Assistant Suite
   Model Assistant Suite is the most useful collection of add-ins for people who use Excel as a decision making tool: to build, understand, communicate or audit more robust models, quicker.
3. printData for Excel
   printData helps you view, print out, extract your data-sheet records, on standard or personalized reports within Excel.
4. Portfolio Optimization 1.0
   The Portfolio Optimization model by Excel Business Tools
5. CZ Excel Converter
   CZ Excel Converter is the award-winning, powerful batch document converter that converts between XLS, HTML, XML, MTH, CSV, TEXT, DBF, Lotus 1-2-3, WKS, WQ1, SLK, DIF and more! The software supports batch conversion, command line and folder watcher.
6. Significant Digit Assistant for Microsoft Excel
   One of the key functions that Microsoft left out of Microsoft Excel is one that rounds values to the number of significant digits that you wish to use. The Significant Digit Assistant adds this function to Excel!
7. OM-ANALYSIS OF WAITING LINES
   Excel Spreadsheet Templates for queue analysis.
8. AnalyzerXL 5.9.5
   Technical Analysis in Microsoft Excel. Free historical and real quotes into speadsheets.
9. Excel Chart Tools 1.0
   Using Chart Tools you will become convinced that never it had been so easy to work with Excel charts.
10. Random Number Generator for Microsoft Excel
    If you need a set of random numbers in Microsoft Excel, you will find that generating random numbers is easier said than done. Especially if the random numbers must be unique. Unless you have our Random Number Generator!
11. LunarPhase Pro Upgrade CDROM
    This upgrade CD is only for existing LunarPhase Pro users. The software will not work without a V1.xx verison of LunarPhase Pro having been installed from an original CD or Digital Download. These are the main features added into the V2.
12. Hyper Wiper
    Hyper Wiper completely erases internet surfing history, file view history, pictures, movies, cookies, temporary file cache, typed URLs, AutoComplete, recent document list, recycle bin, and more. Hyper Wiper is very easy to use.
13. Spubble 1.0
    Just match the 3 or more identical gems to get the points.
14. TriHalf
    TriHalf is a simple Tetris-like game where you stack figures, which consist from triangles.
15. Una Cards
    Una Cards! is a card game that is similar like the world's famous UNO card game. Guaranteed to give you fun time at your computer desktop.
16. Snowy Space Trip
    Welcome to Snowy:Space Trip ordering page! What you should know about ordering Alawar games: After ordering to gain access to all the levels and other game features.
17. Funphotor 4.6
    ZeallSoft FunPhotor is fun and easy to use photo blending software.Put yourself, friends and family members on $100 bills! Swap faces and bodies! Change yourself into an astronaut or a personality on a poster.
18. Word Boosters
    Word Boosters: Over 2 dozen macros that add significant function and ease-of-use to Microsoft Word 97, 2000 and 2002 (XP).
19. A2Soft Lotto Apraiser
    A2Soft Lotto...
20. DemoCharge 2004
    Create animated emails, documents and Help files by replacing static screenshots with GIF animations recorded by capturing your desktop.