If it's a data validation drop down list....

Select the cell in question
Goto the Home tabEditing groupclick the "eraser" iconClear All

--
Biff
Microsoft Excel MVP


"kathy mayville" <kathy wrote in message
...
I have inherited a spreadsheet that has hidden drop-down boxes. When I
right-click in the cell I see ....pick from drop-down list. I need to get
rid of list. How do I do that? Thank you.