Microsoft Office Tutorials and References
In Depth Information
Sorting data by using custom lists
On the Home tab, in the Editing group, click Sort & Filter , and then click Custom
Sort to open the Sort dialog box.
Click the rule in the Sort by row, and then click Delete Level to remove the sorting
If necessary, in the new Sort by row, in the Column list, click Season .
In the same row, in the Order list, click Custom List to open the Custom Lists dialog
In the Custom lists box, click Spring, Summer, Fall, Winter .
Click OK twice to close the Custom Lists dialog box and the Sort dialog box so that
Excel sorts the data list.
CLEAN UP Close the ShippingCustom workbook, saving your changes if you want to.