Tip Sheet

Microsoft Excel 2007 - Sorting data

 

A selected range of data can be sorted in alphabetical order, reverse alphabetical order, ascending numerical order (smallest to largest) or descending numerical order (largest to smallest). First select the range of data you want to sort, remembering to select the entire row so that sections of data belonging to the same record of information do not become detached from each other.

Having selected the data range:
Click on the Data tab  
Click on Sort  

A pop-up screen gives you the choice of indicating which column you want to sort. In this example, we want to sort the names, so we choose Column A or Name. Also choose whether you want to sort ascending (same as alphabetical) or descending.

Then click on OK

 

 

 
 
Copyright Microsoft, SchoolNet SA
All Rights Reserved.