Google Sheets Course: Sorting data

Simple Sorting

The Sort function allows you to sort your data in ascending or descending alphabetical order.

The test data: lesson-10.xlsx


To quickly sort data based on the first column, select the data range (from column A) and then click on "Sort range" > "Sort range by column A" in the Data menu:

google sheets sort data png

The data is then sorted by row based on column A:

google sheets sort datas png

Custom Sorting

To apply a sort based on multiple columns, select the range of cells to sort (you can select entire columns this time) and then click on "Sort range" > "Advanced range sorting options" in the Data menu:

google sheets sort range data png

Start by checking "Data has header row" to avoid sorting the headers and display the headers in the dropdown list below:

google sheets sort range data settings

The goal here is to sort by name, then (in case of identical names) sort by first name, and finally sort by company (if there were to be identical names and first names):

google sheets sort range data criteria

The data is then sorted according to the defined sorting criteria:

google sheets sort png