Teach Microsoft Office
Online Video Tutorials for Microsoft Office
Microsoft Office Excel Macro

Remove All Data Validation from a Cell in Excel

Bookmark and Share
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.
Macro Installation Location: Module
Keywords: sort data sorting excel one column next subset adjacent data set table advanced
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
 
Official PayPal Seal SSL Join TeachMsOffice.com on Facebook Follow TeachMsOffice.com on Twitter


Microsoft Office Tutorials | Office Tutorials - Excel Word PowerPoint | HD Tutorial Video Player Overview | About TeachMsOffice.com

TeachMsOffice.com provides HD Online Video Tutorials and Training for Microsoft Office programs such as Excel, Word, and PowerPoint. We use a specialized video player interface to teach a vast list of Microsoft Office Tutorials and we add new tutorials on a weekly or monthly basis.