It is very easy to "Sort" in Microsoft Excel. To dot that-
1. .Select the range of cells or specific column that you want to apply the "sort".
2. In the "Home" tab in the Excel ribbon select "Sort & Filter" group and then click on the "Sort" button. You can go to "Sort" button from the "Data" tab of excel ribbon.
3. The Sort dialog box will have different options :
"Sort by": Choose the column or columns you want to sort by from the drop-down list. If you have selected the entire data range, Excel will automatically detect the headers and display them in the drop-down list.
"Sort smallest to largest": It arranges the cells depending its values from smallest to largest.
"Sort largest to smallest": It arranges the cells depending its values from largest to smallest.
"Custom sort": Here we can arrange our data on the basis of specific column, specific order and and specific values at the same time.
4. Once you have set up the sorting options according to your requirements, click on the "OK" button. Excel will sort the selected range based on the specified criteria.
Comments
Post a Comment