Page 39 - 2619_PlusGPT V2.1_C-8

The filtered data will be displayed as given:

You will notice that the rows of unchecked data are removed from the list. You need not worry, as the

data is not lost. The unchecked rows have just been hidden from the display. To get the data back,
open the filter list again and check the unchecked entries.

Adjusting Filter

Adjusting a filter in Google Sheets allows you to change the criteria used to display specific data from
a filtered range. This helps you narrow down or expand the dataset you’re working with based on
specific conditions or values.

Suppose, you want to display the data of only those students who have scored more than 80 marks.
Perform the following steps:
Step 1: Click on the filter icon.

Step 2: Change the value to 80.
Step 3: Click on OK button.

The data of students who have scored more than 80 marks is given.

Google Sheets (Advanced- Sorting, Filtering & Charts) 37