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

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

Google Sheets · Verified tutorial

Share a filter view in Google Sheets

Select A1:C5 and create a filter view named Shared open items. Leave the saved filter view open so its shareable URL remains active. Do not change, sort, or delete any values.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Select A1:C5 and create a filter view named Shared open items. Leave the saved filter view open so its shareable URL remains active. Do not change, sort, or delete any values.

Step-by-step

1

Select the targetSelect A1:C5 and create a filter view named Shared open items.

2

Apply the changeLeave the saved filter view open so its shareable URL remains active.

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 named Shared open items 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 named Shared open items 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 and create a filter view named Shared open items.
Apply the change. Leave the saved filter view open so its shareable URL remains active.
A saved filter view named Shared open items covers A1:C5.