How do I get rid of a drop down box exported from a worksheet?

E

EW

I exported data from another worksheet into excel from specific sortware.
Graphics came with the data. All the other ones I could delete but I could
not delete a drop down box.
 
A

Ashish Mathur

Hi,

Did you try Ctrl + G > Special > Objects. This will select all objects
including drop down boxes. Now simply hit the delete button.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

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

Similar Threads

Drop down box issue 2
drop down box 1
excel 2003 drop-down box color changes how 2
Vlookup v. drop down box for mailing addresses 1
Can you link to a drop down list from another drop down list? 2
How do I create a spreadsheet that populates q's from a drop down 3
customize drop-down box 1
Formatted cell column in drop down list 1

Top