Spreadsheets : Sorting

A spreadsheet's sort function will let you put the data in a table into order using any of the columns of data in the table. To sort data in a spreadsheet you will need to :

• Select the area of the spreadsheet that contains the data to be sorted.
• Choose which piece of information in the table you want to use to order the data.
• Select whether you want to put the data in ascending (going up) or descending (going down) order.

The data in this table has been sorted :

To perform the sort the table range (A2:C4) was selected. The table was then sorted using the data in column A into ascending order. Note that row 1 was not included in the sort range because it contains the titles for the table rather than data.

GCSE ICT Companion 04 - (C) P Meakin 2004