Filtering is one of Excel’s most-used features, yet most people still reach for the mouse to click the funnel icon. That’s slow. This list covers the ten keyboard shortcuts that matter most for turning filters on, clearing them, re-applying them, and navigating filtered data. Whether you’re a spreadsheet novice or a daily power user, these keystrokes will shave seconds off every task and keep your hands on the keyboard where they belong.
Ctrl+Shift+L – Toggle Filters On/Off
This is the granddaddy of filter shortcuts. Pressing Ctrl+Shift+L on any cell in a range or table toggles the filter dropdown arrows on or off. It works on both a selected range and an Excel Table, and it’s the fastest way to add or remove filter controls without touching the Data tab. If you have multiple sheets, you can quickly add filters to each one without moving your hands.
Alt+Down Arrow – Open the Filter Dropdown
Once filters are on, click into any header cell and press Alt+Down Arrow to open that column’s filter menu. This is the same menu you get from the mouse, but now you can navigate it with the arrow keys. It’s especially useful when you want to quickly uncheck a few items or switch from ‘Select All’ to a specific value. You can also press Enter to apply the filter after making changes.
Alt+A+T – Clear All Filters
When you have multiple filters applied and want to start fresh, this clears every filter on the current sheet in one go. It’s the keyboard equivalent of clicking ‘Clear’ in the Sort & Filter group on the Data tab. Unlike toggling filters off with Ctrl+Shift+L, this keeps the dropdown arrows visible—it just removes the filtering criteria. That’s handy when you want to see all data but plan to re-filter soon.
Ctrl+Shift+L (Again) – Re-apply Last Filter
If you’ve cleared a filter or changed your data and want to re-apply the same criteria you used before, press Ctrl+Shift+L twice: first to turn filters off, then on again. This re-applies the last filter settings you had. It’s a clever trick that many people miss. For example, if you filtered for ‘Pending’ status and then added new rows, this will instantly re-apply that filter to the updated data.
Alt+Down Arrow, Then E – Search Within a Filter
When you open a filter dropdown, you can press E to jump to the search box at the top. Type a few characters and Excel will narrow the list in real time. This is a massive time-saver when your column has hundreds of unique values. After typing, use the arrow keys to select the matching item and press Enter to apply. This combination is especially powerful for large datasets like customer names or product codes.
Ctrl+Shift+* – Select the Filtered Data Range
This shortcut selects the entire current region around the active cell, but with a twist: it only includes visible rows when filters are active. So if you have filters applied, pressing Ctrl+Shift+* selects all visible data, excluding hidden rows. That’s perfect for copying just the filtered results. Without this, you might accidentally copy hidden rows. It’s a must-know for anyone who regularly exports filtered data.
Alt+; – Select Visible Cells Only
After you’ve selected a range that includes hidden rows, Alt+; (semicolon) restricts the selection to only the visible cells. This is essential when you want to copy or format just the filtered rows. For example, if you filter a list and then select the entire column, pressing Alt+; ensures you only copy the rows you see. It’s a two-step combo: select the range, then press Alt+; to trim it.
Ctrl+Alt+L – Apply Filter to a Table (Alternative)
If you’re working with an Excel Table (created with Ctrl+T), Ctrl+Alt+L is an alternative way to toggle the filter buttons on the header row. It’s not as widely known as Ctrl+Shift+L, but it works specifically on tables and can be easier to remember if you already use Ctrl+T for tables. In practice, both shortcuts do the same thing, so pick the one that feels more natural.
Alt+Down Arrow, Then S – Sort Ascending
While the filter dropdown is open, pressing S will sort the column in ascending order (A to Z, smallest to largest). This is a quick way to sort without leaving the keyboard. It’s not strictly a filter, but it’s part of the same dropdown menu and often used in combination with filtering. If you need descending order, press O instead. These letters are the underlined shortcuts in the menu.
Alt+Down Arrow, Then U – Sort Descending
Similarly, pressing U in the filter dropdown sorts the column in descending order (Z to A, largest to smallest). This is the counterpart to the S shortcut. Together, they let you sort any column in two keystrokes without ever touching the mouse. For numeric data, this is great for seeing the top values quickly. Remember: open the dropdown with Alt+Down Arrow, then press U.
How to Choose
Not every shortcut is equally useful in every situation. If you only learn one, make it Ctrl+Shift+L—it’s the foundation for all filtering. If you work with large datasets, prioritize the search-within-filter combo (Alt+Down Arrow, then E) and the visible-cells selection (Alt+;). If you often need to clear filters, Alt+A+T will save you the most time. The rest are nice-to-haves that become second nature with practice. Start with the first three, then add the others as you get comfortable.
Frequently Asked Questions
Why doesn’t Ctrl+Shift+L work on my data? It only works on a contiguous range or an Excel Table. If your data has blank rows or columns, select the entire range first, or convert it to a Table with Ctrl+T.
Can I filter by color using these shortcuts? Yes, but not directly. Open the dropdown with Alt+Down Arrow, then use the arrow keys to navigate to ‘Filter by Color’ and select the color. It’s a few extra keystrokes but still keyboard-only.
How do I clear a single filter without clearing all? Open that column’s dropdown with Alt+Down Arrow, then press C to clear the filter on that column only. This is faster than clearing everything and re-applying.
Do these shortcuts work in Google Sheets? Most of them do not. Google Sheets uses different shortcuts, like Ctrl+Shift+L to open the filter menu. If you switch between the two, be aware of the differences.
Can I use these shortcuts on a Mac? Yes, but replace Ctrl with Command (⌘) for most shortcuts. Alt becomes Option. So Ctrl+Shift+L becomes ⌘+Shift+L, and Alt+Down Arrow becomes Option+Down Arrow.
Is there a shortcut to filter by a specific cell’s value? Not directly, but you can right-click a cell and choose ‘Filter’ then ‘Filter by Selected Cell’s Value’—that’s mouse-only. The keyboard alternative is to use the search box in the dropdown and type the value.
Final Thoughts
Filtering is a daily task for most Excel users, and these shortcuts turn it from a mouse-click chore into a fluid keyboard experience. Start with the toggle and the dropdown opener, then add the others as you build muscle memory. Within a week, you’ll wonder how you ever managed without them. Your hands will thank you, and your productivity will get a measurable boost.