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.

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.

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.

You could use "clear data validation". It will remove the dropdown without deleting the content.

Please check out this article:
http://office.microsoft.com/en-us/ex...159481033.aspx



EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng

I also inhereted an excel spreadsheet that had drop down boxes in it. It turns out they were Visual Basic drop down boxes. Quite a pain to remove. Here is how I did it:

1. Enable the developer tab. do this by right clicking on the toolbar and selecting "Customize Quick Access toolbar". Then select "popular" and then select show the developer tab.

2. Go to the Review Tab and unprotect it if it is protected(by clicking unprotect), and then click share, and uncheck the "Allow other users". It will bring up a confirmation message, select yes.

3. Go to the developer tab and select design mode. Right click on the drop down box and select delete.

Good luck
-MrScience101



kathy mayvill wrote:

How do I remove a dropdown box in Excel 2007?
20-Aug-08

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.

Previous Posts In This Thread:

On Wednesday, August 20, 2008 6:08 PM
kathy mayvill wrote:

How do I remove a dropdown box in Excel 2007?
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.

On Wednesday, August 20, 2008 6:21 PM
T. Valko wrote:

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

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

--
Biff
Microsoft Excel MVP

On Wednesday, August 20, 2008 6:40 PM
kathymayvill wrote:

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

"T. Valko" wrote:

On Wednesday, January 14, 2009 4:57 AM
amy c wrote:

You could use "clear data validation".
You could use "clear data validation". It will remove the dropdown without deleting the content.

Please check out this article:
http://office.microsoft.com/en-us/ex...159481033.aspx


Submitted via EggHeadCafe - Software Developer Portal of Choice
File Upload Control Using Silverlight
http://www.eggheadcafe.com/tutorials...rol-using.aspx