202R2 Sorting Data (Excel)

1. Select any cell in the column you want to sort
   eg Last Name
2. Using the Data tab click the A-Z command to sort A to Z etc
3. The entire worksheet will be sorted by the selected column
   eg the worksheet is now sorted by last name.

1. A range is a selected area (ie limited) of data to sort
   It needs to include a header
2. With the chosen area selected (ie your table)
   Using the Data tab, select Sort
3. In the Sort dialog box, choose,
   1. the column (by header) you want to sort
   2. Sort On values (numbers) or text
   3. Order (by) – changes depending on whether its numbers or text

1. Select a cell in the column you want to sort (eg T-Shirt Size)
2. Using the Data tab, select Sort
   1. Column – (should be T-Shirt Size)
3. Choose Order > Custom list
4. Select New List
5. Write a list
   1. the actual cell values (options) in the column
   2. in the order you want to be sorted
6. Add the list
7. Select your new list
8. Back in the Sort dialogue, your list will be in the Order option
9. OK to Sort

The video covers both simple and advanced sorting techniques (the simple methods covered in the first 2 minutes)

• 4.30 minutes
• Types of sorting
• Sorting sheets and ranges – !
• Creating a custom sort
• Adding levels

• link to sort walk through
• sort spreadsheet in video (backup)
• Look at another guide

1. Click the Challenge tab in the bottom-left of the workbook.
2. For the main table, create a custom sort that sorts by Grade from Smallest to Largest and then by Camper Name from A to Z.
3. Create a sort for the Additional Information section. Sort by Counselor (Column H) from A to Z.