Removing a drop down list from a cell

B

Bob Phillips

Click the Clear All button.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
N

NeoAmit

Click on Data--->Validation

Under the Settings Tab--> Field Allow = Any Value.

That should solve it
 
C

Cindy

Sorry Bob, I am new to Excel spreadsheets. Where do I find the Clear all
button? I don't see it. Will this only remove the one drop menu or will it
remove all of them in my spreadsheet. Thanks
 
T

tjtjjtjt

It seems liekly that the drop-downs are from Data | Validation.
Did you select all the cells in which the drop-down was appearing before you
tried NeoAmit's solution? If not, select all the cells and try again.

For the Clear All solution:
Select All the cells with the drop-down.
Then, Edit | Clear | All.

It's also possible you have the AutoFilter activated. For that, click on a
cell that has the drop-down and go to Data | Filter. If the AutoFilter has a
check by it, click on AutoFilter to eliminate the drop-downs.
If AutoFilter doesn't have a check next to it, don't click on it, or you
will just make the probelm worse.


If these don't work, you may try posting back with more information about
how the spreadsheet was created. Including how the drop-downs were created in
the first place.

tj
 
B

Bob Phillips

Select the drop menu cell, then menu Data>Validation, then click the Clear
All button there.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
D

Debra Dalgleish

Select the cell
Choose Data>Validation
Click the Clear All button (at the bottom left of the window)
Click OK
 
C

Cindy

Thanks for all the clarification there. However none of that worked either. I
cannot tell you how the sheet was original created as I didn't create this
sheet. It is a passed on worksheet. I hate acquiring someone else's mess.
ha I finally got one of the drop downs to disappear by selecting the cell
and cutting it 8 times.
 
J

Jennifer

Cindy - do you mean that the drop down arrow is still showing and you can't
get rid of it??? If so - I am having the same issue... the validation thing
is not working and niether is unchecking "autofilter" under "data" ("Show
all" is not available either??). Can you explain what you mean by "cutting
it 8 times"....

Thanks :)

Jennifer Pavey
 
J

JulieD

Hi Jennifer

if you're unsure how the drop down arrow was created and it appears when you
are not clicked on the cell then another option is that it was created using
a control from the control toolbox
choose view / toolbars / control toolbox
the first icon on this new toolbar is a blue protractor type thingy and if
you hold the mouse over it it should say design mode.
click on it
now click on the drop down arrow and press delete
if it got rid of it, click on the blue protractor thing again and then close
the toolbox

hope this helps
Cheers
julieD
 
Top