Adding a Named Range

To add a new named range:

1. Click the Add Range button on the Named Ranges panel. Boxes with settings of a new named range are displayed:

2. Determine named range settings:

• Name. Enter range name. Name should consist only of Latin letters, numbers and underline character.

NOTE. The numbers and letters combinations in the A1 and R1C1 formats cannot be used as a range name because they can be seen as link styles. After entering range name in one of the specified formats and clicking the Add button the corresponding error is displayed.

• Range. Specify range using one of the methods:

• Enter range in the box. The numbers and letters combinations in the A1 and R1C1 formats can be used as a range name.

• Put the cursor to the box and select the range on the data entry form sheet.

3. Click the Add button.

The range will be added to the list of named ranges.

To edit a named range:

1. Click the Edit Range button on the Named Ranges panel. Boxes with settings of the selected named range are displayed:

2. Change the required rage settings.

The named range is edited.

To delete a named range:

1. Click the Edit Range button on the Named Ranges panel. Boxes with settings of the selected named range are displayed:

2. Click the Delete button.

After the operation confirmation the named range will be deleted.