SORTING

Sorting is arranging of data in ascending or descending order or arranging them systematically.

Let’s get started:

STEP 1: Select the data you want to apply sort on

STEP 2: Go to Data tab->Sort & Filter->Sort

One is the basic sort and other is the advanced sort. Let’s start with basic sort.

This is the symbol for basic sort.

The upper option will sort the data in ascending to descending order in case of numbers and alphabetically (A-Z) in case of string values.

The lower option will sort the data in descending to ascending order in case of numbers and alphabetically (Z-A) in case of string values.

Example:

Suppose you want to sort the data, select the complete data and go to sort and select any of the two options explained above. Selection of complete data is necessary else the data would distort.

• By default, Sorting is done with respect to first column.

 OUTPUT (A-Z)     

OUTPUT(Z-A)

                    

• Advanced Sorting

One can select advanced sort i.e.

Let’s continue with the above example

Select the data, go to advance sort. A window will popup. In this, we have an option for

1. Sort by: In this field we can choose to sort by any column header values. As in the example we have three columns namely Month, Customer and Sales. So, we can sort taking any of them. The whole data will be sorted accordingly and data won’t distort. Here let us say, I sort by Customers.
   
   
2. Then we have option for Sort On. We can sort on cell values, color etcetera. Let us sort on Cell values.

3. Then comes the Order. Either we want in ascending or descending in case of numbers and (A-Z) or (Z-A) in case of strings. Let us sort on (A-Z).

OUTPUT

• Another option we have is of Add level. We can add as many levels we want to sort data on. In first case I have sorted the data on Customer, lets add another level

In which we sort on the basis of Month.