- Introduction
- Understanding Formulas
- Creating a Simple Formula
- Creating a Formula Using Formula AutoComplete
- Editing a Formula
- Understanding Cell Referencing
- Using Absolute Cell References
- Using Mixed Cell References
- Using 3-D Cell References
- Naming Cells and Ranges
- Entering Named Cells and Ranges
- Managing Names
- Simplifying a Formula with Ranges
- Displaying Calculations with the Status Bar
- Calculating Totals with AutoSum
- Calculating Totals with Quick Analysis
- Performing One Time Calculations
- Converting Formulas and Values
- Correcting Calculation Errors
- Correcting Formulas
- Auditing a Worksheet
- Locating Circular References
- Performing Calculations Using Functions
- Creating Functions
- Creating Functions Using the Library
- Calculating Multiple Results
- Using Nested Functions
- Using Constants and Functions in Names
Like this article? We recommend
Like this article? We recommend
Like this article? We recommend
Managing Names
The Name Manager makes it easy to work with all the defined names and table names in a workbook from one location. You can display the value and reference of a name, specify the scope—either worksheet or workbook level—of a name, find names with errors, and view or edit name descriptions. In addition, you can add, change, or delete names, and sort and filter the names list. You can also use table column header names in formulas instead of cell references.
Organize and View Names
Click the Formulas tab.
Click the Name Manager button.
Use one of the following menu options:- Resize columns. Double-click the right side of the column header to automatically size the column to fit the largest value in that column.
- Sort names. Click the column header to sort the list of names in ascending or descending order.
- Filter names. Click the Filter button, and then select the filter command you want. See table for filter option details.
Click Close.
)
Name Manager Filter Options
Option |
Result |
Names Scoped to Worksheet |
Displays names local to a worksheet |
Names Scoped to Workbook |
Displays names global to a workbook |
Names with Errors |
Displays names with values that contain errors (such as NAME, VALUE, etc.) |
Names without Errors |
Displays names without errors |
Defined Names |
Displays names defined by you or by Excel |
Table Names |
Displays table names |
Change a Name
- Click the Formulas tab.
- Click the Name Manager button.
- Click the name you want to change.
- Click Edit.
Type a new name for the reference in the Name box.
Change the reference. Enter a range or use the Collapse button to select one.
Click OK.
In the Refers to area, make any changes you want to the cell, formula, or constant represented by the name.
To cancel unwanted changes, click the Cancel button or press Esc, or to save changes, click the Commit button or press Enter.
Click Close.
)
)