When you are managing a lot of data entries in excel, a time comes when you have to arrange or sort the data in ascending or descending order.

Previously In AnalysisWindings Symbols in Excel

To do the same, this is what we have to do:

scending or descending order

You can observe in the image above, we have taken roll nos. in relation to marks in English.

scending or descending order

Now the first step that we need to follow is to select the data that we want to sort in a particular order.

ascending or descending order

After the same, we need to go to “Sort & Filter” which can be found in the “Editing” options.

ascending or descending order

Then you have to choose from the options for whether you want to sort your values/ data from smallest to largest (ascending) or from largest to smallest (descending).

ascending or descending order

And there you go. Your data is sorted in the format or in the way you wanted to.

ascending or descending order

It’s easy, isn’t it?