How to Remove a Drop-Down List in Microsoft Excel

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.