How to Filter in Excel Without a Mouse: Keyboard Guide

Formulas & functions · Updated November 20, 2026

To filter a list in Excel for Microsoft 365 on Windows without a mouse, select a cell in the data and press Ctrl+Shift+L. Then select a column header, press Alt+Down Arrow to open its filter menu, choose the values or conditions you want with the keyboard, and press Enter to apply. Start with a single header row and a continuous block of data so Excel can identify the range correctly.

What You’ll Need

  • A Windows computer running Excel for Microsoft 365, with the workbook open.
  • A list with one header row, such as Date, Region, and Sales, and data below each header.
  • A keyboard. The steps below use Windows shortcuts; Mac and Excel for the web differences are noted where they matter.

You do not need to convert the range into a table, although a table is also a convenient way to work with filterable data. If your workbook is shared or contains important information, make sure you have permission to change its filters. Filtering hides rows from view; it does not delete them or change their values.

Step-by-Step

  1. Check the layout before turning on filters. Each column should have a meaningful, unique header in the first row of the list. Keep each record on one row, and avoid blank rows or blank columns inside the data. For example, a list of orders might have Order Date, Customer, Region, and Total across row 1, with individual orders underneath. Remove merged cells in the header if possible; merged headings can make a range harder for Excel to interpret.
  2. Move to a cell in the list using the keyboard. If the active cell is already inside the data, leave it there. Otherwise, use the arrow keys to reach a cell in the header or body. You can also press Ctrl+Home to go to the top-left of the worksheet, then use the arrow keys to reach your list. Ctrl+Home is useful when the sheet starts at A1, but it will not necessarily take you to the start of a list placed elsewhere.
  3. Turn on AutoFilter. Press Ctrl+Shift+L. Excel adds a drop-down button to each detected header. If the buttons do not appear, check that the active cell is within the list, that the list has a header row, and that there are no empty rows splitting the range. For an existing Excel table, filter buttons are normally already present, so you can skip this shortcut and go to the next step.
  4. Move to the column you want to filter. Use the arrow keys to select a cell in that column’s header. If the headers are next to one another, use Left Arrow or Right Arrow to move between them. You can also use Ctrl+Right Arrow from a cell near the start of a continuous row to move to its last populated cell, but check where you land before opening a menu.
  5. Open the column’s filter menu. With a header cell selected, press Alt+Down Arrow. The menu belongs to the selected column. Use the Up and Down Arrow keys to move through visible options, and use Tab to move between controls when needed. The exact focus order can vary slightly with Excel updates and the type of data, so read the highlighted option or control before pressing Space or Enter.
  6. Choose specific values when you want to keep only certain entries. In the menu, move to the checklist of values. Use the arrow keys to move through it and press Space to check or uncheck the focused item. If the list offers a Select All checkbox, clear it first when you want only a few values, then check the entries to keep. A search box may be available in the menu; use Tab to reach it, type part of an entry, and then choose the matching value. Press Enter to apply the selection. Excel displays rows matching the checked values and hides the others.
  7. Use a condition for more precise filtering. In a text column, look for Text Filters; in a number column, look for Number Filters; and in a date column, look for Date Filters. Open the submenu with Right Arrow or Enter, choose a condition such as Contains, Greater Than, or Before, then enter the criterion in the dialog and confirm with Enter. For example, a Number Filters condition of Greater Than can show values above a threshold. The available choices depend on the selected column’s data type.
  8. Confirm that the filter took effect. Look at the row numbers and the selected column’s header icon. Excel hides nonmatching rows; it does not move them to another place. The filter button may show a funnel or another changed appearance to indicate a filter is active. Use the arrow keys to move to visible cells and check that the results fit your intention. If necessary, reopen the menu with Alt+Down Arrow and adjust the checked values or condition.
  9. Clear a filter or turn filtering off when finished. To show all values in one column while leaving the other filters active, open that column’s menu and choose Clear Filter From, followed by the column name. Navigate with the arrow keys or Tab and press Enter. To clear filters across the range, use Data > Sort & Filter > Clear. To remove the filter buttons themselves, select a cell in the range and press Ctrl+Shift+L; this toggles AutoFilter off, so use it only when you want to remove the controls as well as the current filtered view.

On a Mac: Excel for Mac has different keyboard mappings. In current desktop versions, Command+Shift+F is commonly used to toggle filters; if that shortcut is intercepted or unavailable on your keyboard, use the Data tab and choose Filter. With a header selected, Option+Down Arrow opens a filter menu on many Mac keyboards. Depending on the keyboard and Excel version, you may need Fn with the arrow key. The Data tab remains a keyboard-accessible alternative. In Excel for the web, browser shortcuts can conflict with Excel shortcuts, so use the ribbon’s Data > Filter command if Ctrl+Shift+L does not work.

Common Mistakes

  • Selecting only one cell outside the list. The shortcut may not detect the intended range. Move into a populated cell first, then turn on AutoFilter. When Excel selects only part of your data, inspect the range for blank rows or columns that divide it.
  • Using a blank or repeated header. Headers tell Excel what each column contains. Add a clear label to every column before filtering. Similar labels can also make it easy to open the wrong column menu, so use distinct names when practical.
  • Assuming hidden rows were deleted. A filter only hides rows that do not meet the criteria. Clear the relevant filter to show them again. Do not copy or delete visible results unless you understand which rows Excel has selected.
  • Pressing Ctrl+Shift+L to clear results. This shortcut toggles the filter controls off; it is not the best way to clear just one filter. Use Clear Filter From in that column’s menu, or Data > Sort & Filter > Clear to clear the current filters while keeping the controls.
  • Filtering numbers or dates stored as text. Values that look numeric or date-like may be treated as text, leading to unexpected menu options or ordering. Check the source data and cell formats, and correct inconsistent entries if you need reliable number or date conditions.
  • Confusing a sort with a filter. Sorting rearranges rows; filtering hides rows that do not match. Both commands may appear in the same menu, so read the highlighted option before confirming.

Tips

  • Use a table for a list that will grow. Select a cell in the data and press Ctrl+T, then confirm that the range has headers. Excel tables include filter buttons and usually extend as you add rows. This is optional; AutoFilter also works on a regular range.
  • Filter one column at a time when learning the menu. After applying a filter, the next column’s filter narrows the already-visible results. That means two active filters work together: a row must match both conditions to remain visible.
  • Use a short search term for long checklists. If the filter menu has a search box, searching for a distinctive part of a value can be faster than moving through a long list. Check which entries are selected before applying, particularly if you previously used a different search.
  • Keep the header row visible in large sheets. Freeze Panes is separate from filtering, but keeping headings visible can help identify columns while you review results. You can access it from View > Freeze Panes; use the ribbon if you need to reach it without a mouse.
  • Remember that filter settings can be combined. If a result seems too narrow, check every filtered column, not just the one you last changed. Clear filters one at a time to see which condition is excluding the rows you expect.

Troubleshooting

Ctrl+Shift+L does nothing: First confirm that Excel, rather than another application or a browser control, has focus. Click is not required: press Esc to close any open menu, use arrow keys to select a cell inside the data, then try the shortcut again. If the workbook is in a browser, use Data > Filter from the ribbon. On Mac, use the Mac shortcut or the Data tab instead of the Windows combination.

Filter arrows do not appear on every header: The selected range may be incomplete, or a blank row or column may be breaking the list into separate regions. Turn AutoFilter off if needed, inspect the data boundaries, remove unintended gaps, and turn it on again from a cell within the complete range. If the data is an Excel table, check that the table itself includes all the rows and columns you want.

The menu will not respond as expected: Press Esc once to close the menu and return to the sheet. Select the correct header cell, press Alt+Down Arrow again, and watch which control has focus. Use Tab to move between controls and Space to change a checkbox; use Enter to confirm a choice. If a key appears to trigger a browser action, use Excel’s ribbon commands or check whether a laptop requires the Fn key for its arrow keys.

Expected rows are missing: Another column may still have a filter applied. Open each relevant header menu and look for an active filter or choose Clear Filter From for that column. Also check for inconsistent values, extra spaces, or dates stored as text. A value that appears identical on screen may not match another entry exactly.

Filtered rows seem to have disappeared: Look for gaps in the row numbers, which indicate hidden rows, then clear the filter. If the rows remain absent, check whether the worksheet has manually hidden rows or whether you are viewing a different sheet. Filtering itself does not remove data.

Frequently Asked Questions

What is the keyboard shortcut to filter in Excel?
In Excel for Microsoft 365 on Windows, Ctrl+Shift+L turns AutoFilter on or off for the current range. To open a column’s filter menu, select its header and press Alt+Down Arrow.

Can I filter Excel by more than one value without a mouse?
Yes. Open the column menu, use the arrow keys to move through the value checklist, press Space to select or clear entries, and press Enter to apply. If available, use the menu’s search box to locate values in a long list.

How do I filter for text that contains a word?
Open the text column’s menu and choose Text Filters > Contains. Enter the word in the condition dialog and confirm. The exact submenu options depend on the values Excel recognizes in that column.

How do I remove one filter but keep the others?
Open the menu for the filtered column and select Clear Filter From that column. Avoid toggling AutoFilter off with Ctrl+Shift+L if you want to keep the other filter controls in place.

Does filtering delete rows or change the original data?
No. Filtering hides rows that do not match the selected criteria. Clear the filter to display them again. It does not rewrite or delete their cell contents.

Can I do this in Excel for the web or on Mac?
Yes, although shortcut behavior differs by platform and can be affected by the browser or keyboard layout. Use the Data tab’s Filter command if the shortcut does not work, then navigate the filter menu with the keyboard.

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.