In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn filter buttons on or off for a data range. To open a filter menu after the buttons appear, select a cell in that column’s header and press Alt+Down Arrow.
The shortcut and what it does
Ctrl+Shift+L is a toggle: press it once to add AutoFilter buttons to the header row of the current data range, and press it again to remove those buttons. The small arrows or filter icons appear beside the column headings. They let you choose which rows to display without deleting the underlying data.
For example, suppose a worksheet has a table with columns named Date, Region, and Sales. Click a cell in that data, then press Ctrl+Shift+L. Excel adds filter controls to the headings. You can then use the Region control to show only East, or the Sales control to display values above a chosen amount. Rows that do not match are temporarily hidden; they remain in the worksheet.
The shortcut concerns the filter controls, not a particular filtering condition. It does not automatically sort the data, search for a value, or choose criteria. Those actions happen from an individual column’s menu after filtering is enabled.
How to apply it to a worksheet range
For a reliable result, use a simple rectangular dataset with one heading row and no completely blank row or column dividing the records. Click any cell inside the data, then press Ctrl+Shift+L. Excel usually recognizes the contiguous data region and applies filter buttons to its headings. If the sheet contains nearby unrelated cells, select the exact range—including the headings—before using the shortcut so Excel does not guess the wrong region.
- Check that each column has a distinct, descriptive heading, such as Product, Date, or Status.
- Click inside the dataset, or select the intended rectangular range including its header row.
- Press Ctrl+Shift+L. Confirm that a drop-down control appears beside each heading.
- Open a column’s control and choose the values or conditions you want to display.
A header row matters because Excel needs to identify which fields each filter belongs to. If the selection has no headings, Excel may treat the first row of records as headings. That can make the first record seem to disappear into the header area. Avoid merged cells in the header, and keep headings in a single row where possible.
Opening a column’s filter menu
Once the filter arrows are visible, click a cell in the header for the column you want to filter and press Alt+Down Arrow. This opens that column’s filter menu in Excel for Windows. You can also click the arrow with the mouse. Press Esc to close the menu without applying a new choice.
The menu contents depend on the kind of data in the column. A text column commonly shows a search box, a list of distinct values, and text-filter options. A date column can offer date-specific choices, while a number column can show number filters. The list of values is useful for quick selections, but a condition such as “greater than” can be more practical when the dataset contains many different numbers.
Keyboard access is helpful when you are moving through a large sheet without a mouse. First move to the relevant header, then use Alt+Down Arrow. Use the arrow keys and Tab to move through available controls; the exact focus sequence can vary with the menu and Excel build. If the menu does not open, check that the active cell is in a header with a filter button rather than in an ordinary data cell.
Choosing useful filter criteria
Filtering is most useful when you want to narrow a list temporarily while keeping all records available. The simplest approach is to open a column menu, clear or select checkboxes for specific values, and confirm the selection. The search box in the menu can help locate a value in a long list; it does not change the source data.
- Show selected labels: In a Status column, select Open and leave Closed unchecked to see unresolved items.
- Match a text pattern: Use text-filter options when you need entries that begin with, contain, or do not contain particular text.
- Set a numeric condition: In a Quantity column, use a number condition such as greater than a threshold instead of ticking many individual values.
- Narrow dates: Use the date choices to focus on a period, such as a particular month or year, when Excel recognizes the values as dates.
You can filter more than one column at the same time. For example, filter Region to East and Status to Open. Excel displays rows that meet both active column filters. This is an AND relationship across columns: a row must satisfy the Region selection and the Status selection to remain visible. Within a column, selecting several listed values generally shows rows matching any of those selected values.
Turning filters off versus clearing results
Pressing Ctrl+Shift+L again removes the filter buttons from the range. It is not the same as clearing the criteria in one column. If you want the arrows to remain but need to show all records again, open the relevant column menu and choose its clear-filter command. To clear filters across the range, use Data > Sort & Filter > Clear. The command clears filtering criteria; the filter controls remain available.
This distinction prevents a common surprise. If you used the shortcut to hide the arrows, the filtered rows are not necessarily restored just because the controls disappeared. To return to an unfiltered view before switching AutoFilter off, clear the active criteria first. In a filtered range, Excel’s row numbers may skip values because some rows are hidden. That is normal and does not mean those records were erased.
Using filters in an Excel table
An Excel Table already includes filter buttons in its header row by default. To create one, select the data and choose Insert > Table, or use Ctrl+T, then confirm whether the range has headers. A table expands more naturally when you add rows, and its filter controls stay associated with the named table columns. This can be more convenient than applying AutoFilter to a plain range that changes size over time.
If a table’s filter buttons are missing, check the table settings rather than assuming the shortcut is broken. Select a cell in the table and look for the Table Design tab; the Filter Button option controls whether those arrows are shown. The tab name and ribbon layout can vary somewhat by Excel update. For a plain range, Data > Filter is the ribbon route that corresponds to turning AutoFilter on or off.
Tables do not change what filtering means: matching rows remain visible and other rows are hidden. They do, however, provide a structured range that can be easier to maintain when records are added. If you have a carefully formatted report or a range with special layout rows, converting it to a table may alter formatting or structure, so consider whether a plain filtered range better suits the sheet.
Common problems and quick checks
If Ctrl+Shift+L seems to do nothing, first click a cell in the intended dataset and try again. A selection outside the data, a protected sheet, or a range with an unexpected blank break can affect what Excel applies. Also look closely at the header row: filter arrows may already be enabled, or the button may be narrow because the column is too small.
- The wrong cells get filter arrows: Select the exact range, including its headers, and use Data > Filter.
- The first record appears to be a heading: Check that the selection included the actual header row and that Excel recognized it correctly.
- The menu has unexpected choices: Check the source values for inconsistent data types, such as numbers stored as text or dates entered as text.
- Some records seem missing: Clear the active filters and check whether rows are hidden manually or by another filter.
- The shortcut opens something else: Check that Excel has focus and that no add-in, keyboard utility, or system-level shortcut is intercepting the keys.
Mixed data types can be especially confusing. If a date column contains genuine Excel dates alongside text that merely looks like dates, the filter menu may group or list entries differently than expected. Consistent source data makes date and number filters more predictable. If a workbook is shared, also remember that a saved filtered view can affect what another person sees when they open it.
Windows, Mac, and Excel for the web
The main instructions here are for Excel for Microsoft 365 on Windows: Ctrl+Shift+L toggles AutoFilter, and Alt+Down Arrow opens the active header’s menu. In Excel for Mac, the AutoFilter toggle is commonly Command+Shift+F; shortcut behavior can depend on the keyboard layout and Excel version. The ribbon alternative is Data > Filter. For the Mac filter menu, use the header’s drop-down button if a keyboard command is not available or differs on your setup.
Excel for the web may have different shortcut behavior depending on the browser and keyboard. When in doubt, use Data > Filter in the ribbon, then click a header’s filter button. This menu path is also a useful fallback on Windows if a shortcut is intercepted by another program. The filter feature itself is designed to work with worksheet ranges and tables, though the exact ribbon presentation can vary between desktop and browser versions.
Frequently Asked Questions
What is the shortcut to turn on filters in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L while a cell in the data range is selected. Press it again to toggle the filter buttons off.
How do I open the filter drop-down with a keyboard?
Select a cell in the column heading that has a filter button, then press Alt+Down Arrow in Excel for Windows. The drop-down menu opens for that column.
Does Ctrl+Shift+L delete rows that do not match?
No. Filtering hides nonmatching rows from view; it does not delete them. Clear the filter to show the records again.
Why can’t I see the filter arrows?
AutoFilter may be off, the selected range may not include the intended heading row, or the data may be an Excel Table whose Filter Button setting is disabled. Try Data > Filter for a plain range, or check Table Design for a table.
How do I remove a filter but keep the arrows?
Open the filtered column’s menu and choose its clear-filter command, or use Data > Sort & Filter > Clear to clear the range’s criteria. Do not press Ctrl+Shift+L if you want to keep the controls visible.
What is the Excel filter shortcut on a Mac?
Command+Shift+F is commonly used to toggle AutoFilter in Excel for Mac. If it does not work in your version or keyboard layout, choose Data > Filter or use the header’s drop-down button.
Related
- Excel Repair Tools for XLS and XLSX Files: What Works
- Excel Remove Text and Keep Numbers in a Cell
- Excel Remove Numbers From Cells and Keep Text Easily
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- How to Add Double Quotes in an Excel Formula for TextTo show double quotation marks in text produced by an Excel formula, type each quote mark twice inside…
- IFERROR vs ISERROR: Which Excel Function Should You Use?IFERROR catches an error produced by a calculation and returns a replacement value; ISERROR checks whether a value…
- Excel VLOOKUP Column Index Number ExplainedIn Excel VLOOKUP, the column index number tells Excel which column to return a value from, counting from…
- How to Delete an Array Formula in Excel Without ErrorsTo delete an array in Excel, remove its formula: select the entire output range for a legacy array…
- Excel MONTH Function: Extract the Month from a DateTo get the month number from a date in Excel, enter =MONTH(A2) in another cell, assuming A2 contains…
- VLOOKUP Showing Formula? Causes and Fixes in ExcelIf VLOOKUP is showing as text instead of returning a result, first turn off Formulas > Show Formulas;…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.