When working with formulas, you can use named ranges created using third-party editors.

To specify a named range in a formula, do the following:

1.Start typing the range name. You will see a drop-down list with range names which correspond to your search request.

2.Select the name of the desired range using the mouse or the keyboard.

Click the range name with the left mouse button.

Select the range name using the ↓ and ↑ buttons and press Enter.

The range name will be inserted into the formula.

If the range name is entered correctly, the range name in the formula will be highlighted with color. If the named range refers to a cell range, the respective data range in the table will be highlighted with color.

Was the material useful?
Users found this material useful: 0 из 0