How to delete a drop down box in Excel 2007

  • Thread starter askme askmeagain
  • Start date

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top