NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping →

Google Sheets tutorials›Sort and filter›Create a filter view

Google Sheets · Verified tutorial

Create a filter view in Google Sheets

Select A1:C5, then use Data > Create filter view. Name it Tutorial view and close the filter view so it is saved. Do not change any values.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Select A1:C5, then use Data > Create filter view. Name it Tutorial view and close the filter view so it is saved. Do not change any values.

Step-by-step

1

Select the targetSelect A1:C5.

2

Complete the next actionuse Data > Create filter view.

3

Apply the changeName it Tutorial view and close the filter view so it is saved.

Shortcut or faster method

Use the menu path shown in the video and keep the target range selected until the change is applied.

Expected result

A saved filter view covers A1:C5.

Common mistake

Changing the source values while applying the formatting or structure change.

Troubleshooting

Re-select A1:C5 and repeat the final action. A saved filter view covers A1:C5.

Example spreadsheet data

This is the clean fixture used for the verified run.

Task	Owner	Status
Prepare brief	Anna	Open
Review draft	Ben	Closed
Publish update	Cara	Open
Archive assets	Dev	Closed

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Select A1:C5.
Complete the next action. use Data > Create filter view.
Apply the change. Name it Tutorial view and close the filter view so it is saved.
A saved filter view covers A1:C5.