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
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?