How to Get Prompt to Use Existing Name Range in Excel Workbook Instead of Properating Again

Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel Starter 2010 More...Less

Use the Name Manager dialog box to piece of work with all the divers names and table names in a workbook. For example, you may want to find names with errors, confirm the value and reference of a name, view or edit descriptive comments, or make up one's mind the scope. You can as well sort and filter the list of names, and easily add together, change, or delete names from one location.

To open the Name Managing director dialog box, on the Formulas tab, in the Defined Names group, click Name Manager.

The Name Managing director dialog box displays the post-obit information nigh each name in a list box:

Column Proper noun	Description
Name	One of the following: A divers proper name, which is indicated past a divers proper name icon. A tabular array name, which is indicated past a table proper noun icon. Notation:A tabular array name is the proper name for an Excel table, which is a drove of data nearly a particular subject area stored in records (rows) and fields (columns). Excel creates a default Excel tabular array proper name of Table1, Table2, and so on, each time you lot insert an Excel tabular array. You can alter a table's proper noun to make it more than meaningful. For more than information most Excel tables, run across Using structured references with Excel tables.
Value	The current value of the name, such as the results of a formula, a cord abiding, a prison cell range, an error, an assortment of values, or a placeholder if the formula cannot be evaluated. The following are representative examples: "this is my string constant" 3.1459 {2003;12,2002;23,;2001,18} #REF! {...}
Refers To	The electric current reference for the name. The following are representative examples: =Sheet1!$A$3 =8.3 =HR!$A$1:$Z$345 =SUM(Sheet1!A1,Sheet2!B2)
Scope	A worksheet name, if the scope is the local worksheet level. "Workbook," if the scope is the global workbook level. This is the default pick.
Comment	Additional data virtually the proper noun up to 255 characters. The following are representative examples: This value volition expire on May 2, 2007. Don't delete! Critical proper name! Based on the ISO certification exam numbers.
Refers to:	The reference for the selected proper name. You can quickly edit the range of a proper noun past modifying the details in the Refers to box. Afterward making the change you lot can click Commit to save changes, or click Cancel to discard your changes.

Notes:

• Y'all cannot use the Name Manager dialog box while you are changing the contents of a prison cell.

• The Name Manager dialog box does non display names defined in Visual Bones for Applications (VBA), or subconscious names (the Visible property of the name is set to False).

1. On the Formulas tab, in the Divers Names group, click Define Name.

2. In the New Name dialog box, in the Name box, type the proper name y'all want to use for your reference.

   Note:Names can exist up to 255 characters in length.

3. The scope automatically defaults to Workbook. To change the name's scope, in the Scope drib-down list box, select the name of a worksheet.

4. Optionally, in the Comment box, enter a descriptive annotate up to 255 characters.

5. In the Refers to box, do i of the following:

   • Click Plummet Dialog (which temporarily shrinks the dialog box), select the cells on the worksheet, and and so click Expand Dialog .

   • To enter a constant, type = (equal sign) and so type the abiding value.

   • To enter a formula, type = and and then type the formula.

6. To finish and return to the worksheet, click OK.

Annotation:To make the New Proper name dialog box wider or longer, click and drag the grip handle at the bottom.

If you modify a defined name or table name, all uses of that name in the workbook are also inverse.

1. On the Formulas tab, in the Defined Names group, click Name Manager.

2. In the Name Director dialog box, double-click the proper name yous want to edit, or, click the name that you lot desire to alter, and then click Edit.

3. In the Edit Name dialog box, in the Name box, type the new name for the reference.

4. In the Refers to box, change the reference, and and so click OK.

5. In the Name Managing director dialog box, in the Refers to box, modify the cell, formula, or abiding represented by the name.

1. On the Formulas tab, in the Divers Names group, click Name Director.

2. In the Name Manager dialog box, click the name that you want to change.

3. Select one or more than names by doing ane of the post-obit:

   • To select a proper noun, click it.

   • To select more than than one proper name in a contiguous group, click and elevate the names, or press SHIFT and click the mouse button for each name in the group.

   • To select more ane name in a noncontiguous group, press CTRL and click the mouse button for each name in the group.

4. Click Delete.

5. Click OK to ostend the deletion.

Use the commands in the Filter drop-down list to chop-chop display a subset of names. Selecting each control toggles the filter operation on or off, making it easy to combine or remove different filter operations to get the results you lot want.

You can filter from the following options:

Select	To
Names Scoped To Worksheet	Display only those names that are local to a worksheet.
Names Scoped To Workbook	Display merely those names that are global to a workbook.
Names With Errors	Display only those names with values containing errors (such equally #REF, #VALUE, or #NAME).
Names Without Errors	Display only those names with values that exercise not contain errors.
Defined Names	Display only names defined by y'all or by Excel, such as a print expanse.
Table Names	Brandish simply tabular array names.

• To sort the list of names in ascending or descending order, click the column header.

• To automatically size the column to fit the longest value in that column, double-click the right side of the column header.

Need more than aid?

You can e'er ask an expert in the Excel Tech Community or get support in the Answers community.

Run into As well

Why am I seeing the Proper noun Conflict dialog box in Excel?

Create a named range in Excel

Insert a named range into a formula in Excel

Define and use names in formulas

Need more assist?

robinsonwirave1956.blogspot.com

Source: https://support.microsoft.com/en-us/office/use-the-name-manager-in-excel-4d8c4c2b-9f7d-44e3-a3b4-9f61bd5c64e4