I have a spreadsheet that I did not create. I have removed the protection (no password was required). The spreadsheet has several drop down lists and I need to remove one. How do I remove a drop down list?
I checked all the drop down boxes on this spreadsheet. After highlighting each one, I clicked on Data->Validation and made sure that Allow: showed "any value". The buttons still remain on the spreadsheet.
The only way I've found to remove the button so far is to select the cell and then use the Edit->Delete->Entire Column. This is painful, so I'm hoping a better way to delete just the button from the cell exists.
Hmmm. I tried the Edit->Goto...>Special and selected the Data Validation button. Some of the cells were highlighted, but when I tried the Data->Validation method previously suggested, it did not help. All cells with a drop down box already have "any value" selected, but the drop down boxes are still there.
It sounds like the dropdowns were created from the controls toolbox. Open that toolbar and select design mode (looks like a ruler, pencil and architect's triangle). You should now be able to select the dropdown and delete it. Make sure you exit design mode afterwards.