How to Create a Filter in Google Sheets

The filter in a data range is very useful. Not only you can sort the dataset, but you can also filter the data based on certain criteria. Please see below how to create a filter:

Step 1: Click anywhere in the data range;

Step 2: Click the "Create a filter" button;

Step 3: The first row of the data range will become the filter.

Alternatively, you can always use the commands from the ribbon.

Step 1: Click anywhere in the data range;

Step 2: Click the "Data" tab from the ribbon;

Step 3: Click "Create a filter" from the drop-down list;

Step 4: The first row of the data will become the filter.

Leave a Reply