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.
Select cells G4:G7 , click the File tab, and then click Options to open the Excel
Options dialog box.
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.
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.
Click OK twice to close the Custom Lists dialog box and the Excel Options dialog
Click cell C3 .