Delete data validation

You can delete data validation in one of the following ways:

•Using the Data validation dialog box.

•Using the All validations pane.

•Delete columns or rows with cells with validation.

•Delete the sheet containing the cells with validation.

•Apply autofill for cells without validation to cells with validation.

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

1.Select the cell or range of cells containing the validation.

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.Click Clear all in the bottom of the dialog box. If you want to delete such validation from all cells, check the Apply to all cells with the same validation settings box.

4.Click Save.

To delete 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  Delete in the line with the validation and confirm the deletion in the dialog box that appears.