Sorting in Excel
Sorting in Excel in ascending or descending order and Custom Sort with data:- We can sort data with two types i.e, Single Column (Ascending order) and Multiple Columns (Custom sort). We can sort data with ascending order and descending order both. Let's learn how to sort in excel easily with examples. How to arrange numbers in ascending order in excel.
Single Column Sorting
1. Click on any cell in data you want to sort. Let's we are click on city heading. and go to home tab and click on sort & filter option.
2. We have to click on data heading which you want to sort. Now we have click on City for example
3. Click on Home tab > Editing group > Sort & Filter > Sort A to Z
4. Now we see that our data sort in ascending order excel in the city column and other columns have changed also. On the other hand we can also sort in descending order.
5. If we want to sorting in excel with multiple columns then we can use custom sort. Here we keep in mind that
6. You can sort your data with multiple condition as you want. Let's see, here we are selecting department and city in this dialog box, at first sort in ascending order in department column and after that sort in ascending order in city column.
7. Now our data is ready, we can see this data and we can practice in other many kind of data and learn fast sorting in excel easily.
I hope this is very helpful information to sort data in excel. After see this article your all question is stop and you have get great knowledge about this.
