In this tutorial, you will learn how to sort and filter in Google Sheets.
How To Sort And Filter In Google Sheets
Quick Navigation
Sorting and filtering your data is an essential part of data analysis. It can help you quickly visualize your data and identify patterns or trends.
Google Sheets provides a few easy-to-use features that allow you to quickly sort and filter your datasets.
In this guide, we will give you a step-by-step explanation of how to use the sorting and filtering features in Google Sheets. We will cover how to sort data in ascending or descending order and how to use filters to show only specific types of data.
How To Add a Filter and Sort Data in Google Sheets.
Here’s how to add a filter and sort data in Google Sheets.
Step 1
First, select the cell range you want to sort and filter.
In this example, we will be filtering and sorting a tracker of T-shirt orders. We want to filter the range to only see shirts smaller than ‘L’, namely M, S, and XS. We also want to sort the range in ascending order according to quantity.
Step 2
We can add a filter to the selected range by clicking on the option in Data > Create a filter.
Step 3
Each column header should now have its own filter icon. Click on the filter icon to reveal more sorting and filtering options.
In this example, we will start by sorting the filtered range by quantity.
Step 4
Users have the ability to sort in ascending or descending order.
In this example, we’ve chosen the option Sort A to Z to arrange our rows from lowest quantity to highest quantity.
Step 5
Next, we can choose another field to start filtering values. The values can be checked and unchecked from the expanded menu. Unchecked values will be filtered out from the range.
In this example, we’ll use the Clear option to uncheck all options first. Next, we’ll manually choose which values we want to show in the sheet. In this example, we’ve selected XS, S, and M.
Click on OK to apply the filter options.
Summary
This guide should be everything you need to sort and filter in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.