How do I remove a drop down box?

rhenders

New Member
Joined
Dec 28, 2005
Messages
5
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?

Thanks
rhenders
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

rhenders

New Member
Joined
Dec 28, 2005
Messages
5
Didn't work

I clicked the Data->Validation->"Allow any value". This did not help. there are no choices for the drop down box, but the button is still there. Any ideas?

Thanks,
rhenders
 

watkins6878

Board Regular
Joined
Nov 26, 2005
Messages
96
Sorry You should click on the cell eith the drop down box first and then (Data, Validation, Any Value)
 

rhenders

New Member
Joined
Dec 28, 2005
Messages
5

ADVERTISEMENT

Still no luck

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.

Thanks,
rhenders
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,047
Office Version
  1. 365
Platform
  1. Windows
To select all the cells with data validation, if that's how the dropdowns were created then Try Edit>Goto...>Special and select Data Validation.

You should now be able to use watkins6878 suggestion.
 

rhenders

New Member
Joined
Dec 28, 2005
Messages
5

ADVERTISEMENT

Hmmm

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.

Thanks for your persistence,
rhenders
 

Rob Lanctot

New Member
Joined
Aug 3, 2005
Messages
24
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.
 

Rob Lanctot

New Member
Joined
Aug 3, 2005
Messages
24
It also occured to me that there might be auto filters applied to the column headers - are all of these drop downs an the titles of a bunch of columns?

If so, then try going to DATA-Filter... - and uncheck autofilter.
 

rhenders

New Member
Joined
Dec 28, 2005
Messages
5
We Have a Winner!!

Wow! Design mode didn't help, but you were exactly right on the autofilters! Turning off the autofilter removed every one of the drop down boxes.

problem solved.

thanks!
rhenders
 

Watch MrExcel Video

Forum statistics

Threads
1,118,057
Messages
5,569,955
Members
412,300
Latest member
Chaneycr
Top