Excel doesn't sort at all

%3CLINGO-SUB%20id%3D%22lingo-sub-1884658%22%20slang%3D%22en-US%22%3EExcel%20doesn't%20sort%20at%20all%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1884658%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20I%20have%20the%20Excel%202019%20version.%3C%2FP%3E%3CP%3EI%20have%20issues%20with%20sorting%20of%20my%20data.%20The%20problem%20is%20my%20excel%20doesn't%20sort%20at%20all.%3C%2FP%3E%3CP%3EI%20tried%20even%20with%20simple%20stuff%20like%20writing%201-10%20in%20cells%20and%20it%20won't%20even%20sort%20that.%20Not%20a%20warning%2C%20nothing%2C%20it%20seems%20like%20the%20sorting%20option%20is%20disabled.%20Filtering%20on%20the%20other%20hand%20works%20perfectly.%20What%20could%20be%20the%20problem%2C%20I%20have%20been%20looking%20on%20many%20sites%20for%20an%20answer%20but%20nothing%20is%20helping.%20My%20issue%20is%20just%20that%20my%20excel%20won't%20sort%20anything.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1884658%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1884700%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20doesn't%20sort%20at%20all%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1884700%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F868143%22%20target%3D%22_blank%22%3E%40Auralescent%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend.%20It%20can%20help%20us%20all%20if%20you%20upload%20an%20Excel%20file%20(without%20sensitive%20data)%2C%20no%20picture.%20Even%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%20You%20could%20get%20a%20precise%20solution%20much%20faster%20with%20a%20file%20(w%2Fout%20sensitive%20data).%20This%20would%20also%20be%20a%20blessing%20for%20all%20of%20us%2C%20as%20we%20can%20understand%20the%20problem%20much%20better%2C%20a%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello I have the Excel 2019 version.

I have issues with sorting of my data. The problem is my excel doesn't sort at all.

I tried even with simple stuff like writing 1-10 in cells and it won't even sort that. Not a warning, nothing, it seems like the sorting option is disabled. Filtering on the other hand works perfectly. What could be the problem, I have been looking on many sites for an answer but nothing is helping. My issue is just that my excel won't sort anything. 

2 Replies

@Auralescent 

With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. You could get a precise solution much faster with a file (w/out sensitive data). This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.

 

Thank you for your understanding and patience

 

 

Nikolino

I know I don't know anything (Socrates)

@Auralescent 

Is that for any file or some specific one?