Microsoft Office Tutorials and References
In Depth Information
The selected cell range’s reference appears in the Import List From Cells field. To record
your list, click the Import button.
If you prefer, you can type the list in the List Entries box, to the right of the Custom
Tip Another benefit of creating a custom list is that dragging the ill handle of a list cell that
contains a value causes Excel to extend the series for you. For example, if you create the list
Spring, Summer, Fall, Winter , then type Summer in a cell and drag the cell’s ill handle, Excel
extends the series as Fall, Winter, Spring, Summer, Fall , and so on.
To use a custom list as a sorting criterion, display the Sort dialog box, click the rule’s
Order arrow, click Custom List, and select your list from the dialog box that opens.
Tip In Excel 2003 and earlier, your custom list had to be the primary sorting criterion. In Excel
2010 and Excel 2007, you can use your custom list as any criterion.
In this exercise, you’ll sort worksheet data, sort by multiple criteria, change the order in
which sorting criteria are applied, sort data by using a custom list, and sort data by color.
SET UP You need the ShippingSummary_start workbook located in your
Chapter06 practice file folder to complete this exercise. Start Excel, open
the ShippingSummary_start workbook, and save it as ShippingSummary .
Then follow the steps.
1. Click cell C3 .
2. On the Home tab, in the Editing group, click the Sort & Filter button and
then, in the list, click Sort A to Z .
Excel sorts the data by season, with the seasons listed in alphabetical order.
3. In the Sort & Filter list, click Custom Sort .
The Sort dialog box opens and displays the parameters of the sort you just
4. If it’s not already selected, select the My data has headers check box.
5. In the Column list, click Customer . If necessary, in the Sort On list, click Values ;
then in the Order list, click A to Z .
6. Click Add Level .
A new Then By sorting level appears.