Removing a drop-down list from the Microsoft Excel spreadsheet is really as easy as selecting the drop-down cells and choosing a choice. This keeps the values that youve chosen as the drop-down was present. Well demonstrate how to do this.
Delete a Drop-Down List within an Excel Spreadsheet
Once you take away the drop-down menu from your own cells, Excel prevents users from choosing from your own predefined value list. The values that an individual has recently chosen are retained, nevertheless, you can take them off if you would like.
To achieve that, launch your spreadsheet with Microsoft Excel. In your spreadsheet, choose the cells where you intend to take away the drop-down menu. It is possible to select multiple cells by holding down the Ctrl (Windows) or Command (Mac) key and clicking your cells.
While your cells with the drop-down menu are highlighted, in Excels ribbon at the very top, click on the Data tab.
On the info tab, in the info Tools section, click Data Validation.
A Data Validation window will open. Here, at the very top, click on the Settings tab. Then, in the bottom, click Clear All accompanied by OK.
Tip: To quickly restore your removed drop-down menus, press Ctrl+Z (Windows) or Command+Z (Mac).
And thats it. Excel has removed the drop-down menu from your own selected cells.
Later, if you want another drop-down menu, Excel makes it simple to insert drop-downs in your spreadsheets.