Microsoft Office Tutorials and References
In Depth Information
Sorting data by using custom lists
In this exercise, you’ll sort data by using a custom list.
SET UP You need the ShippingCustom workbook located in the Chapter06 practice
file folder to complete this exercise. Open the workbook, and then follow the steps.
1
Select cells G4:G7 , click the File tab, and then click Options to open the Excel
Options dialog box.
2
On the Advanced page, in the General group toward the bottom of the page, click
Edit Custom Lists to open the Custom Lists dialog box.
3
Verify that the cell range $G$4:$G$7 appears in the Import list from cells field, and
then click Import to add the new list to the Custom Lists box.
6
4
Click OK twice to close the Custom Lists dialog box and the Excel Options dialog
box.
5
Click cell C3 .
 
Search JabSto ::




Custom Search