In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn filter buttons on or off for the selected table or data range. To filter a particular column, select its header cell and press Alt+Down Arrow to open that column’s filter menu.
The shortcut at a glance
Click any cell inside the table or contiguous data range, then press Ctrl+Shift+L. Excel adds drop-down filter buttons to the header row if filters are off; pressing the shortcut again removes those buttons. It does not delete rows or change the underlying values. When a filter is active, Excel hides rows that do not match the criteria, and the visible results can change as you adjust the filter.
For example, imagine a sales list with columns for Date, Region, Product, and Amount. Click a cell in the list and use the shortcut. Each column heading gains a drop-down button, so you can show only a particular region, product, date range, or amount range.
- Turn filter buttons on or off: Ctrl+Shift+L.
- Open the selected header’s filter menu: Alt+Down Arrow.
- Alternative ribbon route: Data > Filter.
The shortcut is a toggle: it changes whether the filter controls are available. It does not automatically choose a value to filter by. You still need to open a column’s menu and select the criteria you want.
What the shortcut changes
Excel’s filter controls let you temporarily narrow the displayed records. If you filter Region to show West, for instance, rows for other regions are hidden from view, but their contents remain in the worksheet. Clear the filter to show those records again. Filtering is different from deleting rows, sorting the list, or applying a visual highlight.
Ctrl+Shift+L turns AutoFilter on or off for the current data area. Excel generally identifies the surrounding contiguous block of data when you start from a cell within it. A completely blank row or column can make Excel treat adjacent data as a separate block, so check where the active cell is if the buttons appear on the wrong section.
For an Excel Table—a structured object created with Insert > Table—filter buttons normally appear in the header row when the table is created. The shortcut can toggle those buttons as well. It does not convert a plain range into a formal Table; it only controls filtering for the relevant data area. A formal Table also provides features such as structured references and automatic expansion when you add adjacent data.
Filter one column with the keyboard
After the filter buttons are visible, you can open an individual column’s menu without reaching for the mouse. Select a cell in the header for the column you want, then press Alt+Down Arrow. The menu contains options that depend on the column’s contents, such as a checklist of text values or date and number filters.
- Use Ctrl+Shift+L if the header buttons are not displayed.
- Select the relevant header cell, such as Region.
- Press Alt+Down Arrow to open its filter menu.
- Choose the values or condition to display, then confirm the selection if the menu requires it.
For a text column, you can usually clear the Select All choice and tick only the values you want, such as West and Central. For a numeric column, options such as Number Filters can let you show values above, below, or between limits. Date columns offer date-oriented choices. The exact options depend on the data type Excel recognizes and the version’s interface.
To restore all rows for a column, open its menu and choose Clear Filter From [column name], or use the menu’s select-all controls to include all values again. Clearing one column’s filter does not necessarily clear filters on other columns, so check the header icons if some rows are still missing.
Tables, ranges, and header rows
Excel uses the word table casually for any rectangular list, but there is a useful distinction. A plain range is a group of cells that may have headings; a formal Excel Table is created through Insert > Table and has built-in table features. Ctrl+Shift+L can add filter buttons to a suitable plain range, so you do not have to convert the data simply to filter it.
Filtering works best when the list has one clear header row and consistent columns. Avoid blank header cells, merged cells in the heading row, and completely blank rows inside the records. Those features can interfere with Excel’s ability to identify the data area or give confusing results. If your list has a title above the headers, click inside the records rather than in the title before using the shortcut.
For a formal Table, click within the Table before toggling filters. If you want to create one, select a cell in the data and choose Insert > Table; confirm that the range is correct and that My table has headers is selected when appropriate. This is optional for filtering, not a requirement for Ctrl+Shift+L.
Filter types and useful examples
The filter menu adapts to the contents of a column. Text filters are useful for lists of names or categories; number filters suit quantities and amounts; date filters help narrow a schedule or transaction list. Excel also lets you filter by selecting individual visible values. You can combine filters across columns: choosing West in Region and a particular product in Product shows records meeting both choices.
- Category example: In a Status column containing Open, In progress, and Closed, select Open to focus on unfinished items.
- Number example: In an Amount column, use a number condition to display values above a chosen threshold.
- Date example: In a Date column, use the date menu to narrow the list to a month or date interval.
- Combined example: Filter Region to West and Status to Open to display only open items assigned to that region.
These filters are not the same as sorting. Sorting changes the order of records; filtering controls which records are shown. You can use both at once, but sorting a list does not remove records from view, and filtering does not necessarily put the remaining records in a new order.
Windows and Mac keyboard options
The Windows shortcut for toggling filters is Ctrl+Shift+L. On Excel for Mac, the commonly used equivalent is Command+Shift+F. Keyboard shortcuts can vary with Excel releases, keyboard layouts, or system-level shortcuts, so if that key combination is intercepted or does not work, use the ribbon command Data > Filter. The ribbon is also a straightforward way to confirm whether filter controls are on.
On Windows, Alt+Down Arrow opens the filter menu for the selected header cell. Mac keyboard navigation can differ, and some Mac keyboards require an Fn key for certain arrow or function-key behavior. If you cannot open a menu with the keyboard, click the header’s filter button instead. Excel for the web also has filter controls on the Data tab; shortcut behavior may depend on the browser and keyboard configuration, so the ribbon command is a dependable alternative there.
Common problems and quick fixes
If Ctrl+Shift+L appears to do nothing, first click a cell inside the data. A cell outside the list may lead Excel to apply the command to a different region or not produce the expected result. Then check Data > Filter to see whether filtering is enabled. If the buttons are present already, the shortcut may have turned them off rather than on.
- Buttons appear on the wrong row: Check that the selected cell is inside the intended list and that the header row is clearly separated from any title.
- Some records seem missing: Look for active filters on every column. A funnel-shaped icon indicates a filter is applied; use that column’s menu to clear it.
- Only part of the list is included: Check for blank rows or columns splitting the data, and verify the range used by the filter.
- The menu options look unsuitable: Check that values in the column use a consistent data type. Numbers stored as text, for example, may not behave like ordinary numeric values.
- The shortcut conflicts with another action: Use Data > Filter, or check whether a keyboard utility or operating-system setting is intercepting the keys.
One common misconception is that removing filter buttons clears the filter in the same way as showing all records. When you toggle filtering off, the controls disappear; when you need to restore visibility while retaining the controls, clear the filter from the relevant column instead. If the result is confusing, turn the controls back on and inspect each column’s menu.
Good habits for reliable filtering
Give each column a descriptive, nonblank heading, keep one record per row, and avoid mixing unrelated kinds of information in one column. For instance, keep dates as dates rather than combining a date and a note in the same cell. Consistent data makes Excel’s text, number, and date filter choices more predictable.
Before sharing a workbook, consider whether a filter is still hiding rows. The filter state can remain in the file, which may make another person think records are missing. Clear filters when you want to show the full list, or leave them in place and make the selected criteria obvious. If the sheet is protected or shared in a restricted way, commands may also be limited by those settings.
Finally, filtering does not make a separate copy of the displayed records. If you need an independent extract, copy the visible results to another location and verify what is included. Be especially careful when copying filtered data, because hidden rows and visible rows can be easy to confuse. For ordinary review and analysis, however, the built-in filter is usually a fast, reversible way to focus on a subset of a list.
Frequently Asked Questions
What is the Excel shortcut to add filters?
In Excel for Microsoft 365 on Windows, click inside the data and press Ctrl+Shift+L. It toggles filter buttons on or off.
How do I filter a single column with a keyboard?
Select that column’s header cell and press Alt+Down Arrow to open its filter menu. Then choose the values or condition to show.
Does Ctrl+Shift+L turn a range into a Table?
No. It adds or removes filter controls for a suitable range or existing Table. To create a formal Table, use Insert > Table.
How do I remove a filter but keep the drop-down buttons?
Open the filtered column’s menu and choose Clear Filter From that column. Ctrl+Shift+L toggles the filter controls themselves.
What is the filter shortcut on a Mac?
In Excel for Mac, use Command+Shift+F. If it does not work in your setup, choose Data > Filter from the ribbon.
Related
- Excel Paste Numbers as Text? Keep IDs, Zeros, and Codes
- Excel Paste in Reverse Order: Practical Methods
- Excel Password Protect to Keep a Workbook from Opening?
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Schedule an Email Reply in OutlookTo schedule a reply in Outlook, open the message, choose Reply, write your response, and use Schedule send…
- How to Make Every Other Line a Color in Excel QuicklyTo make every other line (row) a color in Excel, select your data rows, then choose Home >…
- Remove a Section Break in Word Without Wrecking LayoutTo remove a section break in Microsoft Word for Microsoft 365 on Windows, choose Home > ¶ to…
- How to Link a Drop-Down List in ExcelTo link a drop-down list in Excel to a range, select the destination cell, choose Data > Data…
- Find and Replace Highlight Color in Microsoft WordIn Word for Microsoft 365 on Windows, use Home > Find, then search for the Highlight format and…
- How to Add a Header Underline in Word for Every PageTo add a line beneath a header in Microsoft Word, open the header, click its paragraph, then choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.