Column keeps sorting descending after selecting ascending

%3CLINGO-SUB%20id%3D%22lingo-sub-1616234%22%20slang%3D%22en-US%22%3EColumn%20keeps%20sorting%20descending%20after%20selecting%20ascending%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1616234%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20table%20in%20Excel%2C%20and%20I'm%20trying%20to%20sort%20a%20column%20Ascending.%26nbsp%3B%20No%20matter%20what%20I%20do%2C%20it%20keeps%20sorting%20Descending.%26nbsp%3B%20All%20Property%20Names%2C%20no%20numbers%20to%20sort.%26nbsp%3B%20I%20tried%20converting%20the%20table%20to%20a%20range%2C%20and%20that%20didn't%20work.%26nbsp%3B%20Please%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1616234%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1616252%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20keeps%20sorting%20descending%20after%20selecting%20ascending%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1616252%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F773337%22%20target%3D%22_blank%22%3E%40aammendy%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20please%20share%20a%20sample%20of%20the%20workbook%20that%20you%20are%20having%20this%20issue%20with%3F%20Please%20remove%20any%20sensitive%20information%20-%20of%20course.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1616284%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20keeps%20sorting%20descending%20after%20selecting%20ascending%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1616284%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22aammendy_2-1598536970275.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F215035i10CD4226FCE22241%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22aammendy_2-1598536970275.png%22%20alt%3D%22aammendy_2-1598536970275.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1616378%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20keeps%20sorting%20descending%20after%20selecting%20ascending%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1616378%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F773337%22%20target%3D%22_blank%22%3E%40aammendy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20it%20be%20possible%20to%20share%20a%20sample%20of%20the%20workbook%20itself%3F%20Unfortunately%2C%20I%20cannot%20gather%20enough%20details%20regarding%20the%20issue%20with%20just%20this%20screenshot.%20Again%2C%20please%20remove%20any%20sensitive%20information.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a table in Excel, and I'm trying to sort a column Ascending.  No matter what I do, it keeps sorting Descending.  All Property Names, no numbers to sort.  I tried converting the table to a range, and that didn't work.  Please help.

3 Replies

Hello @aammendy,

 

Could you please share a sample of the workbook that you are having this issue with? Please remove any sensitive information - of course.

@aammendy 

 

Would it be possible to share a sample of the workbook itself? Unfortunately, I cannot gather enough details regarding the issue with just this screenshot. Again, please remove any sensitive information.

 

Thank you!