Forum Discussion
ch98tom
Sep 02, 2021Copper Contributor
Excel sorting one column only
How do I sort one column of text in alphabetical order without all the other adjacent columns also sorting?
- Sep 02, 2021Ah 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.
ch98tom
Sep 02, 2021Copper Contributor
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?
DKoontz
Sep 02, 2021Iron Contributor
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.