Sorting in Office 365 Excel for Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-1224452%22%20slang%3D%22en-US%22%3ESorting%20in%20Office%20365%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1224452%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20spending%20hours%20trying%20to%20find%20a%20solution%20for%20this%20issue%20I%20come%20to%20you%20guys%20to%20see%20if%20you%20can%20help%20me%3A%3CBR%20%2F%3E%3CBR%20%2F%3EI%20usually%20work%20with%20Windows%20at%20the%20office%2C%20but%20I'm%20currently%20working%20from%20home%2C%20with%20a%20Mac.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20Office%20365%20subscription%20and%20when%20trying%20to%20sort%20data%20(even%20the%20simplest%20two%20column%20table)%20it%20just%20won't%20do%20it%2C%20it%20remains%20without%20doing%20any%20action.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAm%20I%20the%20only%20one%20having%20this%20problem%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI%20had%20to%20open%20the%20file%20with%20Google%20Sheets%20so%20I%20could%20be%20able%20to%20sort%20it...%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20you%20can%20give%20me%20a%20hand!%20Thanks%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1224452%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1229021%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20in%20Office%20365%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1229021%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F580171%22%20target%3D%22_blank%22%3E%40Hector1991%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20select%20the%20range%20of%20your%20records%20and%20then%20try%20sorting%20the%20data.%3C%2FP%3E%3CP%3EIf%20you%20are%20still%20unable%20to%20do%20I%20would%20recommend%20you%20use%20Excel%20Online%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%3C%2FSPAN%3E.%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi everyone,

 

After spending hours trying to find a solution for this issue I come to you guys to see if you can help me:

I usually work with Windows at the office, but I'm currently working from home, with a Mac.

 

I have the Office 365 subscription and when trying to sort data (even the simplest two column table) it just won't do it, it remains without doing any action.

 

Am I the only one having this problem?

I had to open the file with Google Sheets so I could be able to sort it...


Hope you can give me a hand! Thanks :)

1 Reply
Highlighted

Hi @Hector1991 

 

Please select the range of your records and then try sorting the data.

If you are still unable to do I would recommend you use Excel Online

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.