Home > By category > Business & Productivity Tools >Sticky Notes > Name-Manager



Name-Manager

  • Downloads: 
  • Views: 
  • Rating:

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 RangesTo go to a range, you simply double click it.Dynamic Named Range Index Sheet CreatorWill 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 OthersOn this page you select all or some names that you want to hide.Show or View Hidden Excel NamesYou then simply choose some/all to Unhide and click the Unhide button.Delete Dead, Old, Redundant NamesBy 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 RangesAs 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 ValuesNamed 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 SpreadsheetsNamed 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 SpreadsheetsThe 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.. .

Free download from Shareware Connection - This Excel Add-in will allow you to easily and quickly create and manage all

Publisher: hamdx.com | License: Shareware | Price: $29.95
Version: 1.0 | Platform:
Released Date: 12-10-2009 | Rating: 0 | Title: Name-Manager

Author Url: http://www.hamdx.com
Program Info Url: http://www.hamdx.com
Download Url: http://www.hamdx.com/scheduler/Employee_Scheduler_protected.zip

More downloads from Name-Manager publisher hamdx.com:

Employee Scheduler in Excel - Employee Scheduler in Excel: An Excel-based scheduler for hourly and salaried

Employee Shift Scheduler for Excel - Shift Scheduler for Excel is an affordable spreadsheet that runs in Microsoft

Excel Manager Collection - Duplication Manager, Number Manager,Text Manager, Named Range Add-in Manager &

Name-Manager related downloads:

Word Metadata Changer - Word Metadata Changer is an utility that will help you to view and change the Microsoft Office Word document file properties such as creater,last modified by user,company name,manager,last printed time, total edited time, document created time, etc.

Excel Metadata Changer - Excel Metadata Changer is an utility that will help you to view and change the Microsoft Office Excel document file properties such as creater,last modified by user,company name,manager,last printed time, total edited time, document created time, etc

PowerPoint Metadata Changer - PowerPoint Metadata Changer is an utility that will help you to view and change the Microsoft Office ppt document file properties such as creater,last modified by user,company name,manager,last printed time, total edited time,etc

MTools Pro Excel Add in - The excel add-in MTools is a powerful software, that leverages the efficiency of your daily work with its timesaving functions and their capability of being applied to multiple (protected) sheets as well as to multiple closed spreadsheets.

ExpertDomainFinder - Enter the Domain Name after market with a tool that will pay itself in the first name you sell. Without ExpertDomainFinder the process is tedious, you enter a name you like individually time after time.... With ExpertDomainFinder its easy.

Shareware Connection periodically updates pricing and software information of 'Name-Manager' from company source 'hamdx.com' , so some information may be slightly out-of-date. You should confirm all information before relying on it. Software piracy is theft,  Using 'Name-Manager' crack, password, serial numbers, registration codes, key generators is illegal and prevent future development of Name-Manager.

New Reviews

MagiX Video Pro - For PC users, there is no shortage of software to edit video. However, not all video editors come with the required features and versatility to edit complex projects and deal with several gigabytes of HD content easily. The high end video editors ...

LogmeOnce Password Manager Ultimate - Irrespective of your computer and web usage needs it is quite imperative that you will deal with passwords, in fact plenty of them. Both home and corporate network users need to log in to several web services and sites and for each of them, user ...

Eset Cyber Security Pro - There was a time Mac users were simply oblivious to the existence of malware and viruses, partially encouraged by Apple’s claim that Mac’s do not fall prey to malicious code. In last few years, that perception has been shattered owing ...

Avira Ultimate Protection Suite - With time the importance of PC security has gone up by leaps and bounds. Earlier, people used to rely on standalone antivirus software. However, security conscious users prefer having a more robust form of protection. They opt for Internet ...

Autodesk Smoke - Autodesk is the company well known for making some of the most feature rich and versatile tools for 3D modeling, animation and engineering design related work. Its Smoke is a Mac OS specific app that is aimed at professionals involved in ...

Diver Reviver - It is not only malware and viruses that can affect performance of your computer. Malfunctioning and outdated drivers for hardware components can also affect speed and performance of a PC perceptibly. While seasoned users take the pain of ...

Spark Browser - Nearly every PC user needs to browse the web nowadays, irrespective of age and gender. Whether you use a laptop or desktop, it is mandatory to use a web browser to access web or download files. There was a time a majority of Windows users ...

KeePass Password Safe - Using password becomes mandatory for performing various online operations, at both home and workplace. For accessing email accounts, shopping online, making banking transactions and similar tasks it is necessary to use user ids and passwords ...

Cubase Artist - Professional audio editors and artists dealing in MIDI composition have a soft corner for Steinberg Cubase Artist. Its origin can be traced back to Atari ST and in later years, the app made way into PCs and Macs. The latest version is a flexible ...

Adobe Media Encoder - Almost every PC user faces a situation where he or she needs to convert an audio or video file fast into a format of choice. There are several free and commercial apps, but the abundance of options can actually make selection difficult. If you ...




New Downloads

Soda PDF

Soda PDF Anywhere is the first
full-featured PDF solution
available both on desktop and
online. It allows users to
read, ...

Aqua Data Studio

Aqua Data Studio is a modern
SQL IDE that enables database
developers, DBAs, and
data/business analysts to
develop, ...

Master PC Cleaner

Master PC Cleaner is a state
of the art technology. It was
coded by industry experts with
a combined industry experience
...

Personal Timeclock

Personal Timeclock: Tracks and
reports your computer usage by
project and category. It can
help you with client billing,
...

Q-Eye QVD/QVX files Editor
(64 Bit)

Freeware QlikView QVD/QVX
files editor

CardWorks Plus Edition for
Mac

CardWorks Plus Edition for Mac
allows users to design and
print your own business cards.
With an extensive range of ...

Citrus Inventory

Manage Inventory Items Create
and Manage Vendor Data Create
and Print a Purchase Order
Create a Pick List Return
Items to ...

Dictionary Wordlist English
Japanese

Bilingual Dictionary Wordlist
for Japanese, Finnish,
Turkish, French, Spanish,
German, Portuguese, English,
Italian, ...

XnView MP

XnView is a fast multi-format
graphics browser, viewer, and
converter. It reads more than
400 file formats. Its main ...

RationalPlan Project Server

RationalPlan Project Server is
a project management platform
capable of handling multiple
interrelated projects and ...

Gasketed Plate Heat
Exchanger Design

PHex is an easy to use tool
which demonstrates the thermal
calculations of Gasketed Plate
Heat Exchangers

Sothink HD Movie Maker
Suite

Sothink HD Movie Maker Suite
is the complete solution for
making and branding homemade
DVD/Blu-ray from any video,
which ...