PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
Contents
HOW TO SORT DATA IN EXCEL?
INTRODUCTION
Sorting is putting up a number of things in a particular fashion as per the selected criteria. Sorting in Excel is one of the very basic and frequently used operation.
For example, suppose there are five kids of different ages and different heights. Now, if we ask them to line up according to their ages, the youngest will be at the first place and the oldest at the last. (If its increasing order and opposite if its decreasing order). But if we want them to be according to height, the order maybe different from the previous case.
Sorting in Excel is one of the most important and frequently used function. We may need to sort the report as per requirement to search the particular data or see the trend. So lets start with simple sorting.
BUTTON LOCATION TO SORT DATA IN EXCEL
SIMPLE SORTING IN EXCEL
Data Sample: We have a range of different digits put in a line. Target is to put all the numerals in increasing order.
STEPS TO DO SIMPLE SORTING IN EXCEL
STEPS:
- Select the data sample. (Select the cells you want to sort).
- Click on SORT BUTTON .
A dialog box will open.
The column is G. Sorting can be done on many options like values, cell color, font color etc. ( Examples will be discussed in same post). Order can be ascending, descending or custom. We chose the SORTON values and ORDER IS SMALLEST TO LARGEST. Click ok
MULTILEVEL SORTING IN EXCEL
The above example is for a very simple case. In practical world, we’ll always have many columns on which we’ll be needing to be sorted. Excel gives us the option of giving many sorting operation simultaneously.
Lets try with an example.
DATA SAMPLE:
DATA consists of different students of different class and marks are shown.
OBJECTIVE: To sort the students class wise and marks wise.
STEPS TO do MULTILEVEL SORTING IN EXCEL
- Select all the data which you want to incorporate in sorting.
- click sort button.
- Choose the first parameter i.e. Class to sort on values and order ascending (smallest to largest)
- Now click on ADD LEVEL. A similar set of fields as already present will appear under the previous field.
- Choose next field i.e. Marks column to sort on values and order-smallest to largest.
- Click OK.
- We get the result.
OTHER WAYS TO REACH THIS ARTICLE
SORTING IN EXCEL, PUT NUMBERS IN INCREASING OR DECREASING ORDER IN EXCEL, NAMES IN ORDER
YOU MAY LIKE
- HOW TO USE PIVOT CHARTS IN EXCEL?
- FUNCTIONS-ACCRINTM
- function-and
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.