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. A drop-down list displays the names that match the search conditions.

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

•Left-click the name.

•Select the name with the ↓ and ↑ keys 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. For this purpose, in the range field, click the button.

2.Select the required name from the list using the mouse or keyboard:

•Left-click the name.

•Select the name with the keys ↓ and ↑ and press Enter.

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

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

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.