- 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
- 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
This chapter is from the book
This chapter is from the book
This chapter is from the book
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.
)
Change a Name
- Click the Formulas tab.
- Click the Names 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.
)
)