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

Very slow computer

Select text

Phone alarm plus connected

Message saying that my phone is compromised

No sound on my laptop

Chronology

What does sata mean when it’s displayed on my hp laptop?

Unlock toshiba 32rl933 tv pin code

Microsoft 365

No sound on pinnacle 26