In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off; this shortcut does not select multiple filter values for you. To show several values, open the column’s filter arrow, leave the values you want checked in the checklist, and click OK. Excel has no single shortcut that automatically chooses an arbitrary set of values.
What the Excel filter shortcut does
Ctrl+Shift+L is a toggle for AutoFilter. Select a cell in a data range with a header row, then press the shortcut to add filter arrows to the headers. Press it again to remove the AutoFilter controls. You can also use Data > Filter on the ribbon. If the range is an Excel table, its header row normally already has filter arrows, so you can go straight to the column you want.
The shortcut changes whether the filtering controls are available; it does not open a dropdown or choose particular entries. That distinction matters because the phrase “select multiple values shortcut” can mean two different tasks: turning filters on, or deciding which values should remain visible. Ctrl+Shift+L handles only the first task. The value selection is made in the dropdown checklist.
Select several values from a column
Use the column’s filter menu when you want to show specific entries, including values that are not next to one another in the list. For example, a Sales table might contain regions West, East, Central, and South. You can display West and South together while hiding East and Central.
- Click the filter arrow in the column header, such as Region.
- In the checklist, clear Select All. This clears the current selections in the displayed value list.
- Check each value you want to keep, such as West and South.
- Click OK. Excel hides rows whose Region value does not match one of the selected values.
For an existing filter, the checklist reflects the current selection. If you want to add another value without losing the ones already shown, open the menu and check the additional value; do not clear Select All first. Clearing that box is useful when you want to start a new selection from scratch. The label and checkbox state can be confusing when some, but not all, values are selected, so inspect the individual entries before applying the change.
Use the search box in the filter menu
A long checklist can be slow to scan. Many AutoFilter menus include a search box that narrows the displayed list as you type. Search for a value, select its checkbox, then search for another value and select that one as well. The search narrows what is shown in the menu; it is not itself the same as applying a text filter. Confirm that each desired value is checked before clicking OK, especially if the list is long or the search terms overlap.
Search is particularly helpful for a list of product names, customer IDs, or locations with many distinct entries. It does not create a “contains any of these phrases” rule by itself. It helps you locate checklist entries and choose them. If you need a rule such as “contains north or begins with west,” use a text condition instead, or add a helper column if the criteria are more involved.
Can you make the selection with the keyboard?
The reliable shortcut to remember is Ctrl+Shift+L for the filter controls, not for choosing multiple values. In Windows Excel, pressing Alt+Down Arrow while a cell in a filtered column is active can open that column’s filter dropdown. The menu’s available keyboard navigation can depend on the control currently in focus and the version of Excel, so there is no universal, simple keystroke sequence that replaces checking an arbitrary group of boxes and confirming the menu.
If you need to use the keyboard, open the dropdown and follow the focus cues in the menu, using Tab and the arrow keys to move between controls or choices where available. Use Space to change a focused checkbox and Enter to activate a focused button when the menu has focus. If that is awkward, the mouse-operated checklist is usually clearer and less error-prone. Do not confuse Alt+Down Arrow with Ctrl+Shift+L: the former opens a dropdown in the appropriate context, while the latter toggles filter arrows.
What happens to rows that are not selected
Filtering hides rows that do not meet the selected criteria; it does not delete them. In the Region example, choosing West and South leaves matching rows visible and hides East and Central rows. Clear the filter later to bring those rows back. This is different from sorting, which changes row order, and from deleting rows, which removes data from the worksheet.
More than one column can be filtered at the same time. For instance, select West and South in Region, then select a date range in Order Date. Excel displays rows that meet the conditions from both columns: a row must be in one of the selected regions and also meet the date filter. Within a single checklist, the selected values act as alternatives; across separate columns, filters combine to narrow the results.
Common problems and fixes
- The filter arrow is missing: Click inside the data range and choose Data > Filter. Check that the range has a header row and that blank rows or columns have not split the data into separate blocks.
- Select All does not behave as expected: It selects or clears the entries represented in the checklist, not necessarily every possible value in the worksheet. Check whether another filter is already limiting the visible records.
- A value seems to be missing: Another column’s active filter may hide every row containing it. Clear other filters temporarily and check for spelling differences, extra spaces, or values that look alike but are stored differently.
- The checklist shows only part of the data: Excel may be filtering a range that does not include all the rows, or a prior filter may still be active. Use Data > Clear to clear filters, then check the range and header row.
- New rows are not included: A plain filtered range may not expand as expected in every layout. Converting a well-formed range to a table with Insert > Table can make ongoing data management easier; table headers include filter controls.
Also check for blank cells and duplicate-looking values. A checklist usually lists distinct entries, so repeated instances of West appear as one choice, not as a separate checkbox for each row. A blank entry may be listed separately. Selecting a value filters by the value in the column, not by a particular row or by the position of the entry in the checklist.
When to use a different filter method
The checkbox list is best for choosing a known set of distinct values. If the goal is based on a rule rather than a list, open the column dropdown and use the applicable text, number, or date filter. For example, a number filter can show values greater than a threshold, and a date filter can narrow records to a period. Text filters can express conditions such as begins with or contains, with the available choices depending on the data type.
For repeated interactive filtering, a slicer can be easier to use than a dropdown. Slicers are visual buttons available for Excel tables and PivotTables; select a button to filter, and use the slicer’s multi-select control when choosing several items. A slicer is not a keyboard shortcut, and it takes worksheet space, but it makes the active choices visible. For a one-time selection from a modest list, the normal filter checklist is usually the quickest option.
Excel for Mac and Excel for the web
On Excel for Mac, use Data > Filter to show or hide filter controls, then use the header dropdown’s checklist to select multiple values. Keyboard shortcuts can differ with the Mac keyboard, Excel version, and system settings, so the ribbon command is the dependable route if Ctrl+Shift+L is not appropriate on your setup. The principle is the same: enabling filters and choosing the values are separate actions.
In Excel for the web, use the Data tab and the filter dropdowns in the header row. Browser shortcuts may be intercepted by the browser or vary by device, so the on-screen controls are a good choice when a desktop shortcut does not work. Excel tables also provide header filter controls in the web app. In every version, selecting multiple checklist entries means checking each desired value, not holding a modifier key while clicking the header arrow.
Frequently Asked Questions
What is the shortcut to turn on filters in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to toggle AutoFilter. You can also choose Data > Filter. The shortcut does not pick values in a column’s filter menu.
How do I select multiple items in an Excel filter?
Open the column’s filter dropdown, check every value you want included, and click OK. Clear Select All first only when you want to replace the current selection with a new one.
Can I select multiple filter values without a mouse?
You can open the dropdown with Alt+Down Arrow in the appropriate context and navigate its controls with the keyboard. The exact navigation depends on focus and the Excel interface; there is no single shortcut for choosing any set of values.
Does filtering delete the rows I uncheck?
No. A filter hides rows that do not match the selection. Clear the filter to show those rows again; filtering is not a delete operation.
Why can’t I see a value in the filter list?
Another active filter may be hiding its rows, or the filtered range may not include all your data. Clear filters and check the range, then look for spelling, spacing, or blank-cell differences.
Can I filter several columns at once?
Yes. Apply a filter to each column as needed. Excel shows rows that satisfy the selections across the filtered columns, which is useful for combining a set of categories with a date or status condition.
Related
- Excel Data Validation List Based on Selection: How-To
- Excel Data Validation List Character Limit Explained
- Excel Data Validation List: Build a Dynamic Source
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Days Until Formula: Calculate a CountdownTo calculate calendar days until a date in Excel, put the target date in A2 and enter =A2-TODAY()…
- Copy Formulas in Excel Across Rows: A Simple GuideTo copy a formula horizontally, select its cell and drag the small fill handle at the lower-right corner…
- Excel Not Equal to Blank: Formulas, Examples, and FixesTo test whether a cell is not blank in Excel, use the not-equal operator with an empty string:…
- Excel COUNTIF for Dates Between a RangeTo count dates between two boundaries in Excel, use COUNTIFS, which applies both a start-date and an end-date…
- Excel Formula to Randomly Select From a ListWith names in A2:A20, use =INDEX(A2:A20,RANDBETWEEN(1,ROWS(A2:A20))) to return one randomly chosen entry. The formula selects a row position…
- Excel Consolidate Function: How to Combine DataTo use Excel’s Consolidate function, select the top-left cell for the results, then choose Data > Consolidate, select…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.