Google Sheets Filter Shortcut: Turn Filters On and Off

In Google Sheets in a web browser, press Ctrl+Shift+L on Windows or ChromeOS, or ⌘+Shift+L on a Mac, to turn a filter on or off for the selected data range. You can also use Data > Create a filter; the shortcut is the quick way to toggle the same feature.

The shortcut and what it does

A filter lets you temporarily hide rows that do not match conditions you choose, such as showing only one department, dates after a certain day, or values above a threshold. It does not erase the hidden rows or change the underlying values. When a filter is active, filter icons appear in the header row, and each column’s menu lets you choose what remains visible.

Press the shortcut while your selection is within the table or data range you want to filter. Sheets usually identifies the connected data range around the active cell; selecting a precise range first is a safer choice when the sheet contains nearby tables or unrelated notes. If a filter is already active for that range, the shortcut can turn it off. Use the menu path if you want to see the current command or if the keyboard combination is intercepted by your browser.

Windows or ChromeOS: Ctrl+Shift+L
Mac: ⌘+Shift+L
Menu alternative: Data > Create a filter

These are Google Sheets shortcuts, not universal shortcuts for every spreadsheet program. Excel uses a similar Windows shortcut, but its menus and some filtering behavior differ. Make sure the spreadsheet tab is active before pressing the keys.

How to create a filter step by step

For a clean result, arrange the data as a table: one header row, one record per row, and one field per column. For example, a small order list might have headers for Order date, Region, Product, and Amount. Avoid blank rows or merged cells inside the data; they can make it harder for Sheets to identify the intended range.

Click a cell inside the table, or select the full range including its header row.
Press Ctrl+Shift+L on Windows or ChromeOS, or ⌘+Shift+L on Mac. Alternatively, choose Data > Create a filter.
Check that filter icons appear beside the column headings. Click the icon for the field you want to narrow.
Choose values to show, or use the options for filtering by condition or by color. Click OK or Apply if the menu presents that button.

For instance, in an order table you could open the Region filter and leave only West selected. Rows for other regions disappear from view, while the West rows remain. You can then filter Amount as well to focus on orders above a chosen value. Applying filters to multiple columns narrows the visible results to rows that satisfy all the active column filters.

What happens to filtered rows

Filtering changes which rows are displayed, not the data stored in the sheet. Hidden rows remain in place and become visible again when you clear the filter or turn filtering off. This is an important distinction from deleting rows: a filtered-out record is still part of the spreadsheet and may still be included in formulas, depending on the formula and how it is written.

Sorting from a filter menu also changes row order rather than removing records. A sort can be useful for reviewing the visible data, but remember that it rearranges rows in the shared sheet. If you only want to inspect a subset without changing how other collaborators see the sheet, consider a filter view instead.

Do not use a filter as a privacy or access-control tool. Other editors may be able to clear it and see the hidden rows, and hidden data remains in the file. If certain people should not have access to records, manage sharing permissions or place the data in a separately protected file rather than relying on filtering.

Choosing the right range and headers

Range selection is one of the most common sources of confusing results. If the active cell is in a contiguous block, Sheets may infer that block as the data range. That is convenient for a simple table, but a blank row, a second table beside it, or explanatory text above the records can affect the inferred range. Selecting the intended rectangle before creating the filter helps avoid applying it to the wrong area.

Include the column labels in the selected range. The labels help identify each filter menu, and the first row is treated as the header area for the filter. If the range starts on a data row instead, that row may be treated as the heading, making the menu labels confusing or leaving an actual header outside the filtered table.

Keep the table structurally consistent. A blank cell in an ordinary record is fine, but a completely blank row can split a dataset. Merged header cells and multiple header rows can also make filtering awkward. If the source sheet has decorative headings, totals, or notes, select only the actual data table rather than the entire worksheet.

Filter by values, conditions, and color

The filter menu offers different ways to define what should remain visible. Filtering by values is useful when a column contains a manageable set of categories. For example, choose only Completed in a Status column to hide other statuses. You can select or clear individual values, which is often the quickest option for a short list.

Filtering by condition is better when you want a rule rather than a hand-picked list. Depending on the data type and available options, you can set conditions such as text contains a word, a date falls within a period, or a number is greater than a threshold. If the data is inconsistent, such as amounts stored partly as text, a numeric condition may not behave as expected. Standardize the column’s values and formatting when results seem incomplete.

Filtering by color can help when cells or text have been color-coded, although color is a visual marker rather than a dependable replacement for a proper status field. If a workflow depends on categories, a column with explicit values such as Review, Approved, and On hold is clearer for collaborators and easier to filter consistently than color alone.

Regular filters versus filter views

A regular filter is useful when the whole editing group should work with the same filtered table. It is attached to the sheet’s data range, so changing its criteria can affect what other collaborators see. This makes it simple for a team to focus on one region or status, but it can be inconvenient if several people need different views at the same time.

A filter view lets a person create a separate saved view of the data without replacing the regular filter state for everyone else. To create one, use Data > Filter views > Create new filter view in Google Sheets. You can set its range and criteria, and give the view a useful name. Filter views are especially helpful for shared sheets where one colleague wants to examine overdue items while another reviews a different category.

Use the shortcut to toggle a regular filter; do not assume it creates a filter view. To work in a view, use the Filter views menu and select or create the appropriate view. If you do not see that menu option, check that you are editing a Google Sheets file in the browser and that your account has the needed access. Excel has its own filtering and view features, but its exact commands and collaboration behavior are not identical.

Common shortcut and filter problems

If the shortcut appears to do nothing, first click a cell in the sheet so that Sheets has focus. A browser extension, operating system setting, or browser command can sometimes capture a key combination. Try Data > Create a filter as a reliable alternative, and confirm that the correct range is selected.

If the filter icons appear over the wrong columns, turn the filter off and select the intended range, including its header row, before recreating it. Also inspect blank rows or columns that might divide the table. If a filter hides a row you expected to see, open the relevant column’s menu and check both the selected values and any active conditions. More than one column may have a criterion in effect.

If other people report that rows disappeared, ask whether a regular filter is active before assuming data was deleted. Clear the criteria or turn off the filter to restore the full display. For collaborative analysis, switching to a filter view can reduce disruption. If the shortcut works in one spreadsheet but not another, compare the selection, permissions, and whether the file is actually open in Google Sheets rather than a preview or another spreadsheet application.

Turning a filter off or clearing criteria

There are two related actions: clearing a column’s criteria and removing the filter control. To show all values in one column while keeping filter icons available, open that column’s menu and choose the option to clear its filter or select all values again. The wording can vary with the type of filter currently applied, but the goal is to remove that column’s restriction without dismantling the whole filter.

To remove the regular filter, click in its range and use Ctrl+Shift+L on Windows or ChromeOS, or ⌘+Shift+L on Mac. You can also choose Data > Remove filter when that command is available. Removing the filter restores the rows to view and removes the filter icons; it does not delete the table. For a filter view, close or exit that view using the controls in the filter-view bar rather than treating it as the regular filter.

Frequently Asked Questions

What is the filter shortcut in Google Sheets on Windows?
Use Ctrl+Shift+L with the spreadsheet active. It toggles a regular filter for the selected or inferred data range. If the shortcut is blocked, choose Data > Create a filter.

What is the Google Sheets filter shortcut on a Mac?
Use ⌘+Shift+L in Google Sheets in a browser. If your browser or another utility captures the combination, use the Data menu instead.

Does filtering delete rows in Google Sheets?
No. A filter hides rows that do not meet the selected criteria; the records stay in the sheet. Clear the criteria or remove the filter to show them again.

How do I filter without changing what collaborators see?
Use a filter view from Data > Filter views > Create new filter view. A regular filter can change the shared sheet’s visible state, while filter views support separate ways to inspect the same data.

Why is the filter shortcut not working?
Click inside the sheet first, check that you are using the shortcut for your operating system, and verify that the browser has not intercepted it. The menu command Data > Create a filter is the practical fallback.

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.