Filtering with filter views in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a Filter View in Google Sheets?

A Filter View lets you create a temporary filter on your data without changing what others see. It helps you sort or filter data privately.

beginner

How do you create a Filter View in Google Sheets?

Go to the Data menu, then select 'Filter views' > 'Create new filter view'. This opens a special view where you can filter or sort data without affecting others.

beginner

Can multiple people use Filter Views at the same time without interfering with each other?

Yes! Each person can create and use their own Filter View. This means everyone can filter or sort data their way without changing the main sheet for others.

beginner

What happens to the original data when you apply a Filter View?

The original data stays the same. Filter Views only change what you see on your screen. They do not delete or move any data.

beginner

How do you exit a Filter View in Google Sheets?

Click the 'X' button at the top right of the Filter View bar or go to Data > Filter views and select 'None' to return to the normal view.

What is the main benefit of using Filter Views in Google Sheets?

A It permanently deletes filtered rows

B It only works offline

C It changes the original data for everyone

D You can filter data without affecting others' views

Filter Views let you filter or sort data privately without changing the sheet for others.

Where do you find the option to create a Filter View?

A Data menu

B Insert menu

C Format menu

D Tools menu

Filter Views are found under the Data menu in Google Sheets.

Can multiple users use different Filter Views at the same time?

A No, only one Filter View at a time

B Only if they are offline

C Yes, each user can have their own Filter View

D Only if they share the same Google account

Filter Views allow multiple users to filter data independently without interfering.

What happens to the data when you apply a Filter View?

A Data is hidden only for you

B Data is copied to a new sheet

C Data is permanently changed

D Data is deleted

Filter Views hide or sort data only on your screen without changing the original data.

How do you close a Filter View?

A Reload the page

B Click the 'X' on the Filter View bar

C Delete the sheet

D Sign out of Google Sheets

You close a Filter View by clicking the 'X' button on its bar or selecting 'None' under Filter Views.

Explain how Filter Views help when multiple people work on the same Google Sheet.

Think about how you can look at data your way without changing what others see.

Describe the steps to create and exit a Filter View in Google Sheets.

Remember the menu path and how to close the view.