SOLVED

Excel sorting one column only

%3CLINGO-SUB%20id%3D%22lingo-sub-2712230%22%20slang%3D%22en-US%22%3EExcel%20sorting%20one%20column%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2712230%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20sort%20one%20column%20of%20text%20in%20alphabetical%20order%20without%20all%20the%20other%20adjacent%20columns%20also%20sorting%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2712230%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2712425%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20sorting%20one%20column%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2712425%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1144730%22%20target%3D%22_blank%22%3E%40ch98tom%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20highlight%20just%20the%20column%20you%20want%20to%20sort%2C%20then%20under%20sort%20%26amp%3B%20Filter%20in%20the%20home%20tab%2C%20hit%20sort%20A-Z%2C%20then%20press%20the%20%22continue%20with%20current%20selection%22%20option.%20This%20will%20only%20sort%20the%20selected%20data%2C%20leaving%20the%20data%20next%20to%20it%20alone.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DKoontz_0-1630598564425.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F307648i1CE553814EF2BDDD%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22DKoontz_0-1630598564425.png%22%20alt%3D%22DKoontz_0-1630598564425.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2712446%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20sorting%20one%20column%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2712446%22%20slang%3D%22en-US%22%3EBut%20that%20doesn't%20work.%20The%20%22Continue%20with%20the%20current%20selection%22%20box%20warning%20does%20not%20come%20up%20and%20sorts%20all%20the%20columns.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2712747%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20sorting%20one%20column%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2712747%22%20slang%3D%22en-US%22%3ETry%20custom%20sort%3F%20I%20can't%20get%20the%20box%20to%20not%20pop%20up%20when%20selecting%20data%20that's%20along%20side%20other%20data.%20Could%20there%20be%20hidden%20columns%3F%3C%2FLINGO-BODY%3E
Occasional Contributor

How do I sort one column of text in alphabetical order without all the other adjacent columns also sorting?

9 Replies

@ch98tom 

If you highlight just the column you want to sort, then under sort & Filter in the home tab, hit sort A-Z, then press the "continue with current selection" option. This will only sort the selected data, leaving the data next to it alone.

 

DKoontz_0-1630598564425.png

 

But that doesn't work. The "Continue with the current selection" box warning does not come up and sorts all the columns.
Try custom sort? I can't get the box to not pop up when selecting data that's along side other data. Could there be hidden columns?

No hidden columns and when I go to custom sort the whole table gets highlighted automatically @DKoontz perhaps it is to do with the table format?

best response confirmed by allyreckerman (Microsoft)
Solution
Ah yeah that would be it. You have to take it out of the table in order to sort just one column. If your data is in a table it's assumed that each row is its own entry, switching around data between rows in a table would mess things up.
Yes, I think that's cracked it. Is there a way of taking into out of the Table or do I need to copy the data to a new tab and delete the current tab?
Yeah! Right click anywhere in the table > table > convert to range
Amazing, thank you so much. Would never of worked that out.
Glad I could help!