Posted to microsoft.public.excel.misc
|
|
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.
|