Sorting Data

Use sorting to organize and analyze your data with ease. Prioritized sorting allows you to drill down to the nitty-gritty without mixing your data around.

Sorting a Data range

1. Open a workbook and select the data range you'd like to sort

2. Go to the Edit menu and select Sort Range...

3. Select a column from your range that you’d like to start sorting by

  • You can choose to sort in Ascending or Descending order.
  • If your range includes a header row, mark the checkbox to keep it from being sorted

4. If you'd like to sort by more columns in your data range, select the Add column to sort by button

  • Columns will be sorted in the order that they appear in the Sort Range list.
  • You can delete a Sort by column to remove it from the list or to rearrange the priority.

5. Be sure to save your sorting details by clicking the Sort button

Make sure to select all related data for your data range. Otherwise you risk sorting a single column while leaving the rest of its related data unattached and jumbled!

If this happens, don’t sweat it. Undo (ctrl+Z) is there to save us all from ourselves.