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

Select the cell, do datavalidationclear all, click OK

--

Regards,

Peo Sjoblom

"cdeldegan" wrote in message
...
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

Select the cell

DataValidation, then click Clear All

--

HTH

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


"cdeldegan" wrote in message
...
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

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

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

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=478383