free counter
Science And Nature

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

Microsoft Excel Logo.

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.

Select the cells containing the drop-down menus.

While your cells with the drop-down menu are highlighted, in Excels ribbon at the very top, click on the Data tab.

Select the

On the info tab, in the info Tools section, click Data Validation.

Choose

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).

Select

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.

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

Read More

Related Articles

Leave a Reply

Your email address will not be published.

Back to top button

Adblock Detected

Please consider supporting us by disabling your ad blocker