Sort a List in Excel

When you working with columns of information, it is nice to be able to sort it in ascending or descending order. Sometimes it is necessary to sort 2 or more columns of information.

---

---

How To Sort a List:

1. Select any cell in the column you want to sort.
2. Click the desired Sort button in the Standard toolbar.
   • The button with A to Z will sort in ascending order.
   • The button with Z to A will sort in descending order.
3. Or from the Data menu, choose Sort
   • choose which sort you need
4. Click OK.
5. Verify that Apply to selection is checked.

How to Sort a List based on 2 or more columns:

1. Select any cell in the list.
2. From the Data menu choose Sort to open the Sort dialog box.
3. From the Sort by drop-down list, select the desired column heading.
4. Then select the desired sorting order (all records will be sorted according to these criteria first)
5. From the Then by drop-down list, select the desired column heading.
6. Then select the desired sorting order (these criteria will be applied within each group of records created in the previous step).
7. Click OK.