1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Remove a Drop Down List in Excel

By

Remove a Drop Down List in Excel
Remove a Drop Down List in Excel

Remove a Drop Down List in Excel

© Ted French

Deleting a Drop Down List

All data validation options for individual cells, including drop down lists, can easily be removed using the data validation dialog box.

The data validation dialog box is located under the data tab of the ribbon.

Tutorial Steps

  1. Click on the cell containing the drop down list or other data validation options

  2. Click on the Data tab of the ribbon

  3. Click on the Data Validation icon on the ribbon to open the drop down menu

  4. Click on the Data Validation option in the menu to open the Data Validation dialog box

  5. In the dialog box, click on the Settings tab if necessary

  6. Click on the Clear All button to remove the drop down list

  7. Click OK to close the dialog box and return to the worksheet


  8.  

The drop down list should be removed from the cell at this point, but any data entered into the cell before the list was removed will remain.

©2014 About.com. All rights reserved.