Forum Discussion
Ken Boone
Oct 16, 2018Copper Contributor
Sorting a list/values that are spread out over multiple columns
I am trying to alphabetically sort a list that spans multiple columns in Excel and while it seems like an easy task, I have not found a way to do it. For argument's sake, let's say there are 9 cells/...
BobOrrell
Oct 16, 2018Iron Contributor
It sounds like you're trying to take this:
and sort all 9 cells as one group and end up with this:
I don't know of a way of making that happen without getting into VBA