Sorting & Filtering

Freezing the Header Row

The first thing we want to do is freeze the first row in the table, which has our column headers. This way when we start sorting specific columns, the column labels will not be affected.

Click View on the top-level menu, and select Freeze. Click 1 row to freeze the first row in the table.

Sorting

Then, we can select a single column to sort by character or number values.

Right click on a column label and select one of the Sort sheet options.

Or, click Data -> Sort sheet -> Sort range to sort by a particular column or selection. We can also sort by multiple columns.

Click Data -> Sort range -> Advanced range sorting options to access these options.

In the pop-up window, you can check the Data has header row box and then choose to sort by multiple columns. Click Sort to apply these settings.

Filters

We can also add filters to only see specific rows or values.

Click Create a filter under Data.

Now we can set up filters for individual columns in the table.

Click on the three horizontal lines next to a column label to open the filter menu.

One option is to filter by condition.

Another option is to filter by values, which allows you to search for particular characters or select specific values. Click OK to apply the filter.

Google Sheets allows you to save particular filter settings/configurating as a Filter view.

• Data -> Filter views -> Save as filter view

You can also remove any filters from the Google Sheets project.

• Data -> Remove filter