In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off for a data range. To open a filter menu that is already showing, select a cell in its header and press Alt+Down Arrow.
The two shortcuts people mean by “open filter”
“Open filter” can describe two different actions. Ctrl+Shift+L adds or removes the filter drop-down arrows on a selected data range; it does not, by itself, open one of those menus. Alt+Down Arrow opens the menu for the filter field associated with the current cell, provided that cell is in a filtered header.
This difference matters when a shortcut seems not to work. If your column headings have no arrows, use Ctrl+Shift+L first. If the arrows are visible and you want to choose a value, select the appropriate heading and use Alt+Down Arrow. In an Excel table, the filter arrows are usually present by default, so opening a particular menu is often the step you need.
- Turn filter buttons on or off: Ctrl+Shift+L on Windows.
- Open a filter menu: Alt+Down Arrow on Windows, with the relevant header cell selected.
- Choose an item in the open menu: Use the arrow keys, then press Enter to apply a selection.
What Ctrl+Shift+L does
AutoFilter adds small drop-down buttons to the header cells of a list or table. Each button opens options for filtering or sorting that column. Pressing Ctrl+Shift+L toggles those buttons for the current data region or selected range. If filtering is already enabled, the shortcut turns it off; press it again to restore the buttons.
When you apply a filter, Excel hides rows that do not meet the chosen condition. It does not delete those rows or move matching records into a separate place. For example, filtering a Status column to show “Open” leaves the other records in the worksheet but temporarily hides them from view. Clearing the filter makes the hidden records visible again.
The shortcut is useful because it works without navigating the ribbon. It is also a toggle, not a command to choose a particular criterion. You still need to open a column’s menu and select values, a text or number condition, or another available filter option.
Apply filters to a worksheet range
For a reliable result, use a simple rectangular data range with one header row and a consistent field in each column. Click inside the data, then press Ctrl+Shift+L. Excel generally detects the contiguous region around the active cell and places filter buttons in its header row. If the data is separated by blank rows or columns, Excel may identify only part of it, so selecting the full range first can help.
- Check that each column has a descriptive heading, such as Date, Region, or Amount.
- Click a cell in the data, or select the entire range including its headers.
- Press Ctrl+Shift+L. Check that the drop-down buttons appear in the header cells.
- Click a header button, or select that header cell and press Alt+Down Arrow.
- Choose the filter you need, then press Enter or confirm the selection in the menu.
For instance, a sales list might have columns for Date, Region, Product, and Revenue. Opening the Region menu lets you show only records for North. You can then open Product and choose one product as well. The resulting view contains rows that meet both active column filters, which is useful for narrowing a list without changing the underlying entries.
Open and use a filter drop-down menu
To use the keyboard after filter arrows are visible, move to a cell in the column heading you want to filter and press Alt+Down Arrow. The menu offers options that depend on the column’s contents. A column containing text commonly offers choices for individual text values and text filters; a column containing numbers or dates offers relevant number or date filtering choices.
Once the menu is open, use the arrow keys and Enter to navigate and confirm. The exact controls depend on the menu option you choose. For a list of values, the check boxes let you include or exclude specific entries; the search box can help locate a value in a long list. If you want to show every value again, use the menu’s clear-filter option for that column, or use the relevant clear command on the Data tab.
Filtering and sorting are separate operations even though both appear in the same menu. Sorting changes the order of visible records. Filtering hides rows that do not match. A filter can remain active while you sort the remaining visible rows, so check the header icons if a list appears incomplete.
Use the ribbon when the shortcut is unavailable
The equivalent ribbon command in Excel for Windows is Data > Filter. Click a cell in the data or select the range, then choose that command to toggle filter buttons. You can also use the command when you prefer menus, when a keyboard shortcut is intercepted, or when showing someone else where the feature is located.
The Home tab also includes sorting and filtering commands, but Data > Filter is the direct route for turning AutoFilter buttons on or off. Ribbon labels and layout can vary slightly with window size or interface customization. If you do not see the command immediately, look on the Data tab for the Filter control rather than assuming filtering is missing.
The ribbon route and shortcut do the same basic toggle; neither is a substitute for selecting a criterion in a column. After enabling filters, open the relevant header menu to decide which records should remain visible.
Filter ranges, Excel tables, and headers
Excel tables and ordinary worksheet ranges both support filter menus, but their setup differs. When you create a table using Insert > Table or Home > Format as Table, Excel normally includes filter buttons in the header row. A table also expands as you add data directly beneath it and can carry its formatting and formulas into new rows. For a table, you may not need Ctrl+Shift+L just to get started; use the existing header buttons.
An ordinary range does not gain the same table structure. Ctrl+Shift+L turns on filtering for the selected or detected region, but it is still important to keep the range organized. Avoid blank header cells, duplicate or unclear headings, and stray data immediately beside the list, since these can make the detected region confusing or difficult to filter accurately.
Do not include a separate title row above the actual column headings unless you intend it to be part of the range. Filter buttons belong in the field-name row, not in a decorative title. If Excel places them on the wrong row, turn filtering off, select the correct range including its real headers, and turn it back on.
Common problems and quick fixes
If Ctrl+Shift+L appears to do nothing, start by checking where the active cell is. It should be inside the list, or the complete range should be selected. A selection outside the data may cause Excel to apply filtering to another region or fail to produce the expected header buttons. Also confirm that the data has a header row and is not split into unrelated blocks by blank rows or columns.
- The arrows are visible, but no menu opens: Select a header cell first, then press Alt+Down Arrow. The shortcut opens the menu for the current field; it is not the same as toggling filters.
- Only part of the data gets filter buttons: Select the intended full range, including the headers, and use Data > Filter or Ctrl+Shift+L again as appropriate.
- Some rows seem to have vanished: Look for active filter indicators in the headers. Clear the relevant filter to show excluded rows; filtering hides records rather than deleting them.
- The menu does not show the values you expect: Check for inconsistent entries, extra spaces, or mixed data types in the column. Text that looks alike may not be identical to Excel, and dates or numbers stored as text can behave differently.
- The shortcut triggers another feature: Check the keyboard layout, any system-level shortcut utility, and whether a remote desktop or browser is capturing the keys. Use Data > Filter as a fallback.
One common misconception is that removing the filter arrows necessarily removes the filter criteria. The shortcut toggles filter controls, and turning filtering off can clear the current AutoFilter setup. If you need to preserve a particular view, be cautious about toggling it off; clearing a column’s criteria from its menu is usually the more direct way to show all records while keeping the filter controls available.
Shortcuts on Mac and Excel for the web
On Excel for Mac, Command+Shift+F is a common shortcut for turning AutoFilter on or off; some keyboard configurations also support Control+Shift+L. To open the menu for a filtered header, use Option+Down Arrow. If a shortcut differs on your Mac, use the Data tab’s Filter command, since keyboard behavior can depend on the keyboard and Excel configuration.
Excel for the web runs in a browser, so browser shortcuts and keyboard settings can affect what reaches the spreadsheet. The ribbon’s Data > Filter command is a practical alternative if the desktop shortcut does not behave as expected. In any version, distinguish enabling the arrows from opening a specific column menu; that distinction is the key to choosing the right action.
Frequently Asked Questions
What is the Excel shortcut to turn on filters?
In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L. It toggles AutoFilter buttons on or off for the current data range or selection.
How do I open a filter menu with the keyboard?
With filter buttons already visible, select a cell in the relevant column heading and press Alt+Down Arrow. Use the arrow keys to navigate the menu.
Does Ctrl+Shift+L open the filter drop-down?
No. It turns filter buttons on or off. To open a particular drop-down menu on Windows, select its header cell and press Alt+Down Arrow.
How do I remove a filter but keep all my data?
Use the header menu’s clear-filter option, or use the clear filtering command on the Data tab. Filtered-out rows are hidden, not deleted, and clearing the criteria shows them again.
What is the filter shortcut on a Mac?
Command+Shift+F is commonly used to toggle AutoFilter in Excel for Mac, and some setups support Control+Shift+L. Option+Down Arrow opens a filter menu from its header; the Data tab is an alternative.
Why does my filter show only some rows?
An active filter may be hiding rows that do not meet its criteria. Check each filtered column and clear the criteria to display all records. Also confirm that the intended data range was included when filtering was enabled.
A quick way to remember the difference
Think of Ctrl+Shift+L as the switch that shows or hides the filter controls, and Alt+Down Arrow as the action that opens one control’s menu. For a standard Windows workflow, click in the list, press Ctrl+Shift+L if the arrows are missing, then select the desired header and press Alt+Down Arrow to choose what to show. Use Data > Filter whenever you would rather use the ribbon or the keyboard shortcut is unavailable.
Related
- Excel General Number Format: How It Works and When to Use It
- Excel Number Format: How Many Digits Can It Really Show?
- Excel Formatting Keyboard Shortcuts: A Practical Guide
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Goal Seek Formula Alternatives That WorkExcel does not have a worksheet function called GOALSEEK; Goal Seek is a What-If Analysis command. The formula…
- Excel NPV of a Series of Cash Flows: Formula and ExamplesTo calculate the net present value of a cash-flow series in Excel, use =NPV(B1,B3:B5)+B2 when the discount rate…
- SUMIF Criteria Examples: Text, Dates, Numbers, and MoreIn Excel, SUMIF adds values that match one condition; for example, with categories in A2:A7 and amounts in…
- Excel Text Handling: Formulas, Formatting, and FixesExcel text handling means entering, cleaning, combining, splitting, and displaying text without accidentally changing its meaning. In Microsoft…
- How to Split Cell Data in Excel: Text to Columns & FormulasTo split cell data in Excel, select the cells, choose Data > Text to Columns, pick Delimited or…
- Excel Formula for Workdays Between Dates: NETWORKDAYSUse Excel’s NETWORKDAYS function to count Monday-to-Friday workdays between two dates, optionally excluding holidays: =NETWORKDAYS(start_date,end_date,[holidays]). It counts both…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.