Home > Articles > Home & Office Computing > Microsoft Applications

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

  • yellow-01.jpg Click the Formulas tab.
  • yellow-02.jpg Click the Name Manager button.

  • yellow-03.jpg 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.
  • yellow-04.jpg 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

  • yellow-01.jpg Click the Formulas tab.
  • yellow-02.jpg Click the Name Manager button.
  • yellow-03.jpg Click the name you want to change.
  • yellow-04.jpg Click Edit.
  • yellow-05.jpg Type a new name for the reference in the Name box.
  • yellow-06.jpg Change the reference. Enter a range or use the Collapse button to select one.
  • yellow-07.jpg Click OK.
  • yellow-08.jpg 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.

  • yellow-09.jpg Click Close.
  • + Share This
  • 🔖 Save To Your Account