Excel will not sort subtotals

%3CLINGO-SUB%20id%3D%22lingo-sub-1409504%22%20slang%3D%22en-US%22%3EExcel%20will%20not%20sort%20subtotals%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1409504%22%20slang%3D%22en-US%22%3E%3CP%3EAfter%20inserting%20subtotals%2C%20Excel%20is%20not%20allowing%20me%20to%20sort%20the%20subtotals.%26nbsp%3B%20I've%20followed%20online%20help%20tips%2C%20but%20it%20is%20not%20working.%26nbsp%3B%20Most%20instruct%20me%20to%20highlight%20the%20column%20I%20want%20to%20sort%20by%2C%20click%20sort%2C%20then%20expand%20the%20selection.%26nbsp%3B%20That%20is%20supposed%20to%20work.%26nbsp%3B%20But%20I%20then%20get%20the%20sort%20dialogue%20box%20to%20choose%20sort%20columns.%26nbsp%3B%20Once%20I%20do%20that%2C%20I%20get%20the%20message%20that%20%22This%20removes%20the%20subtotals%20and%20sorts%20again.%26nbsp%3B%20If%20you%20want%20to%20sort%20the%20subtotaled%20groups%2C%20chose%20the%20cancel%20button%3B%20then%20collapse%20the%20outline%20and%20try%20again.%22%26nbsp%3B%20Then%20the%20same%20things%20happens.%26nbsp%3B%20Any%20advice%20on%20how%20to%20sort%20on%20the%20subtotals%3F%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1409504%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1409756%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20will%20not%20sort%20subtotals%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1409756%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F676014%22%20target%3D%22_blank%22%3E%40tmself%3C%2FA%3E%26nbsp%3Babc%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

After inserting subtotals, Excel is not allowing me to sort the subtotals.  I've followed online help tips, but it is not working.  Most instruct me to highlight the column I want to sort by, click sort, then expand the selection.  That is supposed to work.  But I then get the sort dialogue box to choose sort columns.  Once I do that, I get the message that "This removes the subtotals and sorts again.  If you want to sort the subtotaled groups, chose the cancel button; then collapse the outline and try again."  Then the same things happens.  Any advice on how to sort on the subtotals?

Thanks,

2 Replies

@tmself abc

@tmself 

Was able to do it by formatting as a table after subtotaling.