How to Filter in Excel Using Keyboard Shortcuts and Menus

Formulas & functions · Updated November 20, 2026

To filter a list in Excel for Microsoft 365 on Windows, select a cell in the data, press Ctrl+Shift+L to show filter arrows, then select a header and press Alt+Down Arrow to open its menu. Use the menu’s search and checkbox controls to choose values, then press Enter to apply the filter. Your data stays in the worksheet; Excel temporarily hides rows that do not match.

What You’ll Need

  • An Excel workbook with a list arranged in columns, such as orders, names, or inventory.
  • A header row with a distinct label at the top of each column. Avoid blank header cells and merged cells.
  • A desktop version of Excel for Microsoft 365 on Windows for the shortcuts below. On Mac, use the Data tab’s Filter command if the Windows shortcut does not work; shortcut assignments can differ by Excel version and keyboard settings.

You do not need a formula or a specially formatted table. However, the filter works most predictably when each column contains one kind of information and there are no completely blank rows or columns splitting the list.

Step-by-Step

  1. Prepare the list. Check that each column has a useful header, such as Date, Region, or Status, and that each data row contains one record. Remove blank rows inside the list if they divide it into separate blocks. If your worksheet has notes or other data close to the list, make sure Excel can identify the intended range without including those unrelated cells.
  2. Select a cell in the data. Click any cell inside the list, not a whole worksheet column. Excel usually detects the connected data range from that cell. If it selects the wrong range, select the exact block yourself, including the headers and all rows you want to filter. Leave cells outside the list unselected.
  3. Turn on the filter arrows. Press Ctrl+Shift+L. Small drop-down arrows should appear in the header cells. This shortcut toggles AutoFilter on or off for the selected range, so do not press it repeatedly if you want the arrows to stay visible. You can also use the ribbon: choose Data > Filter.
  4. Open the menu for the column to filter. Move to a cell in the column’s header, then press Alt+Down Arrow. For example, move to the Region header to filter by location. The drop-down menu belongs to that column; it will not change the filter criteria in other columns.
  5. Search for a value, if useful. In the drop-down menu, use Tab to move focus to the search box. Type all or part of the value you want, such as North or Pending. Searching narrows the checklist; it does not apply the filter by itself. If the search box is not the focused control, continue tabbing until it is, and check that your text appears there before proceeding.
  6. Choose the values to show. Use Tab to move from the search box to the value checklist, then use the arrow keys to move through its entries. Press Space to check or uncheck the focused item. The checklist normally starts with Select All; changing that option can clear or restore the selections in the list. If you searched, select the matching entries you want to keep. You can select more than one value.
  7. Apply the selection. Press Enter to apply the menu selection. Rows that do not match are hidden, and the filter arrow may show a filter indicator. Look at the visible records to confirm that the intended values remain. If the menu stays open, use Tab to reach its confirmation control, if shown, and press Enter.
  8. Add another column filter if needed. Filtering can use more than one column at the same time. Move to the next header, press Alt+Down Arrow, choose its criteria, and apply them. Excel displays only rows that meet the criteria in every filtered column. For example, a Region filter for North combined with a Status filter for Pending shows records that satisfy both conditions.
  9. Remove a filter when you are finished. To restore all rows while keeping the filter arrows, open the relevant column’s menu and choose its clear-filter command. You can also use Data > Sort & Filter > Clear to clear the active filters for the range. To remove the arrows as well, select a cell in the list and press Ctrl+Shift+L; this turns AutoFilter off.

For criteria other than a list of values, open the column menu and look for Text Filters, Number Filters, or Date Filters, depending on the data. Choose an option such as Contains, Greater Than, or Before, complete the dialog, and confirm it. The available options depend on the values Excel recognizes in that column.

Common Mistakes

  • Expecting the shortcut to filter a value immediately. Ctrl+Shift+L adds or removes the filter controls; it does not choose which records to display. You still need to open a column menu, set criteria, and apply them.
  • Including the wrong range. If there is a blank row in the middle of a list, Excel may treat the data below it as a separate region. Select the full intended range before enabling the filter, or remove the separating blank row if appropriate.
  • Using duplicate or missing headers. Give every column a header. Clear, distinct labels make it easier to identify the right menu and reduce confusion when you filter multiple fields.
  • Thinking filtered records have been deleted. Filtering hides rows rather than removing them. Clear the criteria to display the full list again, and avoid deleting visible rows unless that is your intention.
  • Forgetting that filters combine. A second column filter narrows the results of the first one. If the screen becomes empty, check every active filter rather than assuming the latest column has no matching records.
  • Pressing the toggle shortcut to clear criteria. Ctrl+Shift+L hides or shows the filter arrows; use a clear-filter command to restore hidden records while leaving filtering available.

Tips

  • Use a table for a list that will grow. Select the data and choose Insert > Table, making sure the option indicating that the table has headers is correct. Excel tables include filter arrows and generally extend when you add rows directly below them. The keyboard shortcut for toggling filters remains useful for ordinary ranges.
  • Use a short search term. If a checklist contains many entries, search for a distinctive part of the value. Review the narrowed choices before applying the filter, especially when similar labels appear, such as North and Northeast.
  • Remember the filter state. An arrow with a filter indicator usually means criteria are active for that column. If results seem incomplete, check each filtered header and clear criteria one at a time or use the ribbon’s Clear command.
  • Keep the header in view. For a long worksheet, use View > Freeze Panes if you want the header row to remain visible while scrolling. This does not change the filter, but makes it easier to locate the columns and read the results.
  • On Mac, use the ribbon if needed. Excel for Mac has a Data tab with a Filter command, but Windows key combinations may not match your Mac keyboard setup. Use Data > Filter to show or hide arrows, then open a header’s menu and use its visible controls. In Excel for the web, keyboard behavior can also depend on browser shortcuts and keyboard-navigation settings.

Troubleshooting

Nothing happens when I press Ctrl+Shift+L. Confirm that Excel is the active window and that the workbook is not in a mode that is intercepting keyboard input. Try Data > Filter instead. On a laptop, you may need to hold an Fn key for some keyboard combinations, depending on the keyboard configuration. On Mac, use the ribbon command rather than assuming the Windows shortcut applies.

The arrows appear on only part of my list. Turn the filter off, inspect the range for completely blank rows or columns, then select the full data block and turn filtering on again. Also check that the headers and records form one continuous range. If there is unrelated content beside the list, selecting the exact range before choosing Data > Filter can help keep it out.

My search does not find a value I can see. Clear the search text and inspect the checklist. The cell may contain leading or trailing spaces, a spelling variation, or a value stored differently from other entries. For instance, numbers stored as text may not behave like numeric values. You can also try a shorter, distinctive search term and verify that the filter is being applied to the correct column.

All the rows disappeared. One or more active criteria may exclude every record, or the selected value may not match the data exactly. Open the relevant header menu and review its checked items; clear that column’s filter to test the list. If several columns are filtered, clear them all with Data > Sort & Filter > Clear, then apply the criteria again one at a time.

I cannot reach the search box or checklist by keyboard. Open the header menu with Alt+Down Arrow, then use Tab and Shift+Tab to move among controls. The order and available controls can vary with the kind of column and Excel build. If focus is hard to track, use the visible focus outline, or use the mouse for that menu and continue with the keyboard afterward.

Frequently Asked Questions

What is the shortcut to turn on filters in Excel?
In Excel for Microsoft 365 on Windows, select a cell in the list and press Ctrl+Shift+L. It toggles the filter arrows on or off; it does not set filter criteria.

How do I open an Excel filter using the keyboard?
Move to a header cell and press Alt+Down Arrow. Use Tab, the arrow keys, and Space to navigate and change selections, then press Enter to apply them.

Can I filter for more than one value in the same column?
Yes. In the column’s checklist, select each value you want included. Excel shows rows matching any of the selected values in that column, while filters in other columns further narrow the results.

Does filtering delete or rearrange my data?
No. A standard filter hides rows that do not meet the criteria; it does not delete them. Sorting is a separate action that changes the order of the visible records.

How do I show all rows again without removing the arrows?
Open a filtered column’s menu and choose its clear-filter command, or use Data > Sort & Filter > Clear. The arrows remain available so you can filter the list again.

Does this shortcut work in Excel for Mac?
Shortcut behavior can vary by Mac keyboard and Excel version. If Ctrl+Shift+L does not toggle the filter, use Data > Filter on the ribbon. Once the arrows are visible, use the column menu to set or clear criteria.

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.