Edit data validation

You can edit the parameters of the created validation:

–By selecting the cells with the validation on the sheet.

–By selecting the created validation in the All validations pane.

To edit a data validation rule by selecting the cells with the rule, follow these steps:

1.Select the cells that contain the validations.

2.Open the Data validation window in one of the following ways:

•On the Data tab, click  Data validation.

•When working in macOS, select the Data > Data validation command from the command menu.

•On the Sidebar, click  All validations and in the All validations pane that appears, click Add validation.

3.If you have selected a range that includes cells without validation, click Apply in the window that appears if you want the current validation to apply to all cells in the range. Click Do not apply if you want to create a new validation for all cells in the selected range.

4.Change the validation settings in the Data validation window (see also Add data validation). If the Apply to all cells with the same validation setting checkbox is selected, the changes will be applied to all validations with the same condition. If the box is unchecked, a validation with new conditions will be created after editing.

5.Click OK.

To edit data validation using the All Validations pane, follow these steps:

1.On the Sidebar, click  All validations.

2.In the list that opens, find the validation. The cells with the selected validation will be highlighted on the sheet.

3.Click  Edit in the line with the validation.

4.Change the validation settings in the Data validation window and click OK.