Sorting Data

The Excel sort function is useful for rearranging data. When working in Excel sorting data can quickly reorganize content too.

Challenge!

  1. Open an existing Excel workbook. If you want, you can use our practice workbook.
  2. Sort a worksheet in ascending sort ascending or descending sort descending order. If you are using the example, sort by Homeroom # (column A).
  3. Sort a cell range. If you are using the example, sort the cell range in the cell range G3:H7 from highest to lowest by Orders (column H).
  4. Add a level to the sort, and sort it by cell color, font color, or cell icon. If you are using the example, add a second level to sort by cell color in column E.
  5. Add another level, and sort it using a custom list. If you are using the example, create a custom list to sort by T-Shirt Size (column D) in the order of Small, Medium, Large, and X-Large.
  6. Change the sorting priority. If you are using the example, reorder the list to sort by T-Shirt Size (column D), Homeroom # (column A), and Last Name (column C).