Removing dropdown lists
Solved
Archa
-
Sam -
Sam -
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
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
3 réponses
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!
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!
Sam
It's very well explained, thank you very much, it has been a great help to me.