Edit data validation

You can edit data validation using the Data validation dialog box or All Validations pane.

To edit data validation using the Data validation dialog box, follow these steps:

1.Select the cells that contain the validations.

2.Open the Data validation dialog box 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.Change the validation parameters in the dialog box. If the Apply to all cells with the same validation setting box is checked, 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.

4.Click OK.

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

1.On the Sidebar, click  All validations.

2.In the opened list in the pane, find the validation. The cell 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 dialog box and click OK.