Sorting data

You can sort data in a range in ascending or descending order.

  1. Select the range of data you want to sort.

  2. In the action bar, click Range.

  3. In the pop-up menu, click Sort.

  4. In the Sort by box, enter the column to sort by.

    For example, if column A is Last Name and you want to sort the data by last name enter column A in the Sort by box.

  5. To set the order for sorting by this column, do one of the following:

  6. (Optional) In the Then by box, enter a second column to sort by and click Ascending or Descending for sorting by this column.

    For example, if you are sorting by Last Name, since several data records could have the same last name, you will probably also want to sort the data then by the First Name column or ID Number column.

  7. Click Sort.



See also
Building your worksheet
Entering a number
Entering text
Entering a date
Entering a time
Editing data