Removing dropdown lists Solved

Question

Hello,

How can I permanently remove all drop-down lists in Excel 2007? I've tried, but there are still traces left!!!
I would like to redo them all :)

Thank you for your help

Archa

Configuration: Windows / Chrome 34.0.1847.116

Naririne · Accepted Answer

Hello,

Select the areas containing your drop-down lists, go to "Data", "Data Tools", "Data Validation", "Data Validations", click "Yes" when a window pops up, and click "Clear All" in the "Options" tab. There you go, it's done! Your drop-down lists in the selected area disappear!

Peace!

Weapon EDGE · Answer

Hello,  You need to go to DATA, DATA VALIDATION, DATA VALIDATION..., Then in the criterion, which should be set to list, select the first criterion and validate.

archa · Answer

Thank you Naririne, great, it works.

Removing dropdown lists

3 answers

Tiktok limits suggestive content to 18+ users

Self-invoking js function

Unable to open xsl and xslx files

Copy from excel into google sheets

Invisible text boxes or word forms on pdf

Display issue in google

Use your holiday vouchers to pay tolls for free

Xiaomi redmi note 13 pro+ 5g disable ads?

Transfer data to a new pc

Print a page in the right orientation under windows 11