Forum Discussion
Sorting related columns
I have several columns with text data, where the first one is "main", means that in each row the data in 2, 3, 4 rows is "connected" (not linked, but just related) to 1-st one. I need to sort the fir...
If the columns belong to the same contiguous region, select any cell in the first column, then sort. Excel will automatically sort the entire region on the first column.
If there are empty columns between the columns you want to sort, select the entire range that you want to sort.
Use the tab key to move the active cell in the selected range to the column you want to sort on, if necessary. Then sort.