Google Sheets Filter Columns: How It Works

To filter data in Google Sheets, select your table and choose Data > Create a filter, then use the filter icon in a column header to choose values or set a condition. A standard filter hides rows that do not match; it does not hide columns, although a formula can return selected columns.

What filtering columns means in Google Sheets

The phrase “filter columns” can mean two different things. Most people want to filter records using the values in one or more columns—for example, show only orders from the West region. In that case, Google Sheets keeps the columns in place and temporarily hides rows that do not meet the chosen criteria.

Sometimes, though, a person wants to display only certain columns, such as showing selected months from a wide report. The regular filter menu is not designed to hide columns based on their contents. You can hide columns manually, or use the FILTER function to produce a formula-driven result that contains selected columns.

Keeping these meanings separate prevents a common mistake: applying a filter to a column does not remove that column from the sheet. It changes which rows are visible. Hidden rows remain in the spreadsheet and can be shown again by clearing the filter.

Create a standard filter

For a typical table with one header row and records underneath, create a filter from the Google Sheets menu in a web browser:

Select the complete data range, including the header row. For example, select A1:D101 if row 1 contains headings and rows 2 through 101 contain records.
Choose Data > Create a filter. Filter icons appear in the header cells of the selected range.
Click the filter icon in the column you want to use.
Choose values to include or choose a condition, then apply the selection.

If the table is a single uninterrupted block, clicking a cell in the data and choosing Data > Create a filter may be enough for Sheets to identify the range. Selecting the range yourself is safer when nearby cells contain other information, or when the table has blank rows or columns that could confuse the boundary.

Use clear, unique headings in the first row. A header row makes it easier to recognize each filter menu and helps prevent headings from being treated as ordinary records. Avoid merged cells within the data range; they can interfere with sorting and filtering.

Filter by values or by a condition

A filter menu offers two useful approaches. “Filter by values” lets you select particular entries from the column. For instance, a Status column might list Open, Pending, and Closed. Selecting Open and Pending shows rows with either of those values and hides rows marked Closed. Searching within the value list is useful when a column contains many distinct entries.

“Filter by condition” is better when you want a rule rather than a hand-picked list. Available condition types depend on the data and can include text, numbers, dates, whether a cell is empty, or whether it is not empty. A sales table could show amounts greater than 500; a text column could show entries that contain a word. Choose the condition, enter any requested value, and apply it.

Filtering does not change the underlying cell contents. It changes which rows are displayed, so clearing the filter restores the hidden records. Be cautious when copying only visible results: check the destination and selection before pasting, especially if you need a complete data extract rather than a filtered view.

Combine filters across several columns

You can apply a filter in more than one column of the same range. For example, a service team might filter Region to West and Status to Open. The visible records must satisfy both active column filters, so the result is the intersection of the criteria—not every West record plus every Open record.

This makes a standard filter practical for narrowing a dataset step by step:

Filter Region to West.
Filter Status to Open.
Optionally filter Priority to High to narrow the remaining rows further.

To broaden the results within one column, select multiple values in that column’s value list. For example, selecting West and Central includes rows from either region. Across different columns, however, the filters work together: a row must meet the selected region criterion and the selected status criterion.

When the result unexpectedly shows no records, temporarily clear one column’s criteria at a time. This helps identify whether the issue is an overly narrow combination, inconsistent spelling, extra spaces, or a value stored in a different format.

Use filter views for separate views of shared data

A standard filter changes the displayed results for the sheet and can affect what collaborators see. If several people need different ways to inspect the same table, a filter view is usually more appropriate. In Google Sheets, choose Data > Filter views > Create new filter view, then set criteria using the column filter icons.

Filter views let users create and name separate arrangements of filter criteria without replacing one another’s view of the data. They are useful for a shared task list where one person needs to see overdue work and another needs to see tasks assigned to a particular team. You can save a view for reuse and share access to a view by its link, subject to the spreadsheet’s sharing permissions.

Use a standard filter when one shared set of criteria is appropriate for everyone working with the sheet. Use filter views when people need independent saved views. Neither option creates a separate copy of the records; edits to the underlying cells still affect the shared spreadsheet.

Return selected columns with the FILTER function

If you mean “show some columns but not others,” the FILTER function can create a separate, formula-driven output. In Google Sheets, FILTER returns the rows or columns of a range that match one or more conditions. The condition range must line up with the direction being filtered: a condition with one value per row filters rows, while one value per column filters columns.

For example, assume A1:D4 contains a small table, and A2:D2 contains a Yes or No marker for each column. Put the formula below in an empty area of the sheet:

=FILTER(A1:D4,A2:D2=F1)

Here F1 contains Yes. The condition range A2:D2 spans the same four columns as A1:D4, so the formula returns the columns whose marker in row 2 matches F1, including their headings and other rows. If the markers are Yes, No, Yes, No, the result contains the first and third columns. Changing F1 to No returns the second and fourth columns.

The output is a formula result, not a change to the original table. Leave enough empty cells to the right or below for the result to expand; existing content in its output area can cause an expansion error. If no columns match the condition, FILTER returns a #N/A error. You can handle that with IFNA if a blank result is preferable, but first check that the condition and marker values are spelled and formatted consistently.

To filter records rather than columns, use a condition range that has one corresponding value for every row in the source range. For example, if A1:D4 is the table and column B contains region names, a row-based formula can use a range of matching height, such as B1:B4, with a condition on the desired region. The output spills into neighboring cells and does not alter the source data.

Hide columns instead of filtering rows

If your goal is simply to remove columns from view, select the column letters, right-click, and choose Hide column or Hide columns. This is a display change, not a filter: the columns are hidden for people viewing that sheet, while the remaining columns stay visible. Use the arrows in the column headings where the hidden columns were to show them again.

Manually hiding columns is useful for temporarily simplifying a report, but it is not a dynamic rule. If you want a changing output based on a marker or value, use a formula such as FILTER. If you want to make a compact report without changing the source table, place that formula on a separate sheet or in a separate area.

Google Sheets and Excel both support filtering rows and hiding columns, but the menus and collaboration features differ. In Sheets, use Data > Create a filter and Data > Filter views. Excel has its own Filter and sheet-view tools; menu paths and behavior are not identical, so instructions for one program should not be assumed to match the other.

Common filter problems and how to fix them

The filter icon is missing: Check that you created a filter for the range and that the header row is included. Also check whether you are looking at the intended sheet or range.
Some records are not included: The selected filter range may stop before the last row or column. Remove the filter, select the full table, and create it again.
A value seems absent from the list: It may be spelled differently, contain leading or trailing spaces, or be stored as text rather than a number or date. Inspect the source cells and make the values consistent.
Filtering one column gives surprising results: Another column may still have an active criterion. Review each header’s filter menu and clear criteria that are no longer needed.
Sorting or filtering mixes unrelated information: The filter range may include adjacent cells that are not part of the table, or omit related columns. Select the intended rectangular data block before recreating the filter.
A FILTER formula shows an error: Confirm the condition range has the same number of columns or rows as the direction being filtered, check for a match, and make sure the output area is empty.

Before changing a shared sheet, consider whether collaborators rely on the current filter or layout. A filter view can help avoid disrupting someone else’s view. For a repeatable report, keep raw data separate from formula-based output so it is clear which cells are source records and which are generated results.

Frequently Asked Questions

Can Google Sheets filter columns instead of rows?
Yes, with the FILTER function when you need a formula result containing selected columns. The standard filter menu filters rows based on values in columns; it does not dynamically hide columns.

How do I filter one column in Google Sheets?
Select the table, choose Data > Create a filter, click the filter icon in the desired header, and choose values or a condition. The rows that do not meet the criterion are hidden from view.

Can I filter by more than one column?
Yes. Set a criterion in each relevant column’s filter menu. A row remains visible only when it meets the active criteria across those columns.

How do I remove a filter in Google Sheets?
To remove the standard filter controls, choose Data > Remove filter. To keep the filter but show more records, reopen the relevant column menu and change or clear its criteria.

Do filters delete hidden rows?
No. Filtering hides nonmatching rows from the current view; it does not delete their data. Clear the criteria to display those rows again.

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.