December 4, 2020

How to Sort in Excel

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.

  1. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *