Microsoft Office Tutorials and References
In Depth Information
25. Click cell C3 . Then on the Home tab, in the Editing group, click Sort & Filter ,
and click Custom Sort.
The Sort dialog box opens.
26. In the Sort by row, in the Column list, click Revenue .
27. In the Sort on list, click Cell Color .
28. In the new list control that appears in the Sort by row, click On Bottom to have
Excel put the Revenue cells that have no cell color on the bottom.
29. Click OK .
Excel sorts the data list.
CLEAN UP Save the ShippingSummary workbook, and then close it.