Find using Name manager

Open the Name manager in one of the following ways:

•On the Sidebar, click the  Name manager button.

•In the range field, click the button and run the Manage defined names command.

The Name manager displays a complete list of names that the current spreadsheet contains. Use the find and replace pane and filter/sort tools to quickly search through the list.

To search for a name using the find and replace pane, follow these steps:

1.Place the cursor in the find and replace pane.

2.Start typing the required name or the reference/constant/formula to which that name is assigned.

As you enter data for the search, the list of names will be reduced to values that match the search conditions.

To filter the list, follow these steps:

1.Click the All names field.

2.In the drop-down list, specify which group of names should be displayed in the list:

•Defined names: Names set manually by the user.

•Table names: Names of tables.

•Local: current sheet: Names that can be used on the sheet that is currently open.

•Global: all sheets: Names that can be used on any sheet.

If you want to select a way to sort the list, follow these steps:

1.Click the button.

2.Select a sorting method from the drop-down list:

•Name (A-Z): sorting by the value specified in the Name field (in ascending order).

•Name (Z-A): sorting by the value specified in the Name field (in descending order).

•Reference (A-Z): sorting by the value specified in the Reference field (in ascending order).

•Reference (Z-A): sorting by the value specified in the Reference field (in descending order).

To see which cell/range corresponds to which name, select that name in the list. The cell/range will be highlighted in the spreadsheet.

If the name of a cell/cell range/constant/formula is selected in the cell editing mode, it is entered in the cell as a formula/function value.