Sorting data is useful to visualize and organize data clearly.
In excel, we can do sorting for following types:
- Sort data in alphabetical order in Column
- Sort Date or Time
- Sort data in rows
- Sort with cell color or font color
- Sort by more than one column or row
Sort Text in Alphabetical Order in Column
We have data with Name, expenses for month Jan-Apr and birthdate
To sort data with Name, select any cell in A column and Go to Home-> In editing group, Select Sort & Filter and click on Sort A to Z
To sort in reverse order, select option, Sort Z to A.
Result: Data is sorted in Alphabetical order.
Select data which you want to sort in rows.
For Example, we have data in row with expense of Jan month.
To arrange data from lowest to highest values, select data range. Do not select row headings.
Go to Home-> In Editing group, under Sort & Filter, select Custom sort.
In Sort dialog box click on Options and select option "Sort left to right". Click OK.
Select row in which you want to sort your data.
In above example select any cell with in Date column and repeat the same procedure.
Go to Home->Editing group, Select Sort and Filter->Sort A to Z (To reverse order select Sort Z to A)
Result: Data is sorted date wise.
You can sort values using same method.
If you have data with conditional formatting or in which different color have been used to distinguish data, you can sort data with specified font color or fill color.
1. To do this, select any cell from the data range.
Go to Home->Sort & Filter -> Custom Sort
2. In dialog box, Under Sort by box, select column you want to sort.
Under Sort on, select the type of Sort, specify color in order box.
To specify the next cell color, Add Level and select the cell color.
Result: Colour data is sorted and appear at the top of data.
We can sort data multiple levels in columns and row. That means that we can again apply Sort in already sorted list.
To do this, select a cell in data range and go to Home->Sort & Filter -> Custom Sort
2,001 total views, 1 views today