Basic Excel Sorting and Filtering

Sorting
  • Select the cells containing the information to be sorted. If the whole spreadsheet is to be included press 'Ctrl-A'
  • Choose Sort from the Data menu [Figure 1]. Excel displays the Sort dialog box [Figure 2].
  • Using the controls on the dialog box, indicate the way in which the cells should be sorted.
  • Click on the OK button to perform your sort.
Figure 1 Figure 2
Figure 1
Figure 2

Note: If the sheet is protected then this needs to be turned off. Select TOOLS - PROTECTION - UNPROTECT SHEET.
Figure 3
In the case of the Positive Recall Log the top blank row should also be deleted. Right-click on the "1" and select "delete".