Through this article, I am going to share with you how you can use the Sort function in Microsoft Excel. So, follow below the simple and very easy steps to know how to use this function.
With the help of this function, you can, shot your single column data as well multiple column data in any order whether it is ascending or descending. First, let’s see how to use this function in a single column or one column.
Sort Single Column
Step 1: The very first step is to open your spreadsheet or create dummy data to perform this function or test this function.
Step 2: In the second step, select your column and click on any cell which you want to sort, in the below image I have selected the Name column.
Step 3: If you want to sort your data in ascending order then go to the Data tab, and in the sort & filter group click on AZ.
Step 4: See below the result.
Note: If you want to sort your data into descending order then simply click on ZA instead of AZ.
Now, let’s see how you can sort your data on Multiple columns.
- How to Wrap text in Microsoft Excel
- How to Calculate Mean in Excel
- How to deduce the Coefficient of variation using Excel
- How to Transpose in Excel
Sort Multiple Columns
Step 5: Follow Step 1.
Step 6: Go to the Data tab, and in the group of Sort & Filter, then click on Sort.
After that, you will see the dialog box.
Step 7: In the dialog box, click on the Last Name in Sort by list.
Step 8: Now, click on Add Level and select the Sales from Then by list.
Step 9: Now, click OK to complete the action.