How do I remove a combo box in Excel 2007

  • Thread starter Thread starter Harry Flashman
  • Start date Start date
H

Harry Flashman

I have excel 2003 at work and I inserted a combo box (I think that is
what it is called) with a drop down menu. I am at home now using a
computer with Excel 2007 and I want to remove this Combo Box, but I
can't find the tool bar (control box?) that I used to create/edit it.
This is quite frustrating. Can anyone tell me where it is please? I
want to remove this box.
 
You have to show the developer's tab on the ribbon.

That's under the office button|excel options.
It's a checkbox in the top section of the Popular category.

Then look in the Developer's group on the ribbon.

Then you'll be able to find the "toolbar".

But if you used a combobox from the control toolbox toolbar, you'll have to go
into design mode (another icon in that group).

Then select the combobox and delete it.

Then toggle the design mode icon again to leave that mode.
 
You have to show the developer's tab on the ribbon.

That's under the office button|excel options.
It's a checkbox in the top section of the Popular category.

Then look in the Developer's group on the ribbon.  

Then you'll be able to find the "toolbar".

But if you used a combobox from the control toolbox toolbar, you'll have to go
into design mode (another icon in that group).

Then select the combobox and delete it.  

Then toggle the design mode icon again to leave that mode.
Click to expand...

Thanks very much Dave.
 
Back
Top