Name Manager; Range Names made easy

Name Manager logo

Content

What is Name Manager (office-js edition)

Name Manager (office-js edition) is the Office-JavaScript counterpart of our VBA Name Manager Excel add-in. Contrary to the VBA Name Manager add-in, Name Manager (office-js edition) works in both desktop Excel and Excel on-line.

Name Manager is free of charge and works in Windows and Mac Excel 365, both 32 and 64 bits and Excel on-line.

What makes Name Manager special is that it allows you to add, edit and manage range names in Excel on-line, which currently does not offer any range name editing options.

Excel on-line Installation

Click this button to Install Name Manager in your on-line Excel

Desktop Installation

Click this button to Install Name Manager for Destop Excel

If that link does not work for you, you can also find the tool by opening Excel and clicking Insert, Add-ins (the Add-ins button may also be located on the Home tab, or even on the File tab, or labelled "Get Add-ins" depending on your version and build of Excel!):

Excel Insert tab with the Get Add-ins button

After clicking the Add-ins button search for "name manager" (without the quotes). It should be listed close to the top:

Excel Insert tab with the Get Add-ins button

Click the Add button

To add Name Manager to your Excel, click the Add button.

Reviews

I kindly invite you to add your review of the tool here.

Instructions

Ribbon

After installing, Name Manager sets up a button on the Formulas tab:

Name Manager add-in ribbon button

Main window and its controls

Here is a screen-shot of a the main window:

Name Manager add-in for Excel

And this is what the tool looks like in Excel on-line:

Name Manager add-in in Excel on-line

Refresh button

Click the button to refresh the list of names

Edit button

Edits the selected name(s), using this screen. If you had more than one name selected in the list window, you will only be able to change the visibilty of those names.

Note that you cannot edit the name or the scope of the name. To be able do that you need our VBA version.

Name Manager add-in for Excel, edit name

Add button

Adds a new range name, using this screen:

Name Manager add-in for Excel, add name

Delete button

Deletes the selected name(s)

Copy button

Places the selected names on the internal clipboard (internal clipboard is retained between Excel sessions). You cannot copy tables using this button.

Paste button

Pastes the names you placed on the internal clipboard into the active workbook. Existing names are overwritten.

List button

Inserts a worksheet and lists the items currently visible in Name Manager (filters apply)

Names box

The list of range names found in the workbook. Each name is pre-pended with its scope

Name contains box

This allows you to filter the list of names. The list will be limited to those names which have the characters you type into this box in either their name or in their scope worksheet name.

Scope list

Filters the list of names to the scope you choose here.

Name Types list

Filters the list of names for names with the selected characteristic. Please note that Excel system names (names controlled by Excel such as print_area) can only bee seen by choosing this filter type. As of version 1.2.0.0 you can also choose to display the Table names in your workbook.

Find button

Click this button to find out where the selected name is used in your workbook. It opens the following pane:

Name Manager add-in for Excel, find name

Note that not all objects can be searched (yet). Current search objects include:

If you really like Name Manager (office-js edition), please consider donating to help support it's future development:

cards
Powered by paypal

Recent Changes

Build 1.5.0.0, 2024-12-10: New feature: Find names. Opens the Flexfind add-in and lets it search for the currently selected range name.

Build 1.4.0, 2024-12-05: New feature: You can now Copy and Paste names, the add-in uses an internal clipboard that retains its content between Excel sessions. New design of action buttons at the top of the main window.

Build 1.3.1.0, 2024-11-20: New filter: Volatile names (names containing volatile functions like OFFSET and RAND). New filter: Names referring to entire rows or columns. New option: You can now edit the name and range of a table.

Build 1.3.0.0, 2024-11-11: Added 'Duplicate' filter, shows names which have both a sheet-level and a workbook-level copy. Added "What's new" message.

Build 1.2.0.0: Added Tables as a new name type (though tables are not names, they do behave a bit similar to names).

Build 1.1.0.0, 2024-09-27: Added filter for Lambda name types (names containing a LAMBDA function).

Build 1.0.0.0, 2024-01-30: Various bug fixes, enabled deleting multiple names, improved handling of different screen-heights.

Build 1.0.0.0, 2024-01-02: First release.

Updating

If you are not sure you are using the latest version, click inside the Name Manager pane and press control+F5 to ensure the latest version Name Manager is fetched from our server.

Comments

Loading comments...