UNABLE TO EXCEL SORT FUNCTION

%3CLINGO-SUB%20id%3D%22lingo-sub-2894268%22%20slang%3D%22en-US%22%3EUNABLE%20TO%20EXCEL%20SORT%20FUNCTION%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2894268%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20attached%20an%20excel%20sheet%20I%20tried%20sorting%20column%20A%20%26amp%3B%20B%20but%20it%20does%20not%20get%20sorted.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2894268%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2894886%22%20slang%3D%22en-US%22%3ERe%3A%20UNABLE%20TO%20EXCEL%20SORT%20FUNCTION%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2894886%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1198369%22%20target%3D%22_blank%22%3E%40Mary_Xavier30%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20cell%20A1%2C%20then%20click%20Sort%20%26amp%3B%20Filter%20%26gt%3B%20Custom%20Sort...%20on%20the%20Home%20tab%20of%20the%20ribbon.%3C%2FP%3E%0A%3CP%3EClear%20the%20check%20box%20'My%20data%20has%20headers'%2C%20and%20specify%20that%20you%20want%20to%20sort%20on%20column%20A%2C%20then%20on%20column%20B.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0850.png%22%20style%3D%22width%3A%20586px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F320757iD6FE463CE0758A24%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S0850.png%22%20alt%3D%22S0850.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EExcel%20will%20display%20a%20warning%20about%20column%20B.%20In%20this%20case%2C%20it%20doesn't%20matter%20which%20option%20you%20choose%2C%20so%20just%20click%20OK.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have attached an excel sheet I tried sorting column A & B but it does not get sorted.

1 Reply

@Mary_Xavier30 

Select cell A1, then click Sort & Filter > Custom Sort... on the Home tab of the ribbon.

Clear the check box 'My data has headers', and specify that you want to sort on column A, then on column B.

S0850.png

Excel will display a warning about column B. In this case, it doesn't matter which option you choose, so just click OK.