A
askme askmeagain
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
right-click in the cell I see ....pick from drop-down list. I need to ge
rid of list. How do I do that? Thank you.
Previous Posts In This Thread:
How do I remove a dropdown box in Excel 2007?
I have inherited a spreadsheet that has hidden drop-down boxes. When
right-click in the cell I see ....pick from drop-down list. I need to ge
rid of list. How do I do that? Thank you.
If it's a data validation drop down list....
If it is a data validation drop down list...
Select the cell in questio
Goto the Home tab>Editing group>click the "eraser" icon>Clear Al
-
Bif
Microsoft Excel MVP
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
:
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/excel/HP102159481033.aspx
Submitted via EggHeadCafe - Software Developer Portal of Choice
File Upload Control Using Silverlight
http://www.eggheadcafe.com/tutorial...1-4149e4482d51/file-upload-control-using.aspx
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
right-click in the cell I see ....pick from drop-down list. I need to ge
rid of list. How do I do that? Thank you.
Previous Posts In This Thread:
How do I remove a dropdown box in Excel 2007?
I have inherited a spreadsheet that has hidden drop-down boxes. When
right-click in the cell I see ....pick from drop-down list. I need to ge
rid of list. How do I do that? Thank you.
If it's a data validation drop down list....
If it is a data validation drop down list...
Select the cell in questio
Goto the Home tab>Editing group>click the "eraser" icon>Clear Al
-
Bif
Microsoft Excel MVP
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
:
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/excel/HP102159481033.aspx
Submitted via EggHeadCafe - Software Developer Portal of Choice
File Upload Control Using Silverlight
http://www.eggheadcafe.com/tutorial...1-4149e4482d51/file-upload-control-using.aspx
