How to Sort in Google Sheets

When you sort the data in your sheets, it's easier to quickly find what you're looking for.

Sort by One Column

Let's first check out how to sort by a single column.

  1. Select a cell in the column you want to sort.
  2. Select Data on the menu bar.
  3. Select a sort order.
    • Sort A to Z: Sorts the column in ascending order.
    • Sort Z to A: Sorts the column in descending order.
    Sort data

The column's data is sorted.

Sort by Multiple Columns

You can also sort data within multiple columns.

  1. Select the cell range you want to sort.
  2. Select Data on the menu bar.
  3. Select Sort range.
    Sort data

    4. The Sort range dialog box opens. Here, we have to specify which column we want to sort the range by.

  4. (Optional) Check the Data has header row check box.
  5. Select the first column you want to sort by and select a sort order.
  6. Click Add another sort column to sort by additional columns.
    Sort data
  7. Click Sort.
    Sort data

The data is sorted within the selected columns.

Google Sheets Quick Reference

FREE Quick Reference

Click to Download

Free to distribute with our compliments; we hope you will consider our paid training.