Sort a spreadsheet

You can sort a range of cells according to rules set for one or more columns. To sort your data, follow these steps:

  1. Highlight the group of cells you'd like to sort. To sort the entire sheet, click the top left corner of the sheet to select all cells.
  2. From the Data menu, select Sort range...
  3. Check Data has header row if your columns have titles.
  4. Select the column you'd like to be sorted first and whether you would like that column sorted in ascending or descending order.
    • Click +Add another if you'd like another sorting rule added. Sorting will be prioritized according to the order of your rules.
    • Click the X to the left of your rule to eliminate it.
  5. Click Sort and your range will be sorted.