In this article, we will show how to sort by column in Excel while keeping rows together. Sorting is the best way to make the dataset more convenient and acceptable. This makes our work with datasets in various ways. MS Excel provides different ways to sort data for different purposes.
Firstly, we will use the Sort command. Secondly, we will go for the Advanced Sort command. Thirdly, we will sort the columns alphabetically. Then, we will sort multiple columns using the Sort command. Finally, we will use the SORT function to sort multiple columns alphabetically while keeping the rows together.
1. Using Excel Sort Command to Sort by Column and Keep Rows Together
This method will sort a dataset by column and keep the rows together. In the process, we will use the Sort command. This command will sort the column according to our needs.
Steps:
- Firstly, select the cells in the range D5:D10.
- Secondly, go to the Data tab.
- Thirdly, from the Sort & Filter group, choose Sort.
- As a result, a prompt will be on the screen.
- From the prompt, first, select Expand the selection.
- Then, click on Sort.
- Consequently, the Sort dialogue box will be on the screen.
- From the box, select the order of your sorting.
- In this case, we will select Smallest to Largest.
- Then, click OK.
- Consequently, the column will be sorted.
Read More: Sort Multiple Columns in Excel Independently of Each Other
2. Sorting Column Alphabetically by Columns and Keeping Rows Together in Excel
In this example, we will sort a column alphabetically while keeping the rows together. We will use the Advanced Sort command. This operation will arrange the names according to the alphabet.
Steps:
- To begin with, select the cells in the range C5:C10.
- Then, go to the Data tab.
- Finally, from the Sort & Filter group, select Sort A to Z.
- Consequently, a prompt will appear on the screen.
- From the prompt, select Expand the selection.
- Then, select Sort.
- As a result, the column will be sorted alphabetically.
Read More: How to Sort Columns in Excel Without Mixing Data
3. Sorting by Multiple Columns in Excel but Keep Rows Together
In this instance, we will sort the dataset by multiple columns. The sorting will be done, firstly by a particular column and then by another column. This will allow users to prioritize their sorting options.
Steps:
- To start with, choose the dataset.
- Then, select the Sort command from the Data tab.
- As a result, a prompt will appear on the screen.
- In the prompt, first, choose the Add Level option.
- After that, select the Name column in the Sort by option.
- Then, choose the Region column in the Then by option.
- Finally, click OK.
- As a result, the data set will be sorted by the two columns.
Read More: How to Sort Alphabetically in Excel and Keep Rows Together
4. Sorting Multiple Column Alphabetically by Column with Excel SORT Function
The SORT function sorts an array of data, and the users can specify how many columns to sort. In this example, we will sort all four columns using the SORT function.
Steps:
- Firstly, select the B13 cell and type,
=SORT(B5:E10,4)
- Then, hit Enter.
- As a result, the dataset will be sorted accordingly.
Read More: Excel Sort by Column Without Header
Download the Practice Workbook
Conclusion
In this article, we have talked about how to sort by column in Excel while keeping rows together. These are some ways to sort by column while keeping rows together in Excel. I have shown all the methods with their respective examples but there can be many other iterations. I have also discussed the fundamentals of the used functions. If you have any other way of achieving this, then please feel free to share it with us.