Forum Discussion

Chief2001

Copper Contributor

Aug 02, 2021

Solved

How to remove a Drop Down Box

A drop-down box appeared on my Excel Spreadsheet Inside the box is: "PRICE (high to low)" then there is an arrow down option that changes it to read "Price low to high). I can find no way to remov...

excel

HansVogelaar
Aug 02, 2021
Chief2001

Thanks. It is a so-called ActiveX combo box.

Make sure that you see the Developer tab of the ribbon. If not:

Select File > Options.

Select 'Customize Ribbon' in the navigation pane on the left.

Tick the check box Developer in the list of Main Tabs on the right.

Click OK.

Activate the Developer tab of the ribbon.

In the Controls group, click to highlight Design Mode.

You can now select the combo box by clicking on it.

Press Delete to remove it.

Don't forget to turn off Design Mode again.

HansVogelaar

MVP

Aug 02, 2021

Chief2001

Could you create a copy of the workbook, remove everything except the dropdown box, then save the copy and attach it to a reply?

Chief2001
Copper Contributor
Aug 02, 2021
HansVogelaar
Thanks for your reply: see attachment
example.xlsx32 KB
- HansVogelaar
  MVP
  Aug 02, 2021
  Chief2001
  
  Thanks. It is a so-called ActiveX combo box.
  
  Make sure that you see the Developer tab of the ribbon. If not:
  
  Select File > Options.
  
  Select 'Customize Ribbon' in the navigation pane on the left.
  
  Tick the check box Developer in the list of Main Tabs on the right.
  
  Click OK.
  
  Activate the Developer tab of the ribbon.
  
  In the Controls group, click to highlight Design Mode.
  
  You can now select the combo box by clicking on it.
  
  Press Delete to remove it.
  
  Don't forget to turn off Design Mode again.
  - Meghashyam Borle
    Copper Contributor
    Dec 20, 2021
    The best, simplest solution. Thanks