Excel sorts data according to specific sort order rules. We can sort the number data as per ascending order and descending order. And sort the text according to alphabets A to Z and Z to A. We can sort by font color and cell color in Microsoft Excel 2010.
This option is available, in the Data Tab under the Sort & Filter group.
We can sort the data as follows:-
Numeric values, including date and time, are sorted from lowest (negative) to highest (positive). Excel does not consider the format of the cell, only its contents.
Date and time are sorted by their numeric values.
Text is sorted as per the letters that come first in the order, and that would show in ascending or descending order.
Empty cells are always sorted last. Sort descending changes the sort order from the last to the first, except of empty cells, which are always sorted last.
Let’s take an example to understand how we can sort the data as per above mentioned methods.
We have data in range A1:B14. Column A contains Agents' names, and column B contains Revenue.
To sort the data as per numbers, follow below given steps:-
To sort the data as per the text, follow below given steps:-
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.