9. Select  Last Name  from the  Then By  dropdown box.  10. The  Sort On  dropdown should remain as  Values . 11. The Order dropdown should be  A-Z .  12. Click  Ok .  The table will now be sorted alphabetically by semester and then by last name. Sorting by Cell Color  To sort a color coded data table: 31 