Select the drop menu cell, then menu DataValidation, then click the Clear
All button there.

--

HTH

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


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

"Bob Phillips" wrote:

Click the Clear All button.

--

HTH

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


"Cindy" wrote in message
...
How do I remove a down list from a cell?