Select the entire data set that you want to sort. Click the Data tab.
Click on the Sort Icon (the one shown below). This will open the Sort dialog box
In the Sort Dialogue box, make the following selections
Sort by (Column): Region (this is the first level of sorting)
Sort On: Values
Order: A to Z
If your data has headers, ensure that ‘My data has headers’ option is checked

0 Comments