sort function

%3CLINGO-SUB%20id%3D%22lingo-sub-1207106%22%20slang%3D%22en-US%22%3Esort%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1207106%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20a%20%22trial%20and%20error%22%20user%20of%20Excel.%26nbsp%3B%20I%20used%20to%20be%20able%20to%20sort%20an%20array%20of%20data%20using%20the%20options%20in%20my%20ribbon%2C%20but%20I've%20lost%20that%20sort%20function.%26nbsp%3B%20Actually%2C%20did%20I%20lose%20it%20or%20was%20it%20taken%20away%3F%26nbsp%3B%20Either%20way%2C%20I%20need%20it%20back.%26nbsp%3B%20I%20been%20studying%20the%20help%20available%20on%20line%20but%20I'm%20losing%20the%20little%20patience%20that%20I%20have.%26nbsp%3B%20Is%20there%20as%26nbsp%3Bquick%20fix%20to%20restore%20the%20sort%20function%20to%20my%20Excel%202016%2FOffice%20365%3F%26nbsp%3B%20Is%20it%20restorable%3F%26nbsp%3B%20I%20need%20someone%20to%20hold%20my%20hand%20and%20walk%20me%20through%20my%20dilemma.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1207106%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E%40%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I am a "trial and error" user of Excel.  I used to be able to sort an array of data using the options in my ribbon, but I've lost that sort function.  Actually, did I lose it or was it taken away?  Either way, I need it back.  I been studying the help available on line but I'm losing the little patience that I have.  Is there as quick fix to restore the sort function to my Excel 2016/Office 365?  Is it restorable?  I need someone to hold my hand and walk me through my dilemma.

  • @
1 Reply
Highlighted

Hi @Pyropro;

 

Please note that the new SORT function is available only for Office365 user, if you have Excel 2016 then it will not work. Make sure you have the latest update.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com

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