Microsoft Office Tutorials and References
In Depth Information
Managing Names
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.
You cannot use the Name Manager dialog box while you’re editing a
cell. The Name Manager doesn’t display names defined in VBA or hid-
den names.
Use one of the following menu options:
Resize columns. Double-click the right side of the column header to auto-
matically 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 .
Search JabSto ::

Custom Search