Google Sheets Filter Shortcut: Apply a Filter Fast

In Google Sheets in a web browser, press Ctrl+Shift+L on Windows, Linux, or ChromeOS to create a filter; on a Mac, press Command+Shift+L. Select your data first if you want to control the exact range, then use the filter buttons in the header row to show only the records you need.

What the Google Sheets filter shortcut does

The shortcut adds filter controls to a selected data range, or to a range Sheets identifies around the active cell. Filter controls appear as small funnel icons in the header row. Clicking one lets you sort that column or set criteria for which rows to display. For example, a sales list could be filtered to show orders from one region, or only orders marked Pending.

A filter changes which rows are visible; it does not erase the rows that fail the criteria. Clear or remove the filter and those rows can be displayed again. This is useful for inspecting a subset of a table without making a separate copy or changing the underlying values.

The shortcut is a quick route to the same basic command found at Data > Create a filter. It does not decide what should be filtered for you: after creating the filter, choose a column and set the condition or values you want to include.

Apply a filter step by step

For a predictable result, include a clear header row and select the complete table before creating the filter. A simple workflow is:

Open the spreadsheet and identify the contiguous table you want to inspect, including its column headings.
Select the table range, or click a cell inside it if the table is clearly separated from other data.
Press Ctrl+Shift+L on Windows, Linux, or ChromeOS, or Command+Shift+L on Mac. Alternatively, choose Data > Create a filter.
Check that the funnel icons appear in the intended header cells. Click the icon for the column you want to filter.
Choose values to show, or use a condition such as text contains, date is before, or number is greater than. Apply the selection in the filter menu.

For example, suppose a table has Date, Region, Product, and Status columns. To review only open orders from the North region, use the Region filter to keep North and the Status filter to keep Open. Both criteria can be active at once, so the displayed rows must meet both conditions. Clear one criterion when you want to broaden the results.

Choose the right data range and headers

Filters work best on a rectangular table: one header row followed by records, with each column representing one kind of information. If the table begins in A1 and ends in D200, selecting A1:D200 before using the shortcut makes the intended scope explicit. Avoid including unrelated notes, totals, or a second table beside or below the records.

Blank rows inside a dataset can make it harder for Sheets to recognize the full range, and blank header cells make filter controls less understandable. If a filter appears on only part of the table, remove it and select the complete range, including all headers and data rows, before choosing Data > Create a filter again.

Keep each record on one row and use one heading per column, such as Date, Region, and Amount. Merged cells and multiple heading rows can make sorting and filtering confusing. If a heading needs a subtitle or explanation, place it outside the filter range rather than combining it with the column name.

Use the filter menu to find and sort records

Each funnel menu provides controls for that column. Depending on the data, you can select particular values, search the list of values, or specify a condition. A text condition might display entries that contain a word; a numeric condition might display amounts above a threshold; and a date condition can limit the rows to a time period. The condition choices depend on the type of information in the column.

Filtering and sorting are related but different. A filter hides rows that do not match your criteria. Sorting changes the order of rows that remain visible, such as arranging dates from newest to oldest. Sorting within a filtered table can help locate an item, but it does not make the other rows disappear permanently.

To return to the full table while keeping the filter setup, clear the selected values or criteria in the relevant filter menu. To remove the filter controls from the range, choose Data > Remove filter. Removing a filter is not the same as deleting filtered-out records.

Regular filters and filter views

A regular filter is appropriate when you are working with a table on your own or when collaborators should share the same visible filtering state. In a shared spreadsheet, a change to a regular filter can affect what other editors see, so coordinate before changing it in a team’s working sheet.

For personal or saved ways to inspect a shared table, use a filter view. Filter views let a person apply a different set of filtering and sorting choices without changing the ordinary filter state for everyone else. They can also be named so the view can be reopened later. To create one, use Data > Filter views > Create new filter view, then adjust the filter controls while the view is active.

Use a filter view when several people need to examine the same source data differently—for example, one person may want to see open orders while another reviews completed orders. It is still the same spreadsheet data, not a private copy. Check which view is active before interpreting a filtered table or sharing a link to it.

Common shortcut and filter problems

The shortcut does nothing: Confirm that the spreadsheet has focus and that you are using the browser version of Google Sheets. Keyboard layouts, browser behavior, and operating-system settings can affect shortcuts. Use Data > Create a filter as a reliable menu alternative.
Filter icons appear in the wrong place: The selected or detected range may include extra cells or stop too early. Remove the filter, select the intended rectangular table, and create it again.
Some expected records are missing: Check every column’s active criteria, not just the one you most recently changed. Multiple column filters are combined, so a row must satisfy all active criteria to remain visible.
Rows seem to have vanished: They are likely hidden by a filter rather than deleted. Clear the criteria or remove the filter and check whether they return.
Sorting scrambles the table: Make sure the filter range covers every column belonging to the records. If only one column is selected or included, sorting it independently can separate values from the other fields in each record.

If the data changes frequently, recheck the filter range after adding rows outside its original boundaries. Adding new records directly below a table may be handled as part of the range in many cases, but explicitly extending or recreating the filter is safer when the new rows are not included in its controls.

How Sheets differs from Excel

The shortcut resembles the AutoFilter shortcut in desktop Excel for Windows, but the applications have distinct menus and behavior. In Google Sheets, the relevant menu command is Data > Create a filter, and the instructions here refer to Sheets in a web browser. Excel uses its own Data tab and filter controls; do not assume a Sheets menu path applies there. Shortcut behavior can also depend on the operating system and app version, so use the application’s menu when working across programs.

In Sheets, remember the distinction between a regular filter and a filter view when collaborating. That choice matters more than the shortcut itself: the keyboard command helps you create the controls, while the type of filter determines how the resulting view is shared.

Frequently Asked Questions

What is the shortcut to apply a filter in Google Sheets?

Use Ctrl+Shift+L on Windows, Linux, or ChromeOS. On a Mac, use Command+Shift+L. The shortcut creates filter controls for the selected or detected data range.

How do I turn off a filter in Google Sheets?

Choose Data > Remove filter to remove the filter controls from the range. If you only want to see rows hidden by a criterion, clear that criterion in the relevant funnel menu instead.

Does filtering delete rows in Google Sheets?

No. A filter hides rows that do not meet the active criteria; it does not delete their contents. Clear the criteria or remove the filter to show the rows again.

Can I filter more than one column at a time?

Yes. Set criteria in multiple column menus. Sheets displays rows that match all the active column filters, which lets you combine conditions such as a region and an order status.

Can I filter a shared Google Sheet without changing what others see?

Use a filter view for an individual or named view of the data. A regular filter changes the shared filter state and may change the visible rows for collaborators.

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.