How to order data in Excel

To sort a range:

  • Select the cell range you wish to sort.
  • Select the Data tab on the Ribbon, then click the Sort command.
  • The Sort dialog box will appear.
  • Decide the sorting order (either ascending or descending)
  • Once you're satisfied with your selection, click OK.
  • The cell range will be sorted by the selected column.