How to Apply a Filter in Google Sheets: Narrow Data

To filter data in Google Sheets in a web browser, select your table, choose Data > Create a filter, then use the filter icon in a column header to choose which rows to show. A filter hides rows that do not match your choices; it does not delete them, so you can focus on a smaller part of the table and restore the full list later.

Before you begin, make sure the data has a clear header row and that each column contains one kind of information, such as a date, name, or status. The steps below use the standard filter for a shared sheet. If other people are working in the same sheet, a filter view can be a better choice because it lets you filter without changing the shared filter everyone sees.

What You’ll Need

A Google account with access to the spreadsheet in a web browser, such as Chrome, Firefox, Safari, or Edge.
A rectangular table with a header row, for example, a row of headings above the records you want to filter.
Edit access if you need to create or change the standard filter. If you only need a personal view or have limited access, check whether filter views are available to you.

You do not need to install an add-on or write a formula. If the information is spread across separate blocks, first decide whether those blocks should be combined into one table. A filter works most predictably when every row represents one record and every column represents one field.

Step-by-Step

Open the spreadsheet and check the table. Find the header row and scan the records below it. Each column should have a heading, and the rows should follow the same structure. For example, an order list might have headers for Order date, Customer, Region, and Status. Remove completely blank rows or columns that split the table if they are not meant to be part of it. Do not include a totals row in the filtered records unless you want it filtered like ordinary data.
Select the data range, including its headings. Click and drag from the top-left header cell to the bottom-right cell of the table, including every column you want to filter and all its records. For example, if the headings are in A1:D1 and the records end at row 100, select A1:D100. You can click a cell inside a single, uninterrupted table, but selecting the full range makes it easier to confirm exactly what will be filtered. Leave unrelated notes or separate tables outside the selection.
Turn on the filter. In the Google Sheets menu, click Data > Create a filter. A filter icon appears in each header cell in the selected range, and the header row may get a filter-style appearance. If the icons do not show in the expected columns, undo or remove the filter and check that you selected the right range. The filter is now available, but no records are hidden until you choose a condition.
Open the menu for the column you want to filter. Click the filter icon in that column’s header. The menu includes choices for filtering by values or by condition; in some cases, it also offers filtering by color. For a simple category column such as Status, use values. For a numeric column such as Quantity, or a date column, a condition can be more convenient. Take a moment to confirm you opened the menu for the correct heading.
Choose specific values or set a condition. To show selected categories, use Filter by values, clear the selections you do not want, and leave checked the values to keep. The menu may include a search box, which helps when a column has many distinct entries. To filter using a rule, choose Filter by condition, select a rule such as Text contains, Greater than, or Is not empty, enter any requested value, and apply it. For example, a Status column can show only Open, while a Sales column can show values greater than a chosen amount.
Apply the choice and inspect the rows. Click OK if the menu presents that button. Rows that do not match the filter are hidden, while matching rows remain in the sheet. Check a few visible records against the rule you chose. A missing row is not necessarily lost: it may simply fail the current condition. The column’s filter icon can help identify where a filter is active.
Add a filter on another column if needed. Open the filter menu for a second header and choose another value or condition. Filters on separate columns work together: a row must satisfy all active column filters to remain visible. For instance, filtering Region to West and Status to Open shows open records in the West region, not every open record or every record in the West region. If the result is unexpectedly small, review each active column filter.
Clear a filter or remove the filter controls. To show all records again while keeping the filter available, open the relevant column menu and select all values or clear that column’s condition, then apply the change. Repeat for other filtered columns if necessary. To turn off the standard filter entirely, choose Data > Remove filter. The hidden rows reappear; removing the filter does not delete the table or undo edits made to its cells.
Use a filter view when you do not want to change the shared filter. Choose Data > Filter views > Create new filter view, then set the range and apply filters in the view. Filter views are useful in collaborative sheets because people can work with a separate filtered or sorted view rather than replacing the standard filter for everyone. Give the view a useful name if the option is available, and close it when you are done using the view controls. Check access settings if you cannot create one.

Common Mistakes

Including the wrong range: If the selection misses a column or some records, those cells will not behave as part of the filtered table. If it includes a separate note or another table, those cells may be treated as though they belong to the same data set. Remove the filter, select the complete table, and create it again.

Leaving out or misidentifying the header row: Google Sheets uses the first row in the selected range as the filter header. If the selection starts one row too low, a data record may become a heading; if it starts above the actual headings, the icons may appear on the wrong row. Include the real headings and avoid blank heading cells where possible.

Expecting a filter to delete or rearrange records: A filter hides rows that fail the rule; it does not erase them. Filtering is also different from sorting. If you choose a sort option from a column menu, the matching data may be reordered, so use the filter choices when your goal is only to narrow what is displayed.

Filtering inconsistent entries: A category written as Open, open, and Open with a trailing space may not behave like one clean value. Dates stored as text can also be harder to filter as dates. Standardize entries and check how values are stored before assuming a filter is wrong.

Forgetting that filters combine: Multiple active columns narrow the results together. A row that matches the first filter but not the second stays hidden. Check every column with an active filter before concluding that records are missing.

Tips

Use one descriptive heading per column, such as Date, Owner, or Priority. Short, unique headings make the filter menus easier to recognize.
Use Filter by values for a short list of categories and Filter by condition for rules like greater than, contains, or is blank. Searching the values list is quicker than scrolling through a long list.
When building a rule, describe the result in plain language first. For example, “show dates on or after May 1” is a date condition; “show rows where Status is Waiting” is a value choice. This helps you pick the right filter type.
Use filter views for different tasks or collaborators, such as a view for one region and another for overdue work. Give each view a clear name so people can tell what it shows.
Before sharing a filtered sheet, tell collaborators that some rows are hidden by a filter. They may otherwise think records are missing. If everyone needs a different view, prefer filter views over changing one standard filter repeatedly.
Keep a separate totals row outside the filtered range when you want it to remain visible regardless of which records are shown. If a total is inside the range, it may be hidden or treated as another record.

In Microsoft Excel, the comparable command is Data > Filter on the Windows ribbon, rather than Google Sheets’ Data > Create a filter menu path. Excel has its own filter and view features, so Google Sheets filter views do not transfer as the same interface or behavior.

Troubleshooting

No filter icons appear: Confirm that you selected the data range and chose Data > Create a filter. If the command is unavailable or the range is not behaving as expected, check whether you have edit access, whether a filter is already active, and whether merged cells or a disjoint selection are complicating the range. Try selecting one clean rectangular table, including its header row.

Rows you expect to see are hidden: Open each column’s filter menu and check its selected values and conditions. A restrictive rule on a different column may be excluding the row. Clear one filter at a time to find the one causing the issue. Also inspect the source cell for extra spaces, spelling differences, or a value stored in an unexpected format.

A number or date condition gives surprising results: Check whether the cells contain real numbers or dates rather than text that only looks like a number or date. A quick clue is inconsistent alignment or formatting, though alignment alone is not definitive. Correct the underlying entries or convert them to a consistent type, then reapply the filter. Make sure the condition and comparison value use the intended units and date.

The filter affects a coworker’s view: You may be changing the standard filter, which is shared behavior in the sheet. Restore the desired standard filter or remove it, then use Data > Filter views for a separate view if available. A filter view can help collaborators inspect different subsets without continually replacing the common filter setup.

The filter stops before the last rows: The selected range may not include newly added records, especially if a blank row or column separates them from the original data. Remove the current filter and recreate it with the complete expanded range, including the new records. Keep the table contiguous when adding future rows so the intended range is easier to select.

You cannot edit the filter: Check whether the sheet or range is protected and whether your account has the required permission. Ask the owner for edit access or for an unprotected range if appropriate. If you only need to inspect data, use an available filter view or ask the owner to create one rather than changing protected content.

Frequently Asked Questions

Does applying a filter delete rows?
No. A filter temporarily hides rows that do not meet the selected criteria. Clear the filter or select all values to make those records visible again. Deleting rows is a separate action and is not required to filter data.

Can I filter more than one column at a time?
Yes. Apply a filter to each relevant column. The selected conditions work together, so visible rows must match the conditions across the filtered columns. Clear or adjust a condition if the combined result is narrower than you intended.

Can I filter by a word or number without selecting a list of values?
Yes. Open the column filter menu, choose Filter by condition, select a suitable rule, and enter the word, number, or other value requested. The available rules vary with the type of data in the column.

How do I show all rows again?
Open each active filter menu and select all values or clear its condition, then apply the change. To remove the filter controls as well, choose Data > Remove filter. Both actions reveal rows that were hidden by filtering.

What is the difference between a filter and a filter view?
A standard filter is the shared filter setup for the selected range. A filter view lets you create a separate filtered view, which is useful when collaborators need different subsets or when you do not want to change the shared setup. Use Data > Filter views to create or manage views.

Can I filter a sheet on a phone?
The instructions here are for Google Sheets in a web browser. The Sheets mobile app has a different interface and may not show the same menu paths. For these exact steps, open the file in a desktop browser; on a phone, use the app’s available filter controls or switch to a browser view that supports the full Sheets interface.

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.