How to remove a Drop Down Box

%3CLINGO-SUB%20id%3D%22lingo-sub-2598167%22%20slang%3D%22en-US%22%3EHow%20to%20remove%20a%20Drop%20Down%20Box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2598167%22%20slang%3D%22en-US%22%3E%3CP%3EA%20drop-down%20box%20appeared%20on%20my%20Excel%20Spreadsheet%3C%2FP%3E%3CP%3EInside%20the%20box%20is%3A%26nbsp%3B%20%22PRICE%20(high%20to%20low)%22%20then%20there%20is%20an%20arrow%20down%20option%20that%20changes%20it%20to%20read%20%22Price%20low%20to%20high).%3C%2FP%3E%3CP%3EI%20can%20find%20no%20way%20to%20remove%20this%20object%20from%20my%20spreadsheet.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20not%20select%20this%20box%20to%20copy%2C%20paste%20or%20delete%20it.%26nbsp%3B%20This%20box%20is%20not%20connected%20to%20any%20cell%20so%20deleting%20the%20columns%20or%20rows%20does%20nothing%20to%20this%20box.%26nbsp%3B%20I%20can%20add%20rows%20above%20it%20and%20it%20just%20appears%20below%20the%20new%20rows.%26nbsp%3B%20HELP%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2598167%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2599339%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20remove%20a%20Drop%20Down%20Box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2599339%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1118643%22%20target%3D%22_blank%22%3E%40Chief2001%3C%2FA%3E%3C%2FP%3E%0A%3CP%3ECould%20you%20create%20a%20copy%20of%20the%20workbook%2C%20remove%20everything%20except%20the%20dropdown%20box%2C%20then%20save%20the%20copy%20and%20attach%20it%20to%20a%20reply%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2599772%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20remove%20a%20Drop%20Down%20Box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2599772%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20reply%3A%26nbsp%3B%20see%20attachment%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 remove this object from my spreadsheet. 

 

I can not select this box to copy, paste or delete it.  This box is not connected to any cell so deleting the columns or rows does nothing to this box.  I can add rows above it and it just appears below the new rows.  HELP

4 Replies

@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?

@Hans Vogelaar 

Thanks for your reply:  see attachment

@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.

That did it.
Thank you.

(Your directions were clear and complete, you made it easy....good job).