SOLVED

#Excel Formula problem

%3CLINGO-SUB%20id%3D%22lingo-sub-2024364%22%20slang%3D%22en-US%22%3E%23Excel%20Formula%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2024364%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20spreadsheet%20that%20is%20sent%20to%20me%20weekly%20that%20when%20I%20try%20to%20filter%20and%20sort%20on%20specific%20column%20I%20get%20a%20symbol%20around%20the%20down%20arrow%20which%20is%204%20circles%20in%20each%20corner%20to%20look%20like%20the%20corners%20of%20a%20box%20with%20a%20line%20going%20down%20to%204%20arrows%20pointing%20up%20down%20and%20side%20by%20side.%26nbsp%3B%20I%20am%20not%20able%20to%20sort%20unless%20I%20go%20to%20formulas%20and%20then%20show%20formulas.%26nbsp%3B%20And%20even%20sometimes%20I%20still%20am%20not%20able%20to%20sort%20that%20specific%20column%20even%20with%20showing%20formulas%2C%20any%20suggestions%20on%20how%20to%20fix%20this%20as%20I%20have%20not%20been%20able%20to%20find%20any.%26nbsp%3B%20Pic.%20below.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2027509%22%20slang%3D%22en-US%22%3ERe%3A%20%23Excel%20Formula%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2027509%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F914961%22%20target%3D%22_blank%22%3E%40JennGibson2Learn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20the%20question%20for%20Excel%20community%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3EWelcome%20to%20the%20Excel%20group.%20(microsoft.com)%3C%2FA%3E%26nbsp%3B%2C%20this%20space%20is%20for%20discussions%20about%20MTC%20itself.%3C%2FP%3E%0A%3CP%3EIn%20brief%2C%20when%20this%20object%20is%20selected%20just%20press%20Del%2C%20you%20don't%20need%20it.%20After%20that%20sort%2Ffilter%20as%20desired.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have an excel spreadsheet that is sent to me weekly that when I try to filter and sort on specific column I get a symbol around the down arrow which is 4 circles in each corner to look like the corners of a box with a line going down to 4 arrows pointing up down and side by side.  I am not able to sort unless I go to formulas and then show formulas.  And even sometimes I still am not able to sort that specific column even with showing formulas, any suggestions on how to fix this as I have not been able to find any.  Pic. below.

2 Replies
best response confirmed by JennGibson2Learn (New Contributor)
Solution

@JennGibson2Learn 

That's the question for Excel community here Welcome to the Excel group. (microsoft.com) , this space is for discussions about MTC itself.

In brief, when this object is selected just press Del, you don't need it. After that sort/filter as desired.

@Sergei Baklan Thank you for the information.