Google Sheets Filter Shortcut: Keys and Quick Tips

In Google Sheets in a web browser, press Ctrl+Shift+L on Windows or ChromeOS, or ⌘+Shift+L on a Mac, to create a filter for the selected data range. You can also choose Data > Create a filter; that menu path is the dependable option if the shortcut is intercepted or does not work.

The Google Sheets filter shortcut and what it does

The shortcut adds filter controls to the header row of a data range. Each header gets a small filter icon that opens options for showing or hiding rows, sorting the column, and setting conditions. The command does not add a formula, change the underlying cell contents, or permanently remove records. It changes which rows are visible in the sheet.

For the shortcut to be useful, first click a cell inside your table or select the range you want filtered. If you select a cell within a continuous block of data, Sheets will usually detect the surrounding range. Selecting the exact range is safer when there are notes, totals, or other content nearby that should not be included.

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

These are Google Sheets shortcuts, not browser-independent commands guaranteed to work in every setup. Browser extensions, keyboard layouts, remote desktop tools, or a browser-specific shortcut can sometimes intercept a key combination. If the command does nothing, use the menu or check Help > Keyboard shortcuts in Sheets. The shortcut list can also help confirm the current shortcut behavior for your account and platform.

Prepare the range before filtering

A filter is easiest to use when the data is organized as one rectangular table. Put one clear heading in each column’s first row, and keep each record on a single row. Avoid blank rows or blank columns inside the table: gaps can cause Sheets to detect only part of the data, leaving related values outside the filter.

For example, a simple order list might have columns for Order date, Customer, Region, Status, and Amount. Put those labels in row 1 and each order on its own row below. Click a cell in that table and create the filter. You should then see a filter control beside each heading. If your sheet has a title or explanatory note above the table, select only the actual header and data range so the note is not mistakenly treated as a column heading.

Use a single header row with distinct, meaningful labels.
Keep values of the same kind in the same column; mixing dates and comments can make conditions confusing.
Check for merged cells in the table. Merged cells can interfere with sorting and filtering, so unmerge them where possible.
Include the complete set of rows and columns, including new records, when creating the filter.

If the sheet has several separate tables, create a filter for one table at a time. A single filter range is not a good way to manage disconnected blocks of data. If you add rows beyond the range later and they do not receive filter controls, remove the filter and create it again with the larger range.

Filter by values or by a condition

Click a column’s filter icon to open its options. For a column with a manageable list of distinct entries, use Filter by values. You can select or clear individual values—for example, show only the West and Central regions, or show every order except those marked Complete. This is handy when the values are consistent and you know the exact label to look for.

Use Filter by condition when you need a rule rather than a list of specific entries. Available conditions depend on the type of data in the column. Text columns can be filtered by rules such as text contains or text starts with; number columns can be limited using comparisons such as greater than; dates can be restricted by date conditions. Conditions such as is empty or is not empty can help locate incomplete records.

For instance, in the order table, open the Amount filter and set a condition for values greater than a chosen threshold to focus on larger orders. Or filter the Status column by values to show only Pending orders. The filter applies to rows: when a row fails the chosen criteria, its other values are hidden along with it. This preserves the relationship between the customer, status, amount, and date in that record.

It is possible to filter more than one column at a time. If you filter Region to West and Status to Pending, the visible rows must meet both selections. To clear just one criterion, open that column’s filter menu and reset its selection or condition. To show all rows again, clear the applied filters or remove the filter range.

Filter views for shared spreadsheets

A regular filter changes the visible rows in the shared sheet for people working in that same sheet. That can be surprising in a team file: a colleague may open the sheet and see a narrowed list, or your change may alter what they are currently viewing. Coordinate before changing a shared table if other people rely on its current display.

When you want to sort or filter a shared sheet without disrupting other collaborators’ view, use a filter view. In the browser, choose Data > Filter views > Create new filter view. Set the range and criteria in the view, then give it a useful name, such as Pending orders or West region. A filter view lets you work with a filtered display while others can use the sheet separately.

Filter views are especially useful when different people need different slices of the same dataset, or when a team wants named views for recurring tasks. They are not a substitute for access controls: they do not hide sensitive data from people who can access the spreadsheet, and users with access may still be able to inspect the underlying records. Use sharing permissions, not filters, to control who can see information.

Sorting without scrambling your records

The filter menu also offers sorting options, usually ascending or descending for the selected column. Sorting while the table range is correctly included rearranges complete rows, keeping each record’s fields together. This makes it easy to sort dates from newest to oldest or amounts from highest to lowest.

The main risk is sorting only one column rather than the complete table. If names, dates, and amounts are sorted independently, records no longer match correctly. Before sorting, verify that the filter covers all the columns in the table and that the rows represent complete records. If you only need to view a subset without rearranging data, filter by values or conditions instead of sorting.

Filters and sorts can be combined, but remember that a sort changes row order while a filter only hides rows that do not match. Removing a filter restores hidden rows; it does not necessarily restore a previous sort order. If the original order matters, consider keeping a stable ID or date column that can be used to sort the records back into their intended sequence.

Common shortcut and filter problems

The shortcut does nothing: Confirm the spreadsheet is active, then try Data > Create a filter. Check the shortcut list under Help > Keyboard shortcuts, and consider whether the browser or an extension is capturing the keys.
Only part of the table gets filter icons: The selected range may be too small, or a blank row or column may have interrupted automatic range detection. Remove the filter and select the entire table before creating it again.
The header row is treated as data: When creating the filter, include the actual heading row at the top of the selected range. If the selected range starts on a data row, Sheets cannot identify the intended labels automatically.
Some expected values are missing from the menu: Check for extra spaces, inconsistent spelling, different date formats, or values outside the filter range. For example, Open and Open followed by a space may appear as separate entries.
Rows seem to have disappeared: A filter hides rows that do not match; it does not delete them. Open the relevant filter menu and clear its criteria, or remove the filter to reveal the complete range.

Also consider whether another collaborator has applied a filter to the shared sheet. If a regular filter is active, its settings can affect the shared view. For personal exploration in a collaborative file, create a filter view instead of repeatedly changing the main filter.

Filter shortcut compared with other options

For ordinary lists, the shortcut is the fastest way to add filter controls. The menu command is easier to find and works well when you need to confirm what action is being taken. Filter views are the better choice when you need a named, separate view or want to avoid changing the shared display.

Google Sheets also has a FILTER function for returning matching data into another area of a sheet. Unlike the menu filter, a function creates a result from conditions and can be useful for a live report or a separate summary. The menu filter is generally more convenient for inspecting and sorting the original table; the function is more suitable when the output itself needs to appear elsewhere or feed another calculation.

Excel for Windows also uses Ctrl+Shift+L for its Filter command, but the surrounding menus and collaboration features differ. Google Sheets filter views are a Sheets feature and should not be assumed to behave exactly like Excel’s filtering or sheet-view tools. If you move a workbook between the programs, check the filter setup and shared-view behavior in the destination app.

Frequently Asked Questions

What is the keyboard shortcut to filter in Google Sheets?

Use Ctrl+Shift+L on Windows or ChromeOS, or ⌘+Shift+L on a Mac, to create a filter for the selected data range. If it does not work, choose Data > Create a filter.

How do I turn off a filter in Google Sheets?

To remove the filter controls, choose Data > Remove filter. If you only want to see all rows while keeping the filter available, clear the active selections or conditions in the filter menus instead.

Does filtering delete rows in Google Sheets?

No. A filter hides rows that do not match the selected values or conditions. Clear the criteria or remove the filter to show those rows again; filtering does not erase their contents.

Can I filter by more than one column?

Yes. Apply a criterion in one column, then open another column’s filter menu and add a second criterion. The visible records must satisfy the active filters together.

Will a filter affect other people in a shared spreadsheet?

A regular filter changes the shared sheet’s displayed rows, so collaborators may be affected. Use Data > Filter views > Create new filter view when you need a separate view for your own filtering and sorting.

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.