2. Highlight the information you need to sort.

3. Click on the Sort & Filter button found on the Home Ribbon.
4. Select Custom Sorting

5. The Sort pop-up box will appear.

6. If you need to sort by more than one criterion, click on Add a Level and repeat above instructions.
7. Click on OK.
Additional sorting options include: Sort On which includes Cell color, Font color and Icon; Order which includes: A To Z; Z to A; and Custom List.
I have always found this to be a very valuable feature on Excel!
ReplyDeletePatty