In Excel for Microsoft 365 on Windows, there is no single dedicated shortcut that immediately filters a list to the value in the selected cell. Right-click the cell and choose Filter > Filter by Selected Cell’s Value; to turn filter arrows on or off, use Ctrl+Shift+L.
The quickest way to filter to a selected value
Use the selected cell’s value command when you want to see rows that match the entry you already have in front of you. First, click a data cell—not a header—in the column you want to filter. Right-click it, point to Filter, and select Filter by Selected Cell’s Value. Excel applies a filter to that column and hides rows that do not match.
For example, if a table has a Region column and you right-click a cell containing West, the result is a list showing records whose Region value is West. The other records are hidden, not deleted. Clear the filter later to display them again.
The context-menu wording or placement can differ slightly by Excel version, selection, or data layout. If you do not see the command, use the column’s filter dropdown and select the same value there. The dropdown route is also useful when you want to check the criteria before applying them.
What Ctrl+Shift+L does—and what it does not do
Ctrl+Shift+L toggles AutoFilter for the current data range. When the range has headers, Excel adds or removes dropdown arrows in the header row. Those arrows let you choose values, search, or set more detailed conditions. The shortcut does not by itself choose the selected cell’s value, so it is a setup or filter-control shortcut rather than a one-step value filter.
If the filter arrows are not showing, click inside the list and press Ctrl+Shift+L. Then use the dropdown in the relevant column to select the value. You can also use the ribbon path Data > Filter. In Excel for Mac, the commonly used toggle is Command+Shift+F; if that key combination is intercepted by macOS or behaves differently in your installation, use Data > Filter instead.
Be aware that toggling AutoFilter off is different from clearing one column’s criteria. Turning the feature off removes the filter controls and may show previously hidden rows. To keep the arrows and simply show all values in one column, open that column’s dropdown and choose Clear Filter From [Column Name] or select all values.
Step-by-step setup for a reliable filter
Excel needs to identify the header row and the records that belong to the list. A clean layout makes both the shortcut and the selected-cell command more predictable. Before filtering, check that the data has one header row and that each column contains a consistent type of information.
- Put a distinct label at the top of each column, such as Date, Region, or Status.
- Keep each record on one row. Avoid completely blank rows or columns inside the list, because they can make Excel detect only part of the data.
- Click a cell within the list. If filter arrows are absent, press Ctrl+Shift+L or choose Data > Filter.
- Click a value cell in the column to filter, then right-click and choose Filter > Filter by Selected Cell’s Value.
- Check the column’s dropdown to confirm the filter is active. Clear or change its criteria when you need to see other records.
For a frequently used dataset, consider converting the range into an Excel table with Insert > Table. Confirm that the range includes the headers and that My table has headers is selected. Tables include filter dropdowns in their header row and generally expand as new records are added below or beside the table. Filtering by a selected cell still applies to the column containing that cell.
How filtering by a cell value works
Excel applies a criterion to the selected cell’s column, not to the whole row as a single unit. Each row remains visible only if its entry in that column meets the criterion. Other columns are not independently filtered, although their values appear alongside the matching records. This makes the command handy for narrowing a long list without opening the dropdown and finding the value manually.
Suppose an order list has Customer, Status, and Amount columns. Right-clicking a cell that says Pending in Status filters the list to pending orders. The amounts and customer names remain visible for those rows. If you then filter Amount as well, both criteria apply together: a row must pass the Status filter and the Amount filter to remain visible.
Filters do not rearrange or erase the underlying records; they control which rows are displayed. Copying or calculating from a filtered list can have separate implications, so do not assume that every operation automatically ignores hidden rows. If you need a permanent subset, copy the visible results to another area and verify what was copied before changing the source data.
Text, numbers, dates, and blanks
The selected-cell command is simplest when the column contains consistent entries. For text such as West or Pending, it filters for matching text. For numeric data, it can isolate the selected number. Excel’s dropdown also offers richer criteria when an exact-value match is not what you need: Text Filters can find entries that begin with or contain text, Number Filters can compare amounts, and Date Filters can group or select dates.
Dates deserve a quick check because Excel stores dates as serial values and may display them with different formats. A date shown as 3/4/2026 might be interpreted according to the workbook’s regional settings, and a date filter may offer choices grouped by year, month, or day. If the result seems unexpected, check the cell’s actual value and the criteria in the dropdown rather than relying only on how the date is displayed.
Blank cells can also affect results. The selected-cell command may not be available in the same way for a blank cell; use the column dropdown and choose (Blanks) or (Select All) as appropriate. A cell that looks blank may contain a space or a formula returning an empty string, which is not necessarily treated exactly like a truly empty cell.
Keyboard options when you want fewer mouse steps
For a keyboard-first workflow on Windows, Ctrl+Shift+L turns the filter controls on, and the arrow keys can move through cells and header dropdowns. Alt+Down Arrow opens the filter dropdown for the active cell when that cell is in a filtered column. From the dropdown, use its search box or value list to choose the criterion, then apply it. Exact navigation depends on the dropdown contents and Excel build.
You can also select a value cell and press Shift+F10 to open its context menu, which is the keyboard equivalent of right-clicking in Windows. Use the arrow keys to reach Filter and its submenu, then choose the selected-cell value command if it is present. Context-menu navigation can vary with the Excel version and the available commands, so there is no dependable fixed sequence of letter presses for every workbook.
On laptops, the function-row setting may mean you need Fn+Shift+F10 to open the context menu. On Mac, Control-click or a two-finger click can open the contextual menu; the ribbon or column dropdown is a dependable alternative if the menu is different. Excel for the web also provides filter controls, but browser shortcuts and context-menu behavior can vary. Use Data > Filter and the header dropdown when a keyboard shortcut is unavailable.
Common problems and practical fixes
- No Filter command appears: Make sure you clicked a cell inside the data body rather than a title, blank area, or header. Turn on AutoFilter with Data > Filter, and check that the list has a clear header row.
- Only part of the list gets filter arrows: Look for a blank row or column splitting the data. Remove the break if appropriate, or select the intended range before turning on Filter. Converting a well-formed range into a table can help keep the data boundary clear.
- Some matching-looking values disappear: Check for extra spaces, inconsistent spelling, different number formats, or dates stored as text. Excel filters the underlying entries, and two values that look similar on screen may not be identical.
- Rows seem missing after filtering: Check every column for an active filter, not just the one you last changed. Clear the individual column filter or use Data > Clear to remove filter criteria while keeping the list available.
- The command filters the wrong column: The selected cell determines the column criterion. Click a body cell in the intended column before opening the context menu.
Merged cells inside a list, duplicate or missing headers, and totals placed among ordinary records can also make a range awkward to filter. A straightforward rectangular dataset—with one header row and one record per row—is easier to sort, filter, and expand safely.
Selected-cell filtering versus the dropdown
Use Filter by Selected Cell’s Value when the desired criterion is already visible in a body cell and you want the shortest route. It is particularly convenient for quickly investigating a category or status in a large list. Use the dropdown when you need to search for a value, include several values, choose blanks, or define a condition such as contains, greater than, or a date range.
The two methods use the same underlying AutoFilter controls; neither makes a separate copy of the data. For basic tasks, the difference is convenience. For multi-column analysis, apply a dropdown criterion in each relevant column and check all active filters before concluding that a record is absent.
Frequently Asked Questions
Is there a shortcut to filter by the selected cell’s value in Excel?
There is no dedicated one-key shortcut that applies that exact criterion. Right-click a body cell and choose Filter > Filter by Selected Cell’s Value. Shift+F10 opens the context menu from the keyboard on Windows, while Ctrl+Shift+L toggles the filter arrows.
Does Ctrl+Shift+L filter the selected value?
No. It turns AutoFilter controls on or off for the detected data range. After turning them on, use a header dropdown to choose a value, or use the selected-cell command from the context menu.
Will filtering by a cell value delete other rows?
No. Filtering hides rows that do not meet the criteria; it does not delete them. Clear the filter to show the hidden records again.
Can I filter by more than one value or column?
Yes. Use a column dropdown to select multiple listed values, or apply criteria in more than one column. When filters are active in multiple columns, a row must meet the criteria in each filtered column to remain visible.
Why can’t I see Filter by Selected Cell’s Value?
Check that the selected cell is in the data body and that AutoFilter is available for the list. If the command still does not appear, open the column’s header dropdown and select the desired value there; this also gives access to blanks and more detailed criteria.
Related
- Excel Rank Ties Without Skipping Numbers
- Excel Randomize List of Names: 10 Reliable Methods
- Excel Quote Template With Drop-Down Lists That Work
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Round Excel Numbers to the Nearest Ten With a FormulaTo round a number to the nearest ten in Excel, use the ROUND function with -1 as its…
- Sort Excel Data by Date: Steps and TroubleshootingTo sort Excel data by date, select the entire table or the date column within it, then choose…
- Excel CONCAT: Join Cell Values with a FormulaTo combine cell values in Excel, use the CONCAT function: with text in A2 and B2, enter =CONCAT(A2,B2)…
- Microsoft Excel Lookup Function Examples That WorkFor most exact-match lookups in Microsoft Excel for Microsoft 365, use XLOOKUP: with product codes in A2:A6, prices…
- Excel Keep Duplicates: Remove Unique RowsTo keep every row whose value appears more than once, add a helper formula such as =COUNTIF($A$2:$A$8,A2)>1, fill…
- Excel TEXT Function Format Options and Examples ExplainedExcel’s TEXT function converts a number, date, or time into text displayed with a format code: use =TEXT(value,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.