To turn filters on or off in Excel for Microsoft 365 on Windows, select a cell in your data and press Ctrl+Shift+L. To open a specific column’s filter menu after the arrows appear, select its header cell and press Alt+Down Arrow. Your data should have a header row so each filter menu is tied to the right column.
These are two different actions: the first adds or removes filter arrows across a range, while the second opens the menu for one column. From that menu, you can narrow the rows shown, sort values, or clear a filter. The steps below cover keyboard use, the ribbon alternative, and what to check if the shortcut seems to do nothing.
What You’ll Need
- Excel for Microsoft 365 on Windows, or Excel for Mac if you are using the Mac-specific shortcut below.
- A worksheet range with one clear header row and data underneath. A formatted Excel table also works.
- Permission to edit the workbook. If the sheet is protected or opened read-only, Excel may prevent you from changing filter settings.
- A keyboard. On a laptop, you may need to hold the
Fnkey for certain keyboard functions, but the filter shortcuts normally use the regular letter and arrow keys.
Step-by-Step
- Check that your data has headers. Look at the first row of the data you want to filter. Each column should have one descriptive heading, such as Date, Product, or Region. Avoid blank header cells and merged header cells: they can make filter controls confusing or prevent Excel from treating the range as a clean list. If your data has a title above the headers, do not include that title as part of the filtered range.
- Place the active cell inside the data. Click any cell in the range, such as a value under the Product heading. You usually do not need to select every row and column first. Excel detects the contiguous block of data around the active cell when you use the shortcut. If there are blank rows or columns splitting the data, select the exact range, including the headers, before proceeding so Excel does not stop at the gap or include an unrelated block.
- Turn on the filter arrows. On Windows, press
Ctrl+Shift+L. Excel adds a small drop-down arrow to each header in the detected range. If arrows were already present, the shortcut toggles AutoFilter off, removing the arrows and any active filter criteria. It does not delete your records, but turning filtering off removes the current filtering view, so check first if you need to preserve which values are being shown. - Use the ribbon if the shortcut is unavailable. Select a cell in the data, choose Data > Filter on the ribbon, and check whether the header arrows appear. This is also a useful way to confirm that the shortcut was intercepted by a laptop setting, remote desktop, or browser rather than by Excel. The same command can turn filtering off when it is already on.
- Open the menu for the column you want. Move the active cell to that column’s header cell. For example, if you want to filter a Region column, select the cell containing the Region heading, then press
Alt+Down Arrow. Excel opens that column’s filter menu. You can also click its arrow with the mouse; using the keyboard shortcut is helpful when you want to stay on the keyboard. - Move through the menu and choose a filter. Use the arrow keys and
Tabto move between the available controls. In a list of values, use the space bar to toggle a highlighted check box, and pressEnterto apply your choices. Depending on the menu and your selection, you can also use the search field to find a value, or choose a text, number, or date filter option. Read the menu labels before applying a condition, especially when the column contains mixed types of data. - Confirm the result in the worksheet. After applying a filter, Excel hides rows that do not match; it does not remove them. The filter arrow may show a filter indicator, and the row numbers may skip values because some rows are hidden. Check a few visible records to make sure they meet your intended condition. If the result is not right, reopen the same header menu and adjust the selected values or condition.
- Clear a filter without removing the arrows. Open the relevant header menu and choose Clear Filter From followed by the column name, when that option is available. To clear active filters across the worksheet range while keeping filtering available, use Data > Clear. To remove the filter arrows themselves, use
Ctrl+Shift+Lor Data > Filter again. Clearing criteria and switching AutoFilter off are not the same operation. - On a Mac, use the Mac shortcut or ribbon. In Excel for Mac, try
Command+Shift+Fto toggle filters. To open the selected header’s menu, useOption+Down Arrowwhere supported by your keyboard setup. If a shortcut conflicts with macOS or does not respond, use Data > Filter to turn filtering on, then click the header arrow to open its menu. In Excel for the web, keyboard behavior can depend on the browser, so the Data tab is a reliable alternative.
Common Mistakes
Using the toggle shortcut when you mean to open a menu. Ctrl+Shift+L turns filtering on or off; it does not open an individual column’s list. Once the arrows are visible, select the appropriate header and use Alt+Down Arrow on Windows. This distinction prevents accidentally switching the filters off while trying to choose a value.
Selecting a title row instead of the actual headers. If a report title sits above the headings, clicking the title and toggling filtering can cause Excel to treat the wrong row as the header. Start inside the data block, or select the header row and its records explicitly. A properly formatted Excel table can make the intended headers clearer.
Including blank or unrelated cells. A blank row in the middle of a list may cause Excel to detect only part of the data. A separate note or total below the list may get included if the range is selected too broadly. Check the arrows and visible rows, and select only the complete data range when automatic detection is not suitable.
Expecting filtered-out records to be deleted. Filtering only hides nonmatching rows. If you copy or edit visible results, take care not to assume hidden rows are gone. Likewise, switching filtering off brings the rows back; it does not undo edits made while the filter was active.
Filtering a column with inconsistent data. Dates stored as text, numbers mixed with words, and extra spaces can cause values to appear unexpectedly or make the menu options differ. Standardize the source values where possible before relying on a complex filter.
Tips
- Convert a regular list to a table when it is an ongoing dataset. Select a cell in the range and choose Insert > Table. Confirm that the range includes the header row and that My table has headers is selected. Tables provide header filter controls and expand as you add data beneath them.
- Use the filter menu search box for long lists. Instead of scrolling through hundreds of distinct entries, move to the search field in the menu, type a distinctive part of the value, and select the matching item. Clear the search text if you want the full list of values to appear again before making a different selection.
- Use filter types that match the column. For a text column, options such as Begins With or Contains may be useful. For numeric or date columns, choose the corresponding number or date conditions. A simple checklist is best when you want a few exact items; a condition is often clearer when you need a range, such as dates after a cutoff.
- Keep the header row visible when working far down a sheet. You can use View > Freeze Panes > Freeze Top Row if the headers are on the first worksheet row. Otherwise, select the row below your headers and use View > Freeze Panes > Freeze Panes. This does not change filtering, but it helps you keep column names in view.
- Remember the keyboard focus. A shortcut acts on Excel’s current selection, not necessarily the cell you last intended to use. Click a cell in the correct data range before toggling filters, and select the correct heading before opening its menu. This matters especially after typing in the formula bar or switching between worksheet windows.
Troubleshooting
The shortcut does nothing. First click a worksheet cell rather than a ribbon control, dialog box, or formula bar. Then try Data > Filter. If the ribbon command works, another app, browser, remote desktop, or keyboard utility may be capturing the shortcut. On a laptop, check whether an Fn key is needed for the key combination. In Excel for the web, use the ribbon if the browser handles the keystroke differently.
No arrows appear on every expected column. Check whether the active cell was inside the whole data block and whether a blank row or column divides it. Select the full intended range, including its headings, and choose Data > Filter again. Also check for merged cells or blank header names. If the range is an Excel table, make sure the table itself includes the columns you expect to filter.
Pressing Alt+Down Arrow opens the wrong thing. Confirm that the selected cell is a header cell with a filter arrow, not a regular worksheet cell with another kind of drop-down list. If the filter menu still does not open, click the arrow directly. On a Mac, try the Mac-specific key combination or use the arrow because keyboard behavior varies by setup.
Rows seem to be missing after filtering. Look for a filter indicator on the column arrow, then open that menu and clear its condition. Also check other columns: filters can be active in more than one column at the same time, and each condition narrows the results further. Choose Data > Clear to remove active filter criteria across the range without turning off the filter arrows.
The Filter command is unavailable. Check whether the worksheet is protected, whether you have editing access, or whether Excel is displaying a dialog that needs to be closed first. If the workbook is in a shared or restricted state, ask the owner for permission or work in an editable copy. Avoid changing protection settings unless you are authorized to do so.
Frequently Asked Questions
What is the keyboard shortcut to turn on filters in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L with a cell in the data range selected. It toggles AutoFilter on or off.
How do I open a filter drop-down using the keyboard?
Select the header cell that has the filter arrow and press Alt+Down Arrow on Windows. On Mac, Option+Down Arrow may open the menu; clicking the arrow is the fallback.
Does Ctrl+Shift+L remove my data?
No. It toggles the filter controls. Turning filtering off removes the current filtered view, but it does not delete the underlying rows.
Can I filter without a header row?
It is best to add a clear header row first. Excel uses the headings to label each column’s menu, and blank or merged headings can lead to confusing results or an incorrectly detected range.
Why are some records still hidden after I clear one column’s filter?
Another column may still have an active condition. Clear that column’s filter too, or use Data > Clear to clear active criteria for the range.
Does the shortcut work in Excel for the web?
Keyboard support can depend on the browser and operating system. Try Ctrl+Shift+L, but use Data > Filter if the browser intercepts the keys or the shortcut does not respond.
Related
- How to Move Cells in Excel Without Overwriting Data
- Merge Names in Excel from 3 Cells
- How to Merge Rows in Excel and Keep All of Your Data
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula for Exact Match: XLOOKUP and MATCHWith the value to find in E2, lookup values in A2:A6, and results in B2:B6, use =XLOOKUP(E2,A2:A6,B2:B6,"Not found",0)…
- COUNTIF Excel Not Equal: Formulas, Blanks, and ExamplesTo count cells that are not equal to a value in Excel, use =COUNTIF(A2:A20,"<>Apple"). The <> operator means…
- Average Equation in Excel: Formulas, Uses, and ExamplesThe average equation in Excel is =AVERAGE(range). For example, with numbers in B2:B6, enter =AVERAGE(B2:B6) in another cell…
- Extract PAN from GSTIN in Excel: Formula and ChecksYes. If a GSTIN is in cell A2, extract its embedded 10-character PAN with =MID(A2,3,10). The formula takes…
- Excel Time Between Two Timestamps: Formulas and TipsIf the start timestamp is in A2 and the end timestamp is in B2, enter =B2-A2 to calculate…
- Is INDIRECT Volatile in Excel? Performance ExplainedYes. INDIRECT is a volatile Excel function, so it recalculates whenever Excel recalculates, even when the cells named…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.