Remove drop-down list in Excel

[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

[pinmaster]

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

HTH
JG

[Peo Sjoblom]

Select the cell, do data>validation>clear all, click OK

--

Regards,

Peo Sjoblom

"cdeldegan" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[Bob Phillips]

Select the cell

Data>Validation, then click Clear All

--

HTH

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


"cdeldegan" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[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
--
paul
remove nospam for email addy!



"cdeldegan" wrote:

> 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
>