Forum Discussion

ch98tom's avatar
ch98tom
Copper Contributor
Sep 02, 2021
Solved

Excel sorting one column only

How do I sort one column of text in alphabetical order without all the other adjacent columns also sorting?
excel
  • DKoontz's avatar
    DKoontz
    Sep 02, 2021
    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.
DKoontz's avatar
DKoontz
Iron Contributor
Sep 02, 2021

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.

 

 

Resources