Remove All Data Validation from a Cell in Excel

Remove all data validation from a cell in Excel with this free Excel macro. This is a great macro to use when you need to remove all data validation from cells in Excel. This removes drop down menus and lists, input messages, and all other data validation from a cell in Excel.

Below, there are two versions of this macro. The first version works on a specific hard-coded cell or range of cells in Excel while the second macro will work on any selected cell or range of cells within Excel.

To use the first macro, replace A1 with the cell reference or range of cells from which you want to remove data validation. The second macro does not need to be changed; simply select any cell or range of cells in Excel and run the second macro and it will work.

Where to install the macro:  Module

Excel Macro to Remove All Data Validation from a Specific Cell or Range of Cells in Excel

Sub Remove_Data_Validation_Cell()

Range("A1").Validation.Delete

End Sub

Excel Macro to Remove All Data Validation from a Selection of Cells in Excel

Sub Remove_Data_Validation_Selection()

Selection.Validation.Delete

End Sub

---