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.
   

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.
   

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.
   
7. Click Sort.
   

The data is sorted within the selected columns.