Filtering with filter views in Google Sheets - Step-by-Step Guide

Introduction

Filter views let you create temporary filters on your data without changing what others see. This helps you explore or analyze data your way without affecting the original sheet for everyone else.

When you want to sort or filter data but keep the original sheet unchanged for your team.

When you need to save a specific filter setup to use again later.

When multiple people are working on the same sheet and want to filter data independently.

When you want to share a filtered view with someone without changing the main data.

When you want to compare different filtered results side by side.

Steps

Step 1: Click

- Data menu

A dropdown menu appears showing data options including 'Filter views'

💡 Look for 'Filter views' near the bottom of the Data menu

Step 2: Select

- Data > Filter views > Create new filter view

A black border appears around your data range and filter icons show in the header row

💡 The black border means you are in a filter view mode

Step 3: Click

- Filter icon in any column header

A filter menu opens allowing you to choose which rows to show or hide

💡 Use checkboxes to select or deselect values to filter

Step 4: Choose

- Filter menu options

The sheet updates to show only rows matching your filter choices inside the filter view

💡 You can apply filters on multiple columns to narrow down data

Step 5: Click

- Close button (X) on the top right of the black border

Filter view closes and the sheet returns to the original unfiltered state

💡 Your filter view is saved and can be reopened anytime

Step 6: Open

- Data > Filter views

A list of saved filter views appears for you to select and apply

💡 Rename filter views for easy identification by clicking the name in the black border

Before vs After

Before

Sheet shows all 100 rows of sales data with no filters applied

After

Sheet shows only 20 rows where the Region column is filtered to 'West' inside a filter view, original sheet remains unchanged for others

Settings Reference

Filter view name

📍 Top left corner inside the black border of the filter view

Helps you identify and manage multiple saved filter views

Default: Filter view 1, Filter view 2, etc.

Filter criteria

📍 Filter icon dropdown in column headers within filter view

Controls which rows are visible based on your chosen conditions

Default: No filter applied

Filter view visibility

📍 Data > Filter views menu

Switches between filtered and original data views without changing the sheet for others

Default: No filter view open

Common Mistakes

Applying filters directly without using filter views

This changes the sheet for everyone, which can confuse collaborators

Use filter views to filter data privately without affecting others

Not closing the filter view after finishing

You might think the filter is off, but the view is still active and filtering data

Always click the close (X) button on the filter view border to exit filter view mode

Forgetting to name filter views

Makes it hard to find or reuse specific filter setups later

Rename filter views with descriptive names to organize them

Summary

Filter views let you filter and sort data without changing the original sheet for others.

You can save multiple filter views and switch between them anytime.

Always close filter views when done to return to the full unfiltered data.

Practice

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

easy

A. They allow you to filter data without changing the original sheet for others.

B. They permanently delete rows that don't match the filter.

C. They automatically create charts from filtered data.

D. They convert filtered data into a new sheet.

Solution

1. Step 1: Understand what Filter Views do

   Filter Views let you filter and sort data without affecting what others see in the main sheet.

2. Step 2: Compare options to this feature

   Options A, B, and C describe actions that Filter Views do not perform, such as deleting rows or creating charts.

3. Final Answer:

   They allow you to filter data without changing the original sheet for others. -> Option A

4. Quick Check:

   Filter Views = Personal filtering without changing main sheet [OK]

Hint: Filter Views keep your filter private without changing the sheet [OK]

Common Mistakes:

• Thinking Filter Views delete data
• Assuming Filter Views create new sheets
• Believing Filter Views change data for everyone

2. Which menu path do you use to create a new Filter View in Google Sheets?

easy

A. Insert > Filter View

B. Data > Filter Views > Create new filter view

C. Format > Filter Views > New

D. Tools > Filter Views > Add

Solution

1. Step 1: Recall the menu location for Filter Views

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

2. Step 2: Identify the correct submenu

   The correct path is Data > Filter Views > Create new filter view.

3. Final Answer:

   Data > Filter Views > Create new filter view -> Option B

4. Quick Check:

   Data menu contains Filter Views creation [OK]

Hint: Filter Views are under Data menu, not Insert or Format [OK]

Common Mistakes:

• Looking under Insert or Format menus
• Trying to create Filter Views from Tools menu
• Confusing Filter Views with normal Filters

3. You create a Filter View to show only rows where the "Status" column equals "Complete". What happens to the original sheet for other users?

medium

A. They see the full original data without any filtering.

B. They see only the filtered rows with "Complete" status.

C. The sheet automatically deletes rows not marked "Complete".

D. The sheet creates a new tab with filtered data.

Solution

1. Step 1: Understand Filter View effect on others

   Filter Views only change your personal view; they do not affect what others see.

2. Step 2: Analyze options based on this behavior

   The option "They see the full original data without any filtering." correctly states what others see.

3. Final Answer:

   They see the full original data without any filtering. -> Option A

4. Quick Check:

   Filter Views = Personal filter, others see original [OK]

Hint: Filter Views don't change data for others, only your view [OK]

Common Mistakes:

• Assuming Filter Views filter data for everyone
• Thinking rows get deleted automatically
• Believing a new tab is created

4. You tried to create a Filter View but it doesn't show any filtered rows even though some rows match your criteria. What is the most likely mistake?

medium

A. You used the normal Filter instead of Filter View.

B. You deleted the original data before filtering.

C. You applied the filter to the wrong column or range.

D. You saved the Filter View but didn't refresh the sheet.

Solution

1. Step 1: Identify why no rows show in Filter View

   If no rows appear, often the filter criteria is applied to the wrong column or range.

2. Step 2: Evaluate other options

   Deleting data would cause no data at all, normal Filter affects all users, and refreshing is not required for Filter Views.

3. Final Answer:

   You applied the filter to the wrong column or range. -> Option C

4. Quick Check:

   Wrong filter range = no matching rows shown [OK]

Hint: Check your filter range matches the data columns [OK]

Common Mistakes:

• Confusing Filter View with normal Filter
• Not checking the filter range
• Assuming refresh fixes Filter View issues

5. You have a large sheet with sales data. You want to share a filtered view showing only sales from "Region A" and sorted by "Date" without affecting others' views. How do you do this using Filter Views?

hard

A. Use conditional formatting to highlight "Region A" sales and sort manually.

B. Apply a normal filter to the sheet for "Region A" and sort by "Date".

C. Copy the data to a new sheet and filter and sort there.

D. Create a Filter View, set filter to "Region A" in the region column, then sort by "Date" within that Filter View.

Solution

1. Step 1: Use Filter View to avoid changing others' views

   Filter Views let you filter and sort data privately without affecting others.

2. Step 2: Set filter and sort inside the Filter View

   Create a Filter View, filter the "Region" column to "Region A", then sort by "Date" within that view.

3. Final Answer:

   Create a Filter View, set filter to "Region A" in the region column, then sort by "Date" within that Filter View. -> Option D

4. Quick Check:

   Filter View + filter + sort = private customized view [OK]

Hint: Filter Views let you filter and sort privately without changing sheet [OK]

Common Mistakes:

• Using normal filter which affects all users
• Copying data instead of using Filter Views
• Using conditional formatting instead of filtering