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 first column according to alphabetic order and I also need that other columns would be sorted automatically in such way that every row is sorted according to data in the 1st column, i.e. that sorting each cell in the first column I will sort not only it but also the whole row for all other columns, but basing only on the first cell.
Is it possible somehow?
1 Reply
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.
