Find a name using the range field

To quickly search for a name, follow these steps:

1.Click the range field.

2.Start typing the name. The drop-down list displays the names that match the search criteria.

3.Select the desired name using the mouse or keyboard keys:

•Left-click the name.

•Select the name using the keyboard keys ↓ and ↑ and press Enter.

To view the entire list of names and select the required name from it, follow these steps:

1.Expand the entire list of names. To do this, in the range field, click the button.

2.Select the desired name in the list using the mouse or keyboard keys:

•Left-click the name.

•Select the name using the keyboard keys ↓ and ↑ and press Enter.

If the selected name belongs to a cell or range, that cell or range is highlighted in the spreadsheet.

If the selected name belongs to a constant or formula, the Name manager opens and the line for that name is automatically selected.

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