This is not a course. It is a... Tip Sheet

COMPUTER SKILLS AND TIP SHEETS
MS Excel 2002 - 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 Data| Sort   or click on the sort icon

 

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

Then click on OK

                                           The Educators' Network



Copyright SchoolNet SA and SCOPE. All Rights Reserved.