Google Sheets: Add a Filter to a Column and Sort Rows

To add a filter in Google Sheets, select the data range, including its header row, then choose Data > Create a filter. Use the filter button in the column header to show selected values or set a condition; the filter hides rows that do not match, but does not delete them.

Quick steps to add a filter

These steps are for Google Sheets in a web browser. For a reliable result, first make sure each column has a clear header and the rows form one continuous table. Then:

Select the cells you want the filter to cover, including the header row and all relevant data columns. For example, select A1:D200 if row 1 contains headers and the records occupy columns A through D.
Choose Data > Create a filter.
Look for a small filter icon in each selected header cell. Click the icon in the column you want to filter.
Choose values to keep, or select a condition such as text contains or date is after. Click OK when the options are set.

Only matching rows remain visible. You can still read and edit those displayed cells if you have permission to edit the sheet. To show all rows again, open the same column menu and clear the selection or condition, or turn off the filter with Data > Remove filter.

What a column filter does

A filter is applied to a range of rows, not just to the cells in one column. The column’s header menu tells Sheets which records to show, and entire rows that fail the selected rule are hidden from view. This preserves the relationship between values in a record. For example, filtering a sales table to show only the West region keeps each visible sale’s date, salesperson, and amount together.

This is different from deleting data or copying matching records elsewhere. The hidden rows remain in the sheet and can reappear when you clear the filter. A filter also does not change the underlying value in a cell: it changes which rows are displayed. If you need a separate, automatically updating list of matching records, a filter view or a formula-based result may be more suitable.

Although the task is often described as adding a filter to a column, include the complete table in the filter range whenever possible. If you filter only the Region column while leaving related fields outside the range, sorting or filtering can make the visible data misleading because neighboring values may not move as one record.

Choose values or set a condition

Click the filter icon in the relevant header to see the options available for that column. Filter by values is useful when the column contains a manageable list of categories. For instance, in a Status column, you can leave Complete selected and clear In progress and Waiting. Sheets then displays only rows with the selected status.

For larger lists or rules that are easier to describe than to select item by item, use Filter by condition. The condition choices depend on the data type and may include rules such as text contains, text starts with, date is before, is greater than, or is empty. A number example would be showing only orders with a quantity greater than 10; a text example would be showing names containing the word Lee.

Check the column’s data before choosing a condition. Dates stored as text, numbers with inconsistent formatting, or extra spaces can cause a rule to behave differently from what you expect. If a value is missing from the list of selectable values, first check whether the relevant rows fall inside the filter range and whether another filter is already hiding them.

Filter across more than one column

You can set rules in multiple header menus while the same filter is active. For example, in a table with Region, Status, and Amount columns, select West in Region and then set Amount to greater than 500. The visible rows must satisfy both column filters, so the result contains West-region records whose amount exceeds 500. This is a practical way to narrow a large list without changing or rearranging its source data.

Within one column, selecting several entries under Filter by values keeps rows that match any of those selected entries. Across different columns, the selected filters narrow the result together. If the result is unexpectedly empty, remove one condition at a time to find out whether a rule is too restrictive or the data is formatted inconsistently.

Filters can also be useful for checking a dataset. For example, filtering a required field to show blanks can reveal records with missing customer IDs. After reviewing the rows, clear that filter to restore the full list. Treat this as a way to inspect the data, not as a cleanup action: the filter itself does not fill in missing values or correct errors.

Use a filter view when others need their own view

A standard filter changes the displayed rows for the sheet, which can be inconvenient when several people are working in the same file. If collaborators need to sort or narrow the same data differently, use a filter view. In Google Sheets on the web, choose Data > Filter views > Create new filter view. Set the conditions from the header menus, then give the view a useful name in the filter-view bar.

A filter view lets a person examine a subset or sort the data without imposing that particular view on everyone else. It is helpful for examples such as one teammate reviewing overdue items while another checks a different region. Save the view if it will be useful again, and close it when you want to leave that view. Filter views do not create a separate copy of the underlying records.

Use a regular filter when you are working alone or when a shared displayed view is intentional. Choose a filter view when people need independent ways to examine the same table. These features do not replace access controls: a filter is not a privacy measure, and hiding rows should never be treated as a way to prevent someone with file access from seeing the data.

Common filter problems and how to fix them

No filter icons appear: Confirm that a range is selected and choose Data > Create a filter. Check that you have permission to make the change and that the sheet is not in a state that prevents editing.
Some records do not respond to the filter: The selected range may stop before the last row or omit a related column. Turn off the filter, select the full rectangular table, and create it again.
The header is treated like ordinary data: Include the header row when creating the filter and make sure the first row of the range contains labels rather than a data record.
Rows appear to be missing: Check every active column filter. More than one filter can be narrowing the visible results at once. Clear the relevant selections or remove the filter to reveal all rows.
Sorting separates values from their records: Do not sort one isolated column beside related data. Apply the filter to the full table so each row remains a complete record when sorted.

Blank rows and columns can also make it harder to identify the intended data range. A single blank row within a dataset may make a table look like two separate blocks. For dependable filtering, keep the table rectangular, use one header row, and avoid merged cells in the header area. If the sheet has notes or a summary above the data, select the table itself rather than including those extra rows.

Filtering versus sorting

Filtering and sorting are related options in the column menu, but they answer different questions. Filtering asks which rows should remain visible, such as only invoices marked Unpaid. Sorting changes the order of rows, such as arranging invoice dates from oldest to newest. A filter does not automatically sort the results, and sorting alone does not hide records.

Both operations can be useful together. You might filter a Task column to show Open tasks, then sort the Due date column so the nearest deadline appears first. When sorting, apply the operation to the complete dataset so the task names, owners, and dates stay together. If you only need to rearrange a list temporarily, remember that sorting changes the displayed order of the source range rather than creating a separate report.

Good practices for dependable results

Use one clearly labeled header row, with a distinct heading for each column.
Keep every record on one row and avoid blank separator rows within the table.
Select all related columns and data rows when creating the filter, not just the column you plan to inspect.
Use consistent data types: enter dates as dates and numbers as numbers, rather than mixing them with text versions.
Clear filters before concluding that records are missing, and use a filter view if collaborators need independent views.

For a simple contact list, for instance, headers might be Name, City, and Follow-up date. Filtering City to Portland shows the matching contacts while retaining their follow-up dates. Sorting the full range by Follow-up date can then put those contacts in date order. This small example illustrates why the range should include the whole record even when the filter rule uses only one column.

Frequently Asked Questions

Can I filter just one column without hiding the other columns?

You can choose a condition from one column’s header, but matching and nonmatching rows are shown or hidden across the table range. This keeps each record intact; the filter is not a way to hide only individual cells in that column.

How do I remove a filter in Google Sheets?

To remove the standard filter, choose Data > Remove filter. To keep the filter available but display all rows, clear the active selections or conditions in the column menus instead.

Will a filter delete rows that do not match?

No. A filter hides rows from the current view; it does not delete their contents. Clear the filter or remove it to show the rows again.

Can I filter by two columns at the same time?

Yes. Set a filter in each relevant header menu. For example, choose a region in one column and a date or amount condition in another to narrow the visible records using both rules.

What is the difference between a filter and a filter view?

A standard filter changes the displayed view of the sheet, which may affect collaborators looking at that sheet. A filter view is designed for a separate saved way to sort or filter the data, making it useful when people need independent views.

Why can’t I see all my data after adding a filter?

One or more active filters may exclude those rows, or the filter range may not include all the data. Inspect each column’s filter menu, clear conditions to reveal hidden rows, and confirm that the full table was included in the range.

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.