Sorting a list in ascending alphabetical order.

• Open a workbook called Sorting Data.  The worksheet contains the following data.
  
  
  

• Look at the data within the worksheet.  As you can see some of the columns contain numeric data (i.e. numbers), while other columns contain alphabetic data (i.e. text).  The data on the first page of the workbook is not sorted.
  
  
  

• Click on the Sales person ascending tab at the bottom of the screen to display a copy of the original data.
  
  
  

• We want to list the sales people in ascending alphabetical order.  First click within the column of data relating to Sales Persons.  Then click on the Sort Ascending button, displayed within the Excel toolbar
  
  
  

• The data will now be displayed as illustrated below.