In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn sheet filters on or off. With the active cell inside a data range, the shortcut adds filter arrows to the header row; use those arrows to display only the rows that meet your criteria.
What the Excel filter shortcut does
Ctrl+Shift+L toggles Excel’s AutoFilter feature for the current data range or table. When filters are on, small drop-down arrows appear in the column headings. Clicking an arrow opens options for choosing particular values, searching the list, or applying a condition such as a number, text, or date rule.
A filter changes which rows are visible; it does not delete the rows that fail the criteria. For example, filtering a sales list to show only the West region temporarily hides the other regions. Clear the filter to show those rows again. This is different from deleting records or copying only the visible results to another location.
The shortcut is a toggle, not a command to filter a particular value. It creates or removes the filter controls, while you choose the actual filtering rule from a column’s arrow. If you only need to show one customer, date range, or status, you will still need to open the relevant drop-down and select the condition.
How to apply a filter with the keyboard
For an ordinary list, click a cell inside the data and press Ctrl+Shift+L. Excel usually identifies the connected block of data and places filter arrows on its top row. You generally do not need to select every cell first. If you want to filter a specific portion of a worksheet, select that range and then use the shortcut.
- Check that the first row of the list contains meaningful column headings, such as Date, Region, and Amount.
- Click a cell within the list, or select the exact range you want to filter.
- Press Ctrl+Shift+L. Confirm that drop-down arrows appear beside the headings.
- Open a heading’s arrow, choose values or a filter condition, and select OK or apply the choice as prompted.
For example, imagine a table with columns for Date, Salesperson, Region, and Amount. To see only West-region records, open the Region arrow, clear Select All, select West, and confirm. To narrow the result further, apply a separate condition to Amount. Excel combines filters across columns, so a row must satisfy the active criteria to remain visible.
To remove a particular criterion without removing the arrows, open that column’s drop-down and choose its clear-filter option. To toggle AutoFilter off for the range, click within the data and press Ctrl+Shift+L again. If you want to keep the controls available while showing all records, clearing the criteria is usually preferable to toggling the feature off.
Using the filter drop-downs
The arrow menu adapts to the kind of information in a column. A column of names or categories offers a checklist of distinct values and a search box. A numeric column can offer comparisons such as greater than or between. Date columns provide date-oriented choices, including ways to filter by periods such as month or year. The options can differ depending on the data Excel detects.
- Choose listed values: select one or more entries in the checklist. This is handy for a short list of departments, regions, or statuses.
- Search a long list: type part of a value in the menu’s search box, then select the matching entry or entries. This can be quicker than scrolling through hundreds of distinct names.
- Use a condition: choose a text, number, or date filter when the goal is a rule, such as amounts above 500 or dates after a particular day.
- Combine columns: apply a Region filter and a Date filter together to find records that match both conditions.
Some menus also include sorting commands, but sorting and filtering are separate operations. Sorting rearranges records; filtering hides rows that do not match. A sort does not reduce the visible set, and applying a filter does not necessarily put the remaining records in a new order.
Headers, ranges, and Excel tables
Filters work best when a list has one clear header row and a consistent structure: one record per row, one field per column, and no completely blank rows or columns breaking up the list. A blank separator can cause Excel to treat adjoining sections as separate regions, so a shortcut may add arrows to less data than expected. In that case, select the intended range before using Ctrl+Shift+L.
Headings matter because Excel uses them to label each filter menu. Avoid merged cells in the header and avoid placing a title or explanatory note directly above the headings as part of the selected data. If the range has no header row, Excel may treat its first row as headings, leaving that row outside the filtered records. Add proper headings before filtering when possible.
Excel tables behave slightly differently from a plain range. Creating a table through Insert > Table or Home > Format as Table normally adds filter arrows to its header row automatically. The arrows remain part of the table, and new rows added directly below it can become part of the table. Ctrl+Shift+L is useful for toggling filters on a normal range; for a table, use its existing header arrows or the ribbon if you need to change the filter display.
Filter versus sort: choosing the right tool
Use a filter when you want to focus on a subset of records without rearranging or removing the underlying data. Use a sort when you want all records displayed in a different order, such as newest to oldest or largest amount to smallest. You can use both: sort the visible matching rows while a filter is active, then clear the filter to return to the full set.
For instance, a project tracker might contain hundreds of tasks. Filtering Status to In progress hides completed and not-started tasks. Sorting the remaining rows by Due Date then brings the nearest deadlines to the top. Clearing the Status filter restores all tasks, while the sort order may remain. That distinction helps prevent the mistaken impression that filtering has permanently removed or reordered the rest of the records.
Common shortcut and filter problems
- No arrows appear: make sure Excel is active and the selected cell is in the intended range. Check for blank rows or columns splitting the list, or select the full range and try again.
- The wrong row is treated as headings: select the range starting with the true header row. Remove any title rows from the selection, or convert a well-formed range into a table.
- Some records seem missing: look for an active filter icon in the column headings. Open the relevant menus and clear the filter, or use Data > Sort & Filter > Clear to clear active criteria in the range.
- The shortcut types a character or triggers something else: confirm that the worksheet, rather than a cell-editing field or another application, has focus. A laptop may require its function or modifier keys in a different way, and remote-desktop or system keyboard settings can intercept shortcuts.
- New rows are not included: check whether the data is an Excel table. In a plain range, newly appended rows may fall outside the original filtered range; select the expanded range and apply the filter again if needed.
When a filter is active, Excel generally shows a funnel-style indicator on the relevant column’s filter button. That visual cue is useful when a worksheet appears to have lost records. Before concluding that data is missing, clear the filters and inspect the full list. If a filter command is unavailable, check whether the sheet is protected or whether the workbook is in a state that prevents editing.
Windows, Mac, and Excel for the web
The main shortcut in this guide is for Excel on Windows: Ctrl+Shift+L. In Excel for Mac, the corresponding filter toggle is commonly Command+Shift+F. Keyboard behavior can vary with the Mac keyboard, Excel release, or system-level shortcuts, so the dependable menu route is to select the range and choose Data > Filter. In Excel for the web, use the Filter command on the Data tab if the keyboard combination is intercepted by the browser or does not behave as expected.
Menu labels and ribbon layouts can shift slightly between platforms, but the basic workflow is the same: identify the data range, turn on filtering, and make choices from the header arrows. On Windows, Data > Sort & Filter > Filter provides a mouse-accessible alternative to Ctrl+Shift+L. The Home tab also has sorting and filtering controls in its Editing group in many Microsoft 365 layouts.
When to use alternatives
For a one-time review of a list, AutoFilter is usually the quickest choice. If you need a saved, reusable view for a particular audience or task, consider an Excel table or a sheet view where available. Tables keep their headers and filter controls attached to a structured range, while sheet views can help people work with different sorts and filters without changing everyone’s view in a shared workbook.
For a more complex selection that needs to be copied elsewhere, Excel also has the Advanced Filter command on the Data tab. It uses a criteria range and offers options beyond the quick header menus, but it requires more setup. PivotTables are another option when the goal is summarizing and grouping data rather than simply hiding rows. These tools are not replacements for the shortcut in every case: choose based on whether you want to inspect records, create a repeatable view, or analyze totals.
Frequently Asked Questions
What is the shortcut key to filter in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to toggle filter arrows for the current data range. Then use a column arrow to choose what to show.
How do I remove a filter but keep the arrows?
Open the filtered column’s drop-down and choose Clear Filter from that column, or use Data > Sort & Filter > Clear to clear active filter criteria. The filter controls remain available.
Does Ctrl+Shift+L delete hidden rows?
No. A filter hides rows that do not meet its criteria; it does not delete them. Clear the filter to make the rows visible again.
Why is Ctrl+Shift+L not working?
Check that the worksheet is active, the selection is in the intended range, and Excel is not in cell-edit mode. If another application or keyboard setting intercepts the shortcut, use Data > Sort & Filter > Filter instead.
What is the filter shortcut in Excel for Mac?
Command+Shift+F is commonly used to toggle filters in Excel for Mac. If it does not work in your setup, select the range and choose Data > Filter.
Related
- Excel Repair Tools for XLS and XLSX Files: What Works
- Excel Remove Text and Keep Numbers in a Cell
- Excel Remove Numbers From Cells and Keep Text Easily
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Days Until End of Month: Formula and ExamplesWith no input cells needed, enter =EOMONTH(TODAY(),0)-TODAY() to calculate the number of days from today to the last…
- Excel Find and Substitute Formula: Examples and TipsTo find text and replace it in an Excel formula, use SUBSTITUTE: it replaces matching text in a…
- Count Same Values in Excel with COUNTIFTo count how many times a value appears in Excel, use COUNTIF: if the values are in A2:A20…
- Compare Two Dates in Excel: Formulas and FormattingTo compare two dates in Excel, enter this formula in a result cell: =IF(A2<B2,"A is earlier",IF(A2>B2,"A is later","Same…
- Excel Formulas With Text: How to Combine Words and ValuesTo use text in an Excel formula, put literal words inside straight double quotation marks, such as ="Ready".…
- How to Capitalize Every Word in Excel with a FormulaTo capitalize every word in Excel, enter =IF(A2="","",PROPER(A2)) in an empty column beside the text in A2, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.