If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
How do I remove a dropdown box in Excel 2007?
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
How do I remove a dropdown box in Excel 2007?
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 |
#5
|
|||
|
|||
How to delete a drop down box in Excel 2007
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 |
Thread Tools | |
Display Modes | |
|
|