drop-down menus

%3CLINGO-SUB%20id%3D%22lingo-sub-2233584%22%20slang%3D%22en-US%22%3Edrop-down%20menus%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2233584%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20turn%20off%20the%20drop-down%20menus%20that%20just%20appeared%20in%20many%20of%20the%20adjacent%20cells%20in%20an%20Excel%20spreadsheet.%26nbsp%3B%20See%20attached%20document.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2233584%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

How do I turn off the drop-down menus that just appeared in many of the adjacent cells in an Excel spreadsheet.  See attached document.

2 Replies

@Richard_Moon 

They are probably filter arrows.

Click in any of those cells, then click Sort & Filter > Filter on the Home tab of the ribbon.

Does that remove the arrows?

@Hans Vogelaar Thank you!  Right on.  The boxes disappeared and now I can see what is the cells.  Thanks again