View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
kathy mayville[_2_] kathy mayville[_2_] is offline
external usenet poster
 
Posts: 1
Default How do I remove a dropdown box in Excel 2007?

It looks like it may be a filter, but the remove filter is greyed out.

"T. Valko" wrote:

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.