We often need to sort the records in excel .Excel provides you a feature to sort records either in ascending or descending order. Below are the steps to perform the sorting.
- Select a cell in the column. For example we want to sort the samples based on their scores in the example below. We select the column ‘Score’.
2. Go to ‘Sort & Filter’ option as shown in the picture.
3. To sort records in ascending order click on the option ‘Sort A toZ’ or else click on option ‘Sort Z to A’ to sort in descending order.
4. We click on the option ‘Sort A toZ’. Samples are sorted in ascending order as shown below.