# How to Remove a Drop-Down List in Microsoft Excel

**URL:** https://www.compsmag.com/blogs/how-to-remove-a-drop-down-list-in-microsoft-excel/
**Author:** Ayushi Chauhan
**Published:** 2022-08-19
**Updated:** 2022-08-19
**Categories:** Blogs
**Tags:** Android Guides, Apple Guides, Blogs Daily, guiderobert, Guides and Tutorials, guiding12, How To Guide, How To Guides, ios Guides, iphones guides, office tips and tutorials, Originals How to, Tips, Tricks
**Reading Time:** 3 min

---

The article explains How to Remove a drop-down list in Microsoft Excel.  The version of Microsoft Excel required varies.  O mobile Apps for iPhone and Android devices can be downloaded for free but have limited capacity unless used in conjunction with an Office 365 subscription. As other solutions need other goods or services, this is the only method to purchase the Excel as a standalone application.  Follow the steps are given below.

Microsoft Excel is a productivity tool that helps companies of all sizes create spreadsheets for organizing and computing data.  Managers can structure and present data in tables, graphs, sparklines, charts and other formats using the platform.  Microsoft provides Excel as a desktop application with Visual Basic programming, as a desktop spreadsheet program, as well as mobile versions for iOS and Android smartphones.  Visual Basic Routines and Instructions.

## How to    Remove dropdown in Excel

### Clear Data Validation Option Dropdown in Excel

Let's say we have a dataset of product information with the product ID, model, brand, unit price and payment type.  In the Payment Type column, all amounts are entered via a drop-down list.  Now our task is to clear or remove the dropdown using the **Expiration date** option.

**Step 1:** Select the **Expiration date** option under the **Data**tab**.** (In the subsection of **data tools**)

**Step 2:** Then the first click on the **Clean all** button  then the **OK**button    (Make sure that **To allow**is selected as **List**and the **Source**is valid.) If you select the Apply these changes to all other cells with the same setting check box, all cells that contain the drop-down list will also be removed.

**Step 3:**Then all dropdown lists will be removed from this worksheet

### Remove Dropdown List Using VBA in Excel

Excel also gives us the option to remove the dropdown using VBA code as well.  In this section, we will use the same dataset as above and remove the list using VBA.

**Step 1:** Select the **Basic look** option under the **Developer**tab (shortcut key **Alt**+ **F11**)

**Step 2:**A window will open.  Then **Insert**one **Module**

**Step 3:**Write the following code in the VBA console

**Code:**

> Sub Delete_Drop_Down_List()'To Delete List in Selected Range”ThisWorkbook.Worksheets(“Sheet3”).Range(“F4”).Validation.Delete'To Delete Entire List in WorksheetThisWorkbook.Worksheets(“Sheet3”).Cells .Validation .DeleteEnd Sub

**Step 4:** Now go to the worksheet and run the code

**Step 5:** All drop-down lists will be removed.

## Conclusion

Here they are final from our article How to Remove a drop-down list in Microsoft Excel.  Microsoft provides Excel as a desktop application with Visual Basic programming, a desktop spreadsheet program, a mobile app for iOS and Android devices and as an online spreadsheet maker.  Most feature The rich edition of Microsoft Office, which also contains other productivity tools such as Word and PowerPoint, is best for engineering, statistical and scientific research.  The article is finished and you know now How to Remove a drop-down list in Microsoft Excel.

---

*End of Article*