Removing an empty drop down menu

%3CLINGO-SUB%20id%3D%22lingo-sub-2302212%22%20slang%3D%22en-US%22%3ERemoving%20an%20empty%20drop%20down%20menu%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2302212%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20removing%20an%20empty%20drop%20down%20menu.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20added%20some%20cells%20to%20my%20spreadsheet%20after%20placing%20a%20drop%20down%20menu%20in%20a%20cell.%26nbsp%3B%20Now%20the%20cell%20where%20the%20drop%20down%20was%20still%20shows%20an%20arrow%20beside%20it%20for%20a%20drop%20down%2C%20but%20there%20are%20no%20items%20listed.%26nbsp%3B%20I%20want%20to%20get%20rid%20of%20the%20drop%20down%20arrow%20beside%20the%20original%20cell%20that%20now%20no%20longer%20has%20a%20drop%20down.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20go%20through%20the%20Data%20tab%20%26gt%3B%20Data%20Validation%20and%20clicked%20on%20the%20%22Clear%20All%22%20button.%26nbsp%3B%20%26nbsp%3BHowever%20the%20arrow%20still%20appears%20beside%20the%20cell.%26nbsp%3B%20How%20can%20I%20get%20rid%20of%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2302212%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2302264%22%20slang%3D%22en-US%22%3ERe%3A%20Removing%20an%20empty%20drop%20down%20menu%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2302264%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1039542%22%20target%3D%22_blank%22%3E%40Chris_Maloney%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EClear%20All%20shall%20work%20if%20you%20stay%20on%20cell(s)%20with%20data%20validation.%20Perhaps%20you%20may%20provide%20small%20sample%20file%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I need help removing an empty drop down menu. 

 

I added some cells to my spreadsheet after placing a drop down menu in a cell.  Now the cell where the drop down was still shows an arrow beside it for a drop down, but there are no items listed.  I want to get rid of the drop down arrow beside the original cell that now no longer has a drop down.

 

I did go through the Data tab > Data Validation and clicked on the "Clear All" button.   However the arrow still appears beside the cell.  How can I get rid of it?

 

Thanks.

5 Replies

@Chris_Maloney 

Clear All shall work if you stay on cell(s) with data validation. Perhaps you may provide small sample file?

@Sergei Baklan ,

 

I did try that.  I've attached a sample file.  The cell in question is I-52.

@Chris_Maloney 

That's not a data validation, this is Combo Box control

image.png

Just select column J and Del

 

That worked. Thanks!

@Chris_Maloney , you are welcome