Sorting a list/values that are spread out over multiple columns

Question

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.&nbsp;For&nbsp;argument's sake, let's say there are 9&nbsp;cells/values in the list and that it&nbsp;begins&nbsp;in&nbsp;A1 and ends in&nbsp;C3. I can sort any row or column, but I'd like to sort the entire range so that the lowest value is in A1 and the highest value is in C3. Multicolumn lists can be sorted with relative ease in Word, I expect because the list is interpreted as a table. Perhaps the solution lies therein?

lorenzo kim · Answer

try these sites:https://exceljet.net/lessons/how-to-sort-with-using-more-than-one-columnhttps://support.office.com/en-us/article/quick-start-sort-data-in-an-excel-worksheet-60153f94-d782-47e2-96a8-15cbb7712539https://guides.lib.umich.edu/c.php?g=283162&amp;p=1886445

boborrell · Answer

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

Forum Discussion

Sorting a list/values that are spread out over multiple columns

Resources