Remove drop-down list in Excel

C

cdeldegan

We accidentally ended up with a drop-down list on one of the cells of our
Excel worksheet and we can't figure out how to make it go away... Please help.

We are using MS Office 2002

Thank you
 
B

Bob Phillips

Select the cell

Data>Validation, then click Clear All

--

HTH

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

paul

if it is a combo box from forms toolbar right click on it and cut.......dont
paste it anywhere tho......:)This would work for a control toolar combo
too.If it is a data validation list you just have to clear your data
validations
 
P

pinmaster

Hi,
Try this:
Select the cell then goto Data/Validation and click on "Clear All"

HTH
J
 
Top