Forum Discussion
Chief2001
Aug 02, 2021Copper Contributor
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...
- Aug 02, 2021
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
Oct 20, 2021MVP
Could you attach a sample workbook demonstrating the problem?
AL_USMC
Oct 21, 2021Copper Contributor
- HansVogelaarOct 21, 2021MVP
If you want to keep the number:
- Make sure that Design Mode is off.
- Select the number in the text box.
- Press Ctrl+C to copy it.
- Click in an empty cell.
- Press Ctrl+V to paste the number into the cell.
- Turn on Design Mode.
- Click on the text box and press Delete to remove it.
- Finally, turn off Design Mode again.
- AL_USMCOct 21, 2021Copper ContributorThat was my course of action prior to contacting you; thought maybe there was a Design Mode option or setting change to cut down Ctrl + C / V time regarding text data. Truly appreciate your time and knowledge.