Create a Filter View in Google Sheets: Steps & Tips

To create a filter view in Google Sheets, open the spreadsheet in a desktop web browser, select a cell in your data, then choose Data > Create a filter view. Set filters or sorting from the column headers, give the view a name, and close it when you are done; the view is saved so you can reopen it later.

What a filter view does

A filter view is a saved way to show only some rows or arrange them in a particular order without forcing every collaborator to use the same display. For example, a team can keep one shared project list while one person views only tasks assigned to them and another checks overdue work. The underlying records remain in the sheet; a filter view changes what is displayed, not which rows are stored.

Each view can have its own filters, sorting, and name. You might create views called Open requests, April orders, or My region. Switching between them is quicker and less error-prone than repeatedly changing filters on the shared sheet. A filter view is especially useful when people need different slices of one table at the same time.

It is not a separate copy of the spreadsheet or a private data-security boundary. People with access to the spreadsheet may still be able to see data outside a filtered view by changing or closing the view, depending on their access. Use sharing permissions—not filters—to control who can access sensitive information.

Prepare the data before creating a view

Filter views work best with a consistent table: one header row, one record per row, and a separate column for each kind of information. A task list might have columns for Task, Owner, Status, Due date, and Priority. If the same column mixes dates and text, or the table has blank rows in the middle, filtering and sorting can be confusing.

Give every column a clear header. These labels appear in the filter controls and make views easier to understand.
Remove completely blank rows and columns inside the dataset where practical. They can cause Sheets to detect only part of the table.
Avoid merged cells within the records. Merged cells do not behave like ordinary row-by-row values during sorting and filtering.
Check that each record occupies one row and that related data stays together across columns.

You can select the complete range, including the headers, before creating the view. If the active cell is inside a well-formed table, Sheets often detects the data range, but check the outlined range before relying on that. A view that covers only part of a table can leave related rows or columns outside its controls.

Create a filter view step by step

Open the spreadsheet in Google Sheets in a web browser. Filter views are designed for the desktop interface; if you are on a phone or tablet, use a computer browser for the full creation and management controls.
Click a cell in the data range, or select the range you want the view to cover. Include the header row.
Choose Data > Create a filter view. Sheets opens the range in a filter-view state, with a dark bar across the top and filter controls in the column headers.
Click the name field in the dark bar and enter a useful label, such as Unassigned tasks or West region. A descriptive name helps distinguish it from other views.
Use a column’s filter control to choose values to display or set a condition. Repeat for other columns if the view needs multiple criteria.
To change the order of records, open a column’s control and choose an ascending or descending sort option.
Close the filter view with the close control at the right side of the dark bar. Your saved view can then be selected again from the filter-view menu.

For a concrete example, imagine a sales sheet with Region, Rep, Order date, and Amount columns. A view named North orders could filter Region to North and sort Order date from newest to oldest. The same sheet can have another saved view for one representative’s open orders without making the first view unusable.

Filter rows and sort records

The column controls let you narrow records in two main ways. Filtering by values displays a checklist of values found in that column; choose the entries you want to keep visible. This is convenient for fields such as status, region, or owner. If the list is long, use its search field to find a value rather than scrolling through every option.

Filtering by condition is useful when you need a rule rather than a hand-picked list. Depending on the column type, conditions can include text matching, numeric comparisons, date rules, or whether a cell is blank. For instance, a due-date condition can focus attention on dates before a chosen day, while a text condition can show descriptions containing a particular word. The available conditions depend on the values and controls Sheets offers for that column.

Sorting changes the order in which matching rows appear in the view. Sort names alphabetically, amounts from largest to smallest, or dates from oldest to newest to make a review easier. When sorting a table, apply it through the filter-view column controls rather than selecting only one column and sorting it by itself; sorting a single column separately can detach values from their corresponding records.

Filters across columns combine to narrow the result. If you filter Region to North and Status to Open, the view shows rows satisfying both selections. If a filter seems to hide too much, inspect each column’s active selections and clear or adjust the one that excludes the rows you expected to see.

Name, save, and share filter views

Give views names that describe the question they answer, not just the date you created them. Names such as Needs review or Orders by month communicate their purpose. If a view is temporary or experimental, a label such as Draft: late invoices can prevent collaborators from mistaking it for an official report.

Filter-view changes are saved as part of the view, so closing it does not mean you have to recreate the same filters the next time. To return to a saved view, use the filter-view options in the Data menu and choose the named view. If the list is crowded, remove views that are no longer useful, taking care not to delete one another still relies on.

You can share a link to a particular filter view with someone who already has permission to open the spreadsheet. The link can make it easier to land on the relevant view, but it does not grant access to the file or make restricted data safe to expose. Confirm the spreadsheet’s sharing settings separately, and explain the view’s purpose if the recipient may not recognize its name.

Filter views versus a regular filter

A regular filter is useful when a sheet has one shared filtering state—for example, a small list that one person manages at a time. Applying or changing that filter affects what collaborators see on the sheet, so it can be inconvenient when several people want different results simultaneously.

A filter view is intended for saved, individualized ways of looking at the same data. People can use different views without repeatedly replacing one another’s filtering choices. It also lets you keep several named arrangements, such as a high-priority queue and a completed-items review. It is not the same as hiding rows manually: hidden rows are a direct sheet change, while a filter view is a reusable filtered display.

Excel has a related feature called Sheet View in versions that support it, but Google Sheets menus and filter-view behavior are not the same as Excel’s. Follow Google Sheets instructions when working in Sheets; do not expect an Excel ribbon command or workbook setting to apply.

Useful ways to apply filter views

Filter views are most helpful when a shared dataset serves several recurring questions. A support team could save one view for unassigned tickets and another for tickets due today. A teacher could create a view for one class section, while keeping the full grade table intact. A small business might save separate views for each sales region or for invoices awaiting payment.

They are also handy for temporary checks. Before a meeting, filter to a project and sort by due date to review the next milestones. Afterward, close the view and leave the master table unchanged for the next person. For recurring work, write a short description in the view name or share message so people know what criteria it represents and whether it is meant for a current period or a standing workflow.

Common problems and how to fix them

The menu item is unavailable or the controls look different: Make sure you are using Google Sheets in a desktop browser and have suitable access to the spreadsheet. The mobile app may not expose the same filter-view creation workflow.
Some records do not appear in the filter controls: Check whether the selected range includes all rows and the header row. Blank rows or columns can split the table that Sheets recognizes.
A row seems to have disappeared: Review active filters in every column. A row may fail one of several conditions, even if it matches the filter you were looking at.
Values are sorted but no longer match their other columns: Undo if appropriate, then sort using the filter-view control for the relevant column and ensure the sort applies to the full data range. Do not sort a lone column independently.
A collaborator cannot open the link: A link to a view does not bypass file permissions. Ask the owner to grant the needed spreadsheet access, or use the correct account.
A saved view is hard to find: Reopen the filter-view list from the Data menu, and use clear, distinct names when creating views. Remove obsolete views only after checking that they are no longer needed.

If the data table changes frequently, check the range when you add filter views and test the view after adding rows or columns. A view that was created around a fixed range may not include records placed outside that range. Adding new records directly below the table and keeping the columns consistent makes it easier for Sheets to treat them as part of the dataset.

Frequently Asked Questions

Can I create a filter view in the Google Sheets mobile app?
Filter views are best created and managed in Google Sheets on a desktop web browser. Mobile apps may let you view or interact with spreadsheet data, but they do not provide the same full filter-view workflow.

Will a filter view delete or change my data?
No. Filtering hides rows from that view and sorting changes their displayed order; neither action is meant to delete records. Editing cell contents while in a view, however, edits the spreadsheet data itself.

Can two people use different filter views at the same time?
Yes. That is a central reason to use filter views: collaborators can look at different filtered arrangements of the shared data instead of replacing one another’s view with a single shared filter state.

How do I reopen a saved filter view?
In the desktop browser, open the filter-view options from the Data menu and select the named view. If it is missing, confirm you are in the right spreadsheet and that the view has not been removed.

Does sharing a filter-view link share the spreadsheet?
No. The link can point a recipient to a view, but the recipient still needs permission to access the spreadsheet. Set file-sharing permissions separately and do not rely on a filter to conceal confidential information.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.