SORTING DATA IN MICROSOFT EXCEL
In case a list of data is typed, one may need the data arranged in a particular fashion. For example, you may want your client details either alphabetically or based on the client codes. This is where sorting is useful and the same is very simple. Choose the relevant command from the Data Menu and the Sort Wizard takes you through the rest of the process. Remember, sorted data is always advantageous from three counts: firstly, it improves readability, secondly, it permits effective lookups and lastly, it lays down the foundation for data grouping and sub-totalling.
- Sorting is a permanent process as compared to filtering which is a temporary process
- Choose any cell in the data range and Select Data -> Sort
- Choose successive sort keys and sort order
On a brief review of the above screen, one understands that the sort function permits sorting only upto three levels of data. If sorting is required for multiple levels of data, then one will have to use the sort function more than once. Sort first based on keys of least significance and move to keys of higher significance
0 comments:
Post a Comment