Excel Filter Shortcut Key: Turn Filtering On or Off

Formulas & functions · Updated November 20, 2026

To apply a filter in Excel for Microsoft 365 on Windows, click a cell in your data range and press Ctrl+Shift+L. Excel adds filter arrows to the header row; press the same shortcut again to remove them. You can then use a header arrow to show only rows that match values or conditions you choose. Before starting, make sure your data has a single header row and is arranged in columns.

What You’ll Need

  • An Excel workbook open in the desktop version of Microsoft Excel for Microsoft 365 on Windows.
  • A contiguous block of data with a header at the top of each column. For example, a sales list might have columns for Date, Product, Region, and Amount.
  • Permission to edit the workbook. If the sheet is protected, filtering may be unavailable unless the workbook allows it.

You do not need to select every cell if your data is one continuous block: clicking inside it is usually enough. If the range includes blank rows or columns, select the exact range first so Excel does not guess the wrong boundaries.

Step-by-Step

  1. Check the layout. Put one field name in each cell of the top row, such as Date, Product, and Region. Keep each record on one row, and avoid merged cells in the header. Remove completely blank rows or columns from within the list if you can; they can cause Excel to treat part of the data as a separate block. A title above the headers is fine, but it should not be mixed into the header row.
  2. Choose the data range. Click any cell inside the continuous list. Excel normally detects the connected data and applies the filter to the whole block. For a range with gaps, click and drag to select all of the intended cells, including the header row. For example, if headers are in A1:D1 and records run through row 40, select A1:D40 before using the shortcut.
  3. Turn on the filter arrows. Press Ctrl+Shift+L on your Windows keyboard. Small dropdown arrows should appear beside the header names. This shortcut toggles AutoFilter: if filters are already on for the selected range, pressing it turns them off instead of adding another set. If Excel displays a prompt about headers, check the selection and confirm whether the first row contains column names.
  4. Open a column’s filter menu. Click the arrow in the header of the column you want to narrow. The menu usually contains a search box, a list of values with checkboxes, and sorting or filtering commands. Each column has its own menu, so choosing a condition in one column does not erase a condition set in another.
  5. Select the records to show. To pick particular values, clear Select All, check the values you want to keep visible, and choose OK. For example, in a Region column, select West and Central to hide the other regions temporarily. You can type part of a value into the search box to find it in a long list. Search narrows the displayed choices; you still need to check the results and click OK.
  6. Use a condition when matching values is not enough. In the menu, choose the appropriate option, such as Text Filters, Number Filters, or Date Filters, then select a condition such as Contains, Greater Than, or a date period. Enter the comparison value in the dialog and confirm. The available filter choices depend on the type of values Excel recognizes in that column.
  7. Combine filters if needed. Open another header menu and set an additional condition. Excel shows rows that satisfy the active filters together. For instance, filter Region to West and Amount to values greater than 500 to see only rows meeting both conditions. The other rows are hidden from view, not deleted from the worksheet.
  8. Clear or switch off the filter. To remove a condition from one column while leaving the other filters in place, open that column’s menu and choose Clear Filter From followed by the column name. To clear all conditions, use Data > Sort & Filter > Clear on Windows. To remove the arrows, click in the filtered range and press Ctrl+Shift+L again, or choose Data > Sort & Filter > Filter. Removing arrows also clears the filter display, but it does not delete any records.

On a Mac, Excel’s corresponding shortcut is generally Command+Shift+F. Shortcut behavior can vary with keyboard settings or Excel versions, so if it does not work, use the ribbon command Data > Filter. In Excel for the web, try Ctrl+Shift+L; if the browser intercepts the keys or the shortcut is unavailable, use Data > Filter on the ribbon.

Common Mistakes

  • Leaving the header row out. If you select only the records, Excel may treat the first record as the header or apply arrows in the wrong row. Include the field-name row when selecting a range manually.
  • Having blank headers or duplicate labels. Give every column a clear, nonblank heading. Duplicate names can make menus difficult to identify, and blank headings can lead to confusing results.
  • Expecting the shortcut to filter a particular value. Ctrl+Shift+L only turns the dropdown controls on or off. You must open a column menu and choose values or a condition to hide rows.
  • Thinking filtered rows have been deleted. A filter hides rows that do not match; it does not remove them. Clear the filter to display the full list again before deciding that records are missing.
  • Selecting a fragmented range. Blank rows inside a list can split it, so clicking one cell may not include later records. Remove unnecessary gaps or select the complete range explicitly.
  • Filtering mixed data as if it were one type. A column containing numbers stored as text, dates stored in different formats, or extra spaces may offer unexpected filter options. Clean up inconsistent entries when results do not match what you expect.

Tips

  • Convert a recurring list to a Table. Click inside the data and press Ctrl+T, confirm that My table has headers is selected, and click OK. Excel Tables include filter arrows by default and usually expand as you add rows. The shortcut for turning filters on or off remains useful for ordinary ranges.
  • Use the value checklist for exact selections. It is often clearer than typing a condition when you need a few specific categories, names, or dates. The search box helps locate an item, while the checkboxes determine which values remain selected.
  • Use conditions for ranges. For numeric data, a Number Filter is more convenient than ticking many individual values. For dates, choose a date filter appropriate to your goal; Excel may group recognized dates by year, month, or day.
  • Check the status bar and row numbers. After filtering, row numbers may skip, indicating that some rows are hidden. If you plan to copy results, check that you are copying the visible filtered rows rather than assuming the displayed list is the entire dataset.
  • Save before reorganizing data. Filtering itself is reversible, but sorting or deleting visible rows can change the sheet. If you are unsure what a later action will affect, save a copy first and confirm the filter is cleared when you need to review all records.

Troubleshooting

Ctrl+Shift+L does nothing: Click a cell in the data first, then try again. Check that Excel has focus and that the sheet is not protected in a way that blocks filtering. If a laptop uses function or media-key modes, this shortcut should not require an Fn key, but keyboard software or remote desktop settings may intercept combinations. Use Data > Sort & Filter > Filter as a practical alternative.

Arrows appear on only part of the list: Excel may have stopped at a blank row or column. Turn off the filter, remove gaps within the data if appropriate, select the full intended range including headers, and enable the filter again. Check the first and last record to confirm the selected range reaches the end.

A value you expect is missing from the menu: Clear the search text in the dropdown and check whether another filter is active in a different column. Also inspect the source cells for extra spaces, spelling differences, or values stored in inconsistent formats. A filter menu lists values in the selected range, so confirm the row containing the missing value is actually included.

The results look wrong or no rows remain: Open each active filter menu and review its checked values or condition. Multiple column filters work together, so a restrictive condition in one column can exclude all rows that pass another. Clear individual filters one at a time to identify the cause, then set the intended conditions again.

The filter command is disabled: Confirm that you are in a worksheet rather than another workbook view, and check whether sheet protection or shared-workbook restrictions apply. If the data is inside a Table, use its header arrows or review the table’s filter state. On Mac or in a browser, the ribbon’s Data > Filter command can help distinguish a shortcut issue from a workbook restriction.

Frequently Asked Questions

What is the shortcut key to apply a filter in Excel?

In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L while a cell in the data is selected. The same shortcut toggles the filter arrows off if they are already enabled for that range.

Does Ctrl+Shift+L filter the data automatically?

No. It adds or removes the dropdown arrows. Open a header dropdown and choose values or a filter condition to decide which rows remain visible.

What is the filter shortcut on a Mac?

In Excel for Mac, the shortcut is generally Command+Shift+F. If it is unavailable in your setup, use Data > Filter from the ribbon.

Can I filter more than one column at a time?

Yes. Set a filter in one column, then open another column’s dropdown and set another. Excel displays rows that meet the active conditions together.

How do I remove a filter without deleting my data?

Choose Clear Filter From in a column menu, or use Data > Sort & Filter > Clear to clear the conditions. To remove the arrows, press Ctrl+Shift+L again. Neither action deletes the rows.

Why does my filter omit some rows?

Excel may have detected only part of the list because of blank rows or columns, or the omitted entries may have inconsistent text or number formats. Check the selected range and the source values, then reapply the filter.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.