drop down option in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello!

How do you remove a drop down box within a cell? I tried
Data/Validation/Clear All, but it did not remove the box.
Any suggestions?
Thanks!
 
Maybe it isn't a DV drop-down.

There are other forms of drop-downs from the Control Toolbox or the Forms
Toolbars.

Could be a list box, combobox or somesuch creature.

F5>Special>Objects>OK

Anything selected?


Gord Dibben Excel MVP
 
Right click on the box, if you can edit it, you can delete it or cut
it, if not then you mat have an activeX.
Bring up the control toolbar=>select the button with the speed quare on
it, this puts you in design mode, now when you put the mouse cursor
over the box it should turn into a little + , if that happens then you
can right click and delete(or cut)
dave
 
You must log in or register to reply here.

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

customize drop-down box 1
Drop down fill box does not appear when cell clicked. 1
data validation fonts differ in drop down box 1
How do I create a drop down box within a drop down box? 1
drop down box in cell 1
Formatted cell column in drop down list 1
Remove blank cells from data validation drop down box 3
Drop Down with dynamic named range offsheet source list 14

Back
Top