Microsoft Excel Logo.

Removing a drop-down list from a Microsoft Excel spreadsheet is as easy as selecting the drop-down cells and choosing an option. This keeps the values that you’ve chosen while the drop-down was present. We’ll show you how to do that.

Delete a Drop-Down List in an Excel Spreadsheet

When you remove the drop-down menu from your cells, Excel prevents users from choosing from your predefined value list. The values that the user has already chosen are retained, but you can remove them if you want.

To do that, launch your spreadsheet with Microsoft Excel. In your spreadsheet, select the cells where you want to remove the drop-down menu. You can select multiple cells by holding down the Ctrl (Windows) or Command (Mac) key and clicking your cells.

Select the cells containing the drop-down menus.

While your cells with the drop-down menu are highlighted, in Excel’s ribbon at the top, click the “Data” tab.

Select the "Data" tab at the top.

On the “Data” tab, in the “Data Tools” section, click “Data Validation.”

Choose "Data Validation."

A “Data Validation” window will open. Here, at the top, click the “Settings” tab. Then, at the bottom, click “Clear All” followed by “OK.”

Tip: To quickly restore your removed drop-down menus, press Ctrl+Z (Windows) or Command+Z (Mac).

Select "Clear All" followed by "OK."

And that’s it. Excel has removed the drop-down menu from your selected cells.

Later, if you need another drop-down menu, Excel makes it easy to insert drop-downs in your spreadsheets.

RELATED: How to Add a Drop-Down List to a Cell in Excel

Profile Photo for Mahesh Makvana Mahesh Makvana
Mahesh Makvana is a freelance tech writer who specializes in writing how-to guides. He has been writing tech tutorials for over a decade now. He’s written for some of the prominent tech sites including MakeUseOf, MakeTechEasier, and Online Tech Tips.
Read Full Bio »