Removing a Drop Down List

Once you are done with a drop down list, or you want to move it to a new location, it can easily be removed from a worksheet .

And it is not only drop down list, but all of Excel's data validation options - such as data restrictions, input messages, and error alerts - removed using this tutorial.

• Prevent Invalid Data Entry in Excel
• Using Data from a Different Workbook for a Drop Down List
• Using Data from a Different Worksheet for a Drop Down List