How to Remove a Drop-Down List in Microsoft Excel

Estimated read time 2 min read


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






Source link

You May Also Like

More From Author