Question

Excel can sort data in more than one fields using the option of the sort dialog box
​

Answer 1

Answer:

Here are the steps to do multi-level sorting using the dialog box:

Select the entire data set that you want to sort.

1.Click the Data tab.

2.Click on the Sort Icon (the one shown below). ...

3.In the Sort Dialogue box, make the following selections. ...

4.Click on Add Level (this will add another level of sorting options).