In this article we will show you exactly how to sort in Google Sheets. We cover how to sort data using the built in sort feature and by using the SORT function. Just follow the simple steps below:
How to Sort in Google Sheets using the Sort Feature
1. Select the range of data to sort
Data tables usually contain a header row. For this example we include them in the range. We will set the first Column with label Name as the reference for sorting the range.
2. Click Data, choose Sort range, then select Advanced range sorting options
When you choose Sort range, you will also get the two options Sort range by column A (A to Z) and Sort range by column A (Z to A). You can select either of them if you don’t include the header row in the range.
However, since we will include the header row in our range, select Advanced range sorting options.
3. Selected Advanced Sorting Options
A box will appear where you can set sorting options. You have several options to tweak the way you sort the selected range.
If the range includes a header, tick the checkbox labeled Data has header row.
There is a header row in our example so we will tick this one. This will also change the list of columns to select as reference for sorting.
Next, you need to select which column to use as reference for sorting. Click the drop-down box and select the column.
Finally we set whether to sort in ascending or descending order.
For our example, we choose A->Z for ascending order. If you want to choose descending order, click Z->A. By default ascending order A->Z is selected.
4. Click Sort
The range is now sorted.
How to Sort Data in Google Sheets using the SORT Function