If you are looking for how to sort rows by column in Excel, then you are in the right place. When you are dealing with a big amount of datasets, searching, organizing, keeping them in a specific cell, and tracking the specific data becomes more complicated. To avoid this situation, excel has an amazing feature called “sorting”. Using this feature you can sort your data by column, value, dates, or any other special conditions. It will help you to quickly understand, find, and visualize your data and will make your action faster. In this article, we will discuss how to sort rows by column in Excel.
Read more: Excel Sort By Date And Time
Download Practice Workbook
Download this practice sheet to practice while you are reading this article.
4 Ways to Sort Rows by Column in Excel
1. Using Ascending (A-Z) or Descending (Z-A) Options
In most common cases we need to sort rows from smallest to largest (A-Z) or from largest to smallest (Z-A) by column. We can do it by following these easy steps.
1.1. Sort Rows by Column from A-Z (Smallest to Largest)
First, we want to sort rows by column from smallest to largest. We need a data set for that. We can take this picture as a sample. It has column headers as ID Number, Name, Order 1, Order 2, Order 3.
- Secondly, select the Dataset > open your Data tab > go to the “Sort & Filter” ribbon and click this icon
- Eventually, we can see that the rows are sorted according to the columns.
1.2. Sort Rows by Column from Z-A (Largest to Smallest)
Now we will sort rows by column from largest to smallest (Z-A).
- To do this, firstly, select the ID Number
- Secondly, open your Data tab > go to the Sort & Filter ribbon and click this icon
- Consequently, our rows are sorted with respect to the columns.
2. Utilizing Custom Sorting Method to Sort Rows by Column
Custom sorting is an amazing process of sorting your rows by column. Applying this method you can easily sort your rows by column by swallowing these steps.
We have the dataset below and need to sort rows by column.
- Firstly, select your data range, go to “Data” and click this icon
- A window named Sort will appear.
- Secondly, go to Options.
- Eventually, another window will pop up named Sort Options. We want to sort rows by column. So, click on Sort Left to Right.
- Now a sorting style window appears where we can sort rows. We will sort by Row 4, sort on Cell Values and order is Largest to Smallest. Click OK.
Columns now sort our rows. You can also sort rows from Smallest to largest by using the same steps. Just choose the order Smallest to Largest and your sorting will be done.
3. Multi-level Sorting Method to Sort Rows by Column
Using this method, we can sort multiple rows by columns. Follow these steps.
- Firstly, select your dataset and go to Data and click this icon
- Secondly, when the Sort window arrives, click on Option. Then on the new popped-up window, choose Sort Left to Right.
- On the Sort window, click on Add Level to add another row to the existing sorted row. In the picture below we added two new levels (Row 5, Row 6). Then we customize their style by their values and from Largest to Smallest.
- Lastly, click OK.
- Eventually, our rows are now sorted by their column value.
4. Applying SORT and SORTBY Functions
The SORT function is pretty useful when you are to sort a wide range of data. In this method, we will use this function to sort the rows by column. We’ll also use the SORTBY function to make the final sorting.
Read more: How to Sort Data in Excel Using Formula
- Firstly, copy the column headers and paste them to the cell where you want to get your sorted values. In this case, it is cell H5.
- Secondly, apply the “SORT” function in the H5
- “Array” is the selected Range or array to sort. (B5:F16)
- [sort_index] is the Column index to use for sorting. Default is 1. We choose (3)
- [sort_order] where, Ascending=1, Descending = -1. Default is ascending order. We choose (1)
- [by_col] where, sort by column=TRUE , sort by row= FALSE . Default is FALSE. We choose
- Thirdly, press “ENTER”.
- Eventually, our rows are sorted.
- Additionally, if we want to sort ID Number in an Ascending manner, we need to use the SORTBY function. So, write the formula in the H5
- If we press ENTER we’ll see that the ID Numbers are sorted in an Ascending manner.
Things to Remember
➤ The “SORT” function is only available for “Excel 365”. You won’t be able to use this function unless you have this version of excel.
➤ You can auto-sort columns by their value when you use the SORT function.
➤ In the case of sorting, you need to select the header column cell when you sort your data.
➤ When you perform multi-level custom sorting method, the data will first be sorted by the 1st level, then the 2nd level, and so on.
Four methods of Sorting rows by column in excel are discussed in this article. Hope this article is useful to you and helps you when you are facing problems. If you have any confusion or suggestions, you are welcome to comment.
- Sort Column by Value in Excel (5 Methods)
- How to Sort Multiple Columns in Excel (5 Quick Approaches)
- How to Sort Columns in Excel without Mixing Data
- How to Sort Multiple Columns in Excel Independently of Each Other
- How to Sort Two Columns in Excel to Match (Both Exact and Partial Match)
- Sorting Columns in Excel While Keeping Rows Together
- How to Auto Sort Multiple Columns in Excel (3 Ways)