Tutorial 12: Sorting data in columns

Excel Tutorial 12: Sorting Data in an Excel WorksheetSorting is an essential skill for working with databases and lists of information constructed

The illustration in Table 1 below shows some data that has been sorted according to "Account" number. The sort by Account number is in ascending order (i.e. smallest at the start and biggest number at the bottom.

illustration of sorting data in ExcelAlthough this data is sorted by Account number, it could just as easily be sorted by "Area" or "Balance" or "Age".

It is ncessary to be very careful when sorting data, as if you sort incorrectly you will, in fact, jumble all the data!

MS Excel gives you a warning if this is likely. Therefore do not rush if you get a warning on screen.

You should always remember the Undo command if you make an error.

Detailed instructions on how to perform a sort are provided in the Video Tutorial above.

A practise worksheet on how to carry out a sorting of data can be downloaded by clicking on the " Get Activity for MS Excel" button below..

Get Excel Activity 14




Event Operations Manual
Software for Club Treasurers