In this tutorial we will learn how to sort data in MS Excel. Microsoft excel provide facility to sort data. So we can sort data in Excel. In sorting we arrange entities according to specific order. By group of sorted entities it is easy to find some entity which belong to that group. Alphabetical and numerical shorting commonly used. We sort things by their some attributes. If want to sort according to name of these entities then alphabetical sorting. If want to sort according to numerical value like price or salary then use numerical sorting. Two orders are available for sorting one is ascending and other is descending. In ascending order we go from smaller to larger and in descending order we go from larger to smaller.
Sort data in excel Example:-
We have weekly salary sheet of employees we want to short the employees according to the name of employees so we use alphabetical sorting. Before shorting the employees are not arranged in order.
For custom sorting we select the option of custom sort. Custom sort is quite flexible from the simple sort.