Page 52 - KEC Khaitan C6 Flipbook
P. 52
SORTING DATA IN EXCEL
It is easy to maintain data in Excel as the sheet is divided into rows and columns but the data may
not be arranged in a specific order automatically as we enter it.
For such a purpose, Excel provides us with a feature called sorting. It is present in the Home tab
under Editing group. Sorting means arranging the data either in ascending or descending order.
Data can be sorted in two ways:
Ascending order: Arranging data in increasing order, for example, letters from A to Z, numbers
from lowest to highest, etc.
Descending order: Arranging data in decreasing order, for example, letters from Z to A,
numbers from highest to lowest, etc.
To sort the data, follow the given steps:
2 Click on the Sort & Filter command.
3 Select the Sort
A to Z option to
arrange data
in ascending
order, and
select the Sort
Z to A option
for descending
order.
1 Select a column or range
of the data to be sorted.
CUSTOM SORTING
Even when the data is arranged in ascending or descending order, it can still be sorted again within
another column. For example, if Student’s mark list is sorted with respect to Roll No. column, we
can still sort it in the Name column. You can do this in Excel using Custom Sort. To use Custom
Sorting, follow the steps given below:
50 Premium Edition-VI

