Forum Discussion

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?

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.

9 Replies

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.
- ch98tom
  Copper Contributor
  Sep 02, 2021
  But that doesn't work. The "Continue with the current selection" box warning does not come up and sorts all the columns.
  - DKoontz
    Iron Contributor
    Sep 02, 2021
    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?

Resources