Page 23 - Plus V4 with Adobe class 7
P. 23
To use Custom Sorting, follow these steps:
2
Click on the Sort & Filter command.
Select the range
1 of columns to
be sorted.
3 Click on the Custom
Sort option.
Check My data has
headers checkbox, if the
8 Click on the Add Level 4 selected columns have a
button. heading at the top.
Click on the Order box
and select the A to Z 7
or Z to A option.
Click on the Sort by
5 box and select the
column header.
Click on the Sort On box and 6
select Cell Values option.
Hintbot
To sort data: click
9
Click on the OK button. Data Sort
Experiential Learning
#Sorting
Do a poll/survey of students of your class on festivals of India. Visit https://utsav.gov.in/ and find the
relevant information about each festival. Create an Excel sheet of the festival each student likes
and sort the data according to the name of the student alphabetically.
#Activity
#Advanced Features of Excel 21

