Excel Filter Shortcut: How to Turn It On and Use It

Formulas & functions · Updated November 20, 2026

To put a filter in Excel on Windows, click a cell in your data and press Ctrl+Shift+L. Excel adds a drop-down arrow to each column header; use an arrow to show only rows that match the conditions you choose. Your data is hidden from view, not deleted. Before you start, make sure the data has one clear header row and no completely blank rows splitting the list.

What You’ll Need

  • Excel for Microsoft 365 on Windows. The steps also work in many recent desktop versions of Excel.
  • A range of data with a single header row, such as columns for Date, Customer, and Status.
  • Permission to edit the worksheet. A protected sheet may prevent you from turning filters on or changing them.

You do not need to select every cell first. Clicking one cell inside a continuous block of data is usually enough for Excel to find the range. If you are using a Mac or Excel for the web, see the platform notes below.

Step-by-Step

  1. Check the layout of your data. Put one field name at the top of each column, with the records directly beneath it. For example, a sales list might have Order Date, Region, Product, and Amount in row 1, followed by one order per row. Keep each column to one type of information where practical. Remove completely blank rows or columns inside the list, because they can cause Excel to detect only part of the data.
  2. Click a cell inside the data. Choose any filled cell in the list, including a header or a record cell. You normally should not select the entire worksheet: doing so can make it harder for Excel to identify the intended range. If the sheet contains several separate lists close together, select the exact range you want to filter instead, including its header row.
  3. Turn on the filter shortcut. Press Ctrl+Shift+L on your Windows keyboard. Excel adds a small filter arrow to each header in the selected or detected range. If you prefer the ribbon, choose Data > Filter. The ribbon command is a useful alternative if a keyboard shortcut is unavailable or you are unsure what range Excel selected.
  4. Open a column’s filter menu. Click the arrow beside the heading you want to filter, such as Region. You can also select the header cell and press Alt+Down Arrow in Excel for Windows. The menu shows options suited to the column, including a search box and a list of values. For a date or number column, it can also offer relevant comparison and range options.
  5. Choose the values to show. To keep only certain entries, clear Select All, check the values you want, and choose OK. For example, in a Region column, select West to show only West records. You can type part of a value in the search box to find it in a long list; check the matching result, then apply the filter. The checkboxes control which distinct cell values are included.
  6. Use a condition when a value list is not enough. In a text column, choose Text Filters for options such as Contains or Begins With. In a number column, choose Number Filters, then select a condition such as Greater Than. For dates, use Date Filters to select a time period or comparison. Fill in the condition in the dialog and confirm it. The available choices depend on the type of data Excel recognizes in that column.
  7. Combine filters across columns. Open another column’s arrow and apply a second condition. Excel shows rows that satisfy both column filters. For example, filter Region to West and Status to Open to see open records in the West. Within one column, selecting several values generally shows rows matching any of those selected values; across separate columns, the conditions narrow the results together.
  8. Check what is currently filtered. A column with an active filter displays a filter indicator on its header arrow. The row numbers may skip because some records are hidden. Look at the status bar or visible rows as appropriate, and confirm the remaining records make sense before copying or reporting them. Filtering changes what you see; it does not change the underlying cell contents.
  9. Clear a filter or turn filtering off. To show every value in just one column again, open that column’s arrow and choose Clear Filter From followed by the column name. To remove the conditions from all columns while keeping the arrows, use Data > Clear in the Sort & Filter group. To remove the filter arrows altogether, click in the range and press Ctrl+Shift+L again, or choose Data > Filter. The shortcut is a toggle, so pressing it when filters are on turns them off.

Mac and web: In Excel for Mac, Command+Shift+F is commonly used to turn filtering on or off. Keyboard behavior can vary with the keyboard layout and Excel settings, so use Data > Filter if the shortcut does not respond. In Excel for the web, use Data > Filter if the keyboard combination is intercepted by your browser or does not work in your setup. The filter menus themselves work similarly, though their appearance may differ.

Common Mistakes

  • Expecting the shortcut to filter immediately. Ctrl+Shift+L turns the filter controls on or off; it does not choose a value. You still need to open a header arrow and select values or a condition.
  • Leaving a blank row inside the list. A fully blank row can make Excel treat data beneath it as a separate block. Remove the separator or select the complete intended range before applying the filter.
  • Using duplicate, blank, or unclear headings. Filters are easier to operate when each column has one descriptive header. Add a heading for any blank header cell, and avoid merged cells in the header row. A structured table also requires unique column names.
  • Filtering the wrong block. If several data sets are near each other, Excel may detect a range you did not intend. Select the desired range, including its headers, before using the shortcut. Check that every intended column received a filter arrow.
  • Thinking filtered records have been deleted. Rows excluded by a filter are hidden from the current view. Clear the filter to display them again. Be careful when selecting visible cells for copying, since hidden rows may not appear in the selection as you expect.
  • Trying to filter a protected sheet. Worksheet protection can block filter changes unless filtering is allowed in the protection settings. If you have authorization, ask the sheet owner to enable the needed permission or provide an editable copy.

Tips

  • Make the list an Excel table for ongoing work. Click inside the data and choose Insert > Table, confirm the range, and make sure My table has headers is selected if the first row contains headings. Tables add filter arrows automatically and generally include new rows added directly beneath the table. The shortcut still toggles filter buttons, but table headers are usually the simplest option for a list you maintain regularly.
  • Use the search box for long lists. If a column contains hundreds of customer names or product codes, typing a distinctive part of a value is faster than scrolling through the checkbox list. Review the checked items before clicking OK, especially if you want more than one matching value.
  • Know when to use sorting instead. Filtering hides rows that do not match your criteria; sorting rearranges rows. If you need to see every record ordered by date or amount, use the sort options in the same header menu rather than filtering out values.
  • Keep an eye on existing filters. A filter might already be active in another column, so a newly applied filter can produce fewer rows than expected. Use Data > Clear to remove all current criteria before starting a fresh review, while leaving the filter arrows available.
  • Freeze headings on a long worksheet. Filtering is easier when column names remain visible as you scroll. Use View > Freeze Panes > Freeze Top Row when the headings are on the first row. This changes the view, not the data, and is separate from the filter shortcut.
  • Be cautious when copying results. Before copying a filtered list, confirm whether you need only visible rows or the full underlying range. If the copied result matters, paste it into a separate area and verify the number of records and headings.

Troubleshooting

Ctrl+Shift+L does nothing: First click inside an ordinary worksheet range, then try again. Make sure Excel has focus rather than another application or a cell-editing cursor. A protected worksheet, a different keyboard layout, remote desktop settings, or another program capturing the shortcut can interfere. Use Data > Filter to check whether the command works from the ribbon. If it is a protected sheet, the owner may need to allow filtering or unprotect it.

Arrows appear on only some columns: Excel may have identified a partial range, often because a blank row or column separates part of the list. Turn filtering off, remove the gap if it is not needed, select the complete data block including its headings, and choose Data > Filter. If the data is in an Excel table, check that the missing field is inside the table boundaries.

The filter returns unexpected records: Check for a filter already applied to another column and clear it with Data > Clear before trying again. Also look for inconsistent entries such as trailing spaces, spelling differences, dates stored as text, or numbers stored as text. Excel may list entries that look similar as separate values, and it may offer text rather than date or number conditions if the column contains mixed data types.

The filter arrow or menu is unavailable: Confirm that you are working in a worksheet range, not a chart or another object, and that the sheet is not protected against filtering. If workbook sharing or permissions restrict editing, request access from the owner. You can also use Data > Filter to distinguish a shortcut issue from a worksheet or permission issue.

You turned the arrows off and want them back: Click inside the data and press Ctrl+Shift+L again, or choose Data > Filter. If the range is still recognized, the arrows return. If not, select the complete range with its header row first. Turning arrows off does not erase the records, but it removes the filter controls from that range.

Frequently Asked Questions

What is the shortcut to add a filter in Excel?
In Excel for Microsoft 365 on Windows, click inside the data and press Ctrl+Shift+L. It adds filter arrows, or removes them if they are already on.

Does Ctrl+Shift+L filter the data by itself?
No. It turns the filter controls on or off. Open a column’s arrow and select values or a condition to hide rows that do not match.

What is the filter shortcut on a Mac?
Command+Shift+F is commonly used in Excel for Mac. If it does not work with your keyboard or setup, choose Data > Filter.

How do I remove a filter but keep the arrows?
Open the filtered column’s menu and choose Clear Filter From that column. To clear criteria from multiple columns, choose Data > Clear. Both approaches leave the filter controls available.

Can I filter only one column?
Yes. Apply the filter to the range, then open the arrow on the column you want and choose its values or condition. Other columns can remain unfiltered, though an existing filter elsewhere may also affect the visible rows.

Will filtering delete or change my rows?
No. A filter hides rows that do not meet the selected criteria; it does not delete or edit their contents. Clear the filter to display the hidden rows again.

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.