Google Sheets Filter Multiple Columns: How It Works

Yes. In Google Sheets in a web browser, select Data > Create a filter, then set a filter on each column you want to narrow; conditions on different columns work together, so a row must satisfy all of them. For example, you can show orders from the West region with a value of at least $500.

How filtering multiple columns works

A filter temporarily hides rows that do not meet your chosen criteria. It does not delete those rows or change the values in them. You can apply filters to more than one column in the same data range, and each column gets a filter icon in its header. Choose a condition for one column, then open another column’s filter menu to add another condition.

Across columns, filters normally act like AND: a row appears only when it passes every active column filter. If you filter Region to West and Amount to greater than or equal to 500, a West row worth $450 is hidden, as is a $600 order from the East. Only rows meeting both conditions remain visible. This is useful for narrowing a large list by combinations such as date and status, department and role, or product and price.

Filtering affects what is displayed, not the underlying order records or data. Clear or remove the filters to see the other rows again. If you copy or export only the visible cells, however, take care to distinguish that selection from the full dataset.

Set up a filter across columns

Start with a rectangular data range: a header row followed by records, with each field in its own column. For example, a simple order list might have Date, Region, Salesperson, and Amount in columns A through D. Avoid blank rows or columns inside the data, since they can make it harder to identify and filter the complete range.

Click a cell within the data. If the range is not clearly contiguous, select the full range, including its headers.
Choose Data > Create a filter. Filter icons appear in the header row.
Click the filter icon in the first column you want to use. Choose values to display or select a condition and enter its details.
Open the filter icon in another column and add its criterion. Repeat for each field you need.
Check the visible rows and the active filter icons. To restore the full list, use the filter menus to clear conditions or choose Data > Remove filter.

For instance, filter Region to West, then Amount to greater than or equal to 500. You can add a third condition, such as a date range, without replacing the first two. The combination is especially helpful when each condition alone would leave too many results.

Choose values or define conditions

Each column menu offers ways to filter its contents. Filter by values lists the values found in that column, usually as checkboxes. It is convenient when you want to include a few known categories, such as West and Central, or exclude a particular status. If the list is long, use its search box to locate a value.

Filter by condition is better for rules that describe a range or text pattern. Depending on the column’s data type, options can include comparisons such as greater than, text contains, or date conditions. This lets you show every amount above a threshold or every description containing a word, rather than selecting each matching value individually.

Make sure the values have the expected type. A date stored as plain text may not behave like a date, and numbers stored with extra text may not sort or compare as numbers. If a condition gives unexpected results, inspect a few source cells and correct inconsistent data rather than assuming the filter menu is faulty.

Understand AND and OR criteria

A common source of confusion is the difference between combining criteria across columns and combining alternatives within one column. Separate column filters are generally AND conditions: Region is West and Amount is at least 500. Within a single column, selecting more than one listed value generally means either value can match. Selecting West and East in the Region value list means West or East.

For more complicated logic, think through the groups before applying filters. Suppose you need West or East orders, but only when Amount is at least 500. You can select both regions in the Region value list and add the amount condition. The two regions are alternatives within that field, while the amount rule must also be true.

More complex combinations, such as “West orders over $500, or East orders over $1,000,” may be awkward to express with the standard column menus because each filter is applied to its column. A formula can make that logic explicit, or you can create a helper column that labels rows meeting the desired rule and filter that column. Keep the rule documented if other people will maintain the sheet.

Use filter views for separate workflows

A standard filter changes the displayed rows for the sheet, which can affect what collaborators see while they are working in the same spreadsheet. If different people need different filtered versions of the same data, use a filter view instead. In Google Sheets, choose Data > Create a filter view, then set column filters as usual. You can give a view a name so it is easier to recognize later.

Filter views are useful for saved perspectives such as “Open items,” “West region,” or “This month.” They let a user inspect a subset without permanently changing the source data or forcing the whole team to use the same view. They are not separate copies of the data: edits to the underlying cells remain edits to the shared spreadsheet.

Use a regular filter when one temporary view is enough and it is appropriate for collaborators to see it. Use filter views when people need distinct saved views or when changing the shared display would be disruptive. The exact options available can depend on access permissions and whether you are working in a shared file.

Use the FILTER formula for live results

The menu filter is interactive: it hides rows in the original range. Google Sheets also has a FILTER function, which returns matching rows as a separate result. That can be useful for a report, dashboard, or separate working area that should update as the source data changes. Leave enough empty space for its output to expand, and do not place it where it would overwrite existing cells.

Assume rows 2–100 contain orders in columns A:D, with Region in B and Amount in D. If row 2 is West and $600, row 3 is East and $700, row 4 is West and $400, and row 5 is North and $900, this formula returns rows meeting both the West and $500 conditions:

=FILTER(A2:D100, B2:B100="West", D2:D100>=500)

In that example, the result is row 2 only. Each condition range must cover the same number of rows as the data range. To return either West or East orders that are at least $500, with the same layout, use:

=FILTER(A2:D100, ((B2:B100="West")+(B2:B100="East"))>0, D2:D100>=500)

That example returns rows 2 and 3. The addition combines the two region tests as alternatives, while the separate amount test still applies to both. A formula result is not the same as hiding source rows, and it does not provide the same interactive filter menus. If nothing matches, Google Sheets returns a no-match error; consider whether that is acceptable for the report.

Common problems and fixes

Only part of the table filters: Check that the filter covers every relevant column and row. Remove it, select the complete range including headers, and create it again if necessary.
A header is treated as a record: Create the filter with the header row included and confirm that the field names are in the first row of the selected range.
Some expected values are missing: Look for extra spaces, inconsistent spelling, blank cells, or values stored in different formats. “West” and “West ” can be distinct text values.
Filters seem to conflict: Remember that conditions in different columns must all match. Clear one condition temporarily to see which rule is excluding the row.
A collaborator sees a different subset: Check whether a standard filter is active. A filter view is usually the better choice when users need independent views.
Rows appear to have vanished: They may simply be hidden by a filter. Clear the conditions or remove the filter before concluding that data was deleted.

Google Sheets filters compared with Excel

The core idea is familiar in both Google Sheets and Microsoft Excel: apply criteria to multiple fields to narrow a list. The menu wording and collaboration features differ, though, so instructions for one program should not be assumed to match the other. These steps use Google Sheets in a web browser, not Excel’s ribbon or desktop menus.

In Sheets, filter views are a useful collaboration feature for keeping saved perspectives separate from the ordinary shared display. The FILTER function is another option when the desired output should be a formula-driven result rather than hidden rows. Choose the menu filter for quick exploration, a filter view for a reusable personal or team perspective, and a formula when the result needs to appear elsewhere in the sheet.

Frequently Asked Questions

Can I filter two or more columns at the same time in Google Sheets?
Yes. Create a filter for the data range, then set a condition from each column’s filter menu. Rows must satisfy the active conditions across those columns.

Does filtering multiple columns use AND or OR?
Filters on separate columns work as AND conditions. Multiple selected values within one column generally work as OR alternatives. For more involved combinations, use a formula or a helper column.

How do I filter by two values in the same column?
Open that column’s filter menu, choose the value-filter option, and select both values. The results can include rows matching either selected value; other active column filters still apply.

Can I save a multiple-column filter?
Yes. Create a filter view using Data > Create a filter view, apply the criteria, and name the view. This is useful when you want to return to a particular combination later.

Does a filter delete rows that do not match?
No. It hides nonmatching rows from the current display. Clear or remove the filter to show them again; inspect the full range before copying or exporting data if you need every record.

Why is a row missing even though one of its values matches?
Another active column condition may exclude it, or the cell may contain a different spelling, extra spaces, or a value stored in an unexpected format. Review all active filters and the original cell contents.

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.