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.
Although 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..