Excel Filter Shortcut: Alt Keys and Faster Options

Formulas & functions · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, press Alt, then A, then T to apply or remove AutoFilter; press the keys one after another, not simultaneously. The faster toggle is Ctrl+Shift+L, while Alt+Down Arrow opens the filter menu for the selected column.

What the Alt+A,T shortcut does

Alt+A+T is a sequence of ribbon key tips. Pressing Alt displays key-tip letters on the ribbon; A selects the Data tab in the standard English Windows layout; then T invokes Filter. Depending on the worksheet selection, Excel turns filtering on for the current data range or turns it off. This is useful if you specifically want to reach the Filter command through the ribbon without using the mouse.

Do not hold all three keys down together. Press and release each key in order, waiting for the key-tip display to update after Alt and, if needed, after A. Ribbon key tips can differ when Excel uses another display language or a customized ribbon. If A does not identify the Data tab on your installation, look at the letters Excel displays after you press Alt, or use the ribbon shortcut shown in your version.

For most everyday use, Ctrl+Shift+L is simpler. It toggles AutoFilter without navigating the ribbon. The two shortcuts are alternatives for the same general task, not steps that need to be combined.

Alt+Down Arrow opens a different menu

A frequent source of confusion is the difference between Alt+A+T and Alt+Down Arrow. The first applies or removes the filter controls. The second opens the drop-down menu for a filter control that is already present in the selected column. It does not turn filtering on for an ordinary range by itself.

To use the drop-down shortcut, click or move the active cell to a column’s filter arrow, or select a cell in that column’s header or filtered data area, then press Alt+Down Arrow. The menu lets you choose values, search the list, sort, or access text, number, and date filter options. What appears depends on the type of data in the column.

For example, if a table has a Status column with Open, In progress, and Closed values, you can open its menu and clear the check marks for the statuses you do not want to see. Excel hides rows that do not match; it does not delete them. To restore the rows, reopen that column’s menu and clear the filter, or use the command to clear filters from the Data tab.

How to add filters to a data range

Before filtering, make sure Excel can identify the header row and the boundaries of the list. A simple, continuous range with one header row is easiest to work with. Avoid completely blank rows or columns inside the data, and use a distinct label for every column. If the data is already formatted as an Excel table, filter arrows usually appear in its header row automatically.

  1. Click a cell inside the data range. You usually do not need to select every row and column first.
  2. Press Ctrl+Shift+L, or use Alt, A, T in sequence. You can also choose Data > Filter.
  3. Check that drop-down arrows appear beside the column headings. Open a heading’s menu to choose the criteria you want.
  4. Repeat for other columns if needed. Filters on different columns work together, so the visible rows must satisfy the active filters.

To remove the arrows, use the same toggle shortcut again or choose Data > Filter. Turning AutoFilter off removes the filter controls; it is different from clearing the criteria while leaving those controls visible. If you want the arrows to remain but want all rows shown, clear the applied filters instead.

What happens when you filter a worksheet

Filtering changes which rows are displayed, not the underlying records. Rows that fail the chosen criteria are hidden temporarily. You can still find their values by clearing the filter, and filtering does not permanently rearrange or erase information. This makes filters helpful for exploring a large list, such as showing orders from one region or transactions above a chosen amount.

When more than one column is filtered, Excel applies the criteria together. Suppose you select Region = West and Status = Open. The worksheet shows rows that meet both conditions, rather than every row that meets either one. A funnel symbol on a column’s filter control indicates that a filter is active there; a plain drop-down arrow generally means the control is available but no criteria are currently restricting that column.

Sorting and filtering are related but not identical. Sorting changes the order of displayed records, while filtering hides records that do not meet criteria. A sort can remain after a filter is cleared, so do not assume that clearing filters restores the original row order. If row order matters, add an index column before sorting or filtering so you can sort back to the starting sequence.

Which shortcut should you use?

Choose based on the action you need rather than memorizing every option. The main Windows shortcuts are:

  • Ctrl+Shift+L: turn AutoFilter on or off for the selected data range. This is generally the quickest choice.
  • Alt, A, T: reach the Filter command through the Windows ribbon key tips.
  • Alt+Down Arrow: open the filter menu for the active column when filter controls are already available.

If you often filter data, the toggle shortcut is worth learning because it works without switching to a ribbon tab. If you rarely use shortcuts, Data > Filter is easier to discover and helps confirm which command you are using. If you need to choose a condition or inspect a list of values, go directly to that column’s filter menu; toggling AutoFilter alone will not select the criteria for you.

There is no need to select a whole worksheet before using the toggle. Starting from a cell inside a well-formed list lets Excel detect the current data region. Selecting unrelated cells or several separate ranges can make the result less predictable, so begin inside the particular list you want to filter.

Common problems and fixes

If the shortcut appears to do nothing, first confirm that the active cell is inside the data you intend to filter. Then check whether the arrows were toggled off, whether the sheet is protected, or whether the selected range has an unusual layout. A blank row inside a list can cause Excel to treat the records below it as a separate block rather than part of the same range.

  • No arrows appear: Click within the list and try the toggle again. Check that the first row contains headings and that there is not a blank row splitting the data.
  • The wrong rows are affected: Undo only if the last action was an unintended sort or another reversible change; otherwise clear the filter and reselect a cell in the intended range before applying it again.
  • The shortcut types characters or triggers something else: Make sure you are pressing the keys in the correct order. For the Alt sequence, press and release each key; for the toggle, press the three keys together.
  • Some values are missing from the menu: Excel’s filter list reflects the values in the range it recognizes, and a filter on another column may already be hiding records. Clear other filters and verify the selected range includes all data rows.
  • Headings are treated as data: Check that the range has a single, clearly defined header row. Merged cells and repeated header rows can interfere with a clean filter setup.

Also distinguish a filter from a search within a filter menu. Searching there narrows the displayed checklist of values; it does not create a permanent search field on the worksheet. Select the matching values and confirm the menu selection to apply the filter.

Excel for Mac and Excel for the web

The Alt key sequence described above is for Excel on Windows. On a Mac, the corresponding modifier key is generally called Option, but Windows ribbon key-tip sequences do not transfer directly. In Excel for Mac, use Data > Filter when you want the menu command. The AutoFilter toggle shortcut is commonly Command+Shift+F, and Option+Down Arrow can open a selected filter menu. Keyboard settings, hardware keyboards, or application versions may affect key combinations, so the Data menu is a dependable alternative.

Excel for the web has a browser-based ribbon and may handle some key combinations differently because the browser can reserve shortcuts. Use Data > Filter if a Windows shortcut is intercepted or does not behave as expected. In any version, the key distinction remains the same: applying AutoFilter creates or removes the controls, while opening a column’s menu lets you set that column’s criteria.

Frequently Asked Questions

What is the Excel filter shortcut with Alt?

In Excel for Microsoft 365 on Windows, press Alt, then A, then T to invoke Filter from the ribbon. Press each key in sequence. Ctrl+Shift+L is the quicker shortcut for toggling AutoFilter.

Does Alt+Down Arrow turn on filters in Excel?

No. It opens the drop-down menu for a filter control in the active column. Turn on AutoFilter first with Ctrl+Shift+L, Alt, A, T, or Data > Filter.

How do I clear a filter but keep the arrows?

Open the filtered column’s menu and choose the option to clear its filter, or use Data > Sort & Filter > Clear to clear filters across the range. The arrows stay available. The exact menu wording can vary with the type of filter and Excel version.

Does filtering delete hidden rows?

No. A filter hides rows that do not meet the criteria; it does not delete their contents. Clear the filter to show them again. Be careful when copying or deleting filtered data, since the visible-row selection can affect what you act on.

Why does Alt+A,T not work on my computer?

That sequence is for the standard English Windows ribbon. Key-tip letters can change with Excel’s language or ribbon setup, and Mac uses different keyboard conventions. Use the letters displayed after pressing Alt on Windows, or choose Data > Filter from the ribbon.

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.