To show rows for several names in an Excel filter, open the filter arrow in the names column, clear the current selections if needed, check each name you want, and choose OK. Excel will display rows matching any of those names. First make sure your data has a header row and that the filter covers the full list of records.
What You’ll Need
- An Excel worksheet with names in one column and a clear header, such as Name.
- A continuous data range or an Excel table. Each row should represent one record, and the header should be in the first row of the range.
- Microsoft Excel for Microsoft 365 on Windows. Excel for Mac and Excel for the web have similar filter checkboxes; differences are noted below.
Step-by-Step
- Check the layout of your data. Make sure the names column has a header and that there are no completely blank rows or columns splitting the records. Avoid merged cells in the header. If the list is already formatted as a table, its header should have filter arrows. Otherwise, click a cell inside the data range and choose Data > Filter. Excel adds a dropdown arrow to each header. You can also make a table with Insert > Table; confirm that My table has headers is selected if your first row contains column names.
- Open the filter for the names column. Click the arrow beside the Name header, or the relevant column heading in your sheet. The dropdown shows available names with checkboxes, along with a search box. If the arrow is missing, click inside the data and turn filtering on from Data > Filter. Check that you opened the names column’s arrow rather than another column’s.
- Start with a clean selection when necessary. If the column already has a filter, the list may show only some names as selected. To remove just that column’s criteria, choose Clear Filter From [column name] in its dropdown. Reopen the menu after clearing it. With all names available again, click Select All once to clear the checkboxes, then select only the names you need. If the list is already unfiltered and all boxes are checked, this is the usual one-click way to start a multiple-name selection.
- Check every name you want to include. Click the checkbox beside each name. For example, to show records for Ana, Jordan, and Priya, leave those three checked and the other names unchecked. The filter works as an “or” choice: a row is shown if its name matches Ana or Jordan or Priya. You do not need to hold Ctrl while checking names. If a name appears more than once in the column, one checkbox includes all rows with that value.
- Use search for a long list, if helpful. Type a name or part of one into the dropdown’s search box. Check the matching name, then remove the search text to find another name and check that one too. The checks you have made should remain selected as you search. Repeat for each name, then review the checklist after clearing the search text. Do not use Select All while the list is narrowed by a search unless you intend to change the selection for the filtered results.
- Apply and verify the filter. Click OK at the bottom of the dropdown. Excel hides rows that do not match your checked names; it does not delete them. Look for the filter icon on the column heading and check that the visible rows include each requested name. If some results are missing, reopen the dropdown and confirm the names are checked, then apply again.
You can select multiple names in more than one column, too. For example, filter Name to a group of people and Department to one department. Excel then displays rows that meet the selection in both columns: one of the chosen names and the chosen department. This is different from choosing several names within one column, which matches any of those names.
Common Mistakes
Leaving Select All checked. If every name is checked, the filter includes the whole list and may look as if it did nothing. In the dropdown, clear the selection and then check only the names you want. If the checklist is in a mixed state because a filter was already active, clear that column’s filter first so you know which values are available.
Searching but forgetting to select the result. Typing a name into the search box only narrows the displayed checklist; it does not necessarily apply that name as a filter. Tick its checkbox, clear the search, and check the other names before choosing OK.
Expecting different columns to work as OR choices. Multiple checked names in one column are combined as alternatives. Filters in separate columns are combined as requirements. If you choose Ana or Jordan in Name and Sales in Department, a row must match one of those names and Sales.
Using inconsistent text values. A dropdown lists distinct cell values, so “Sam Lee” and “Sam Lee ” (with an extra trailing space) can appear as separate entries. Similar-looking spelling differences, initials, or different punctuation may also represent separate values. Check the source cells if a name seems missing or duplicated.
Filtering only part of the records. If the filter was added to a selection that omitted some rows, those records will not be included in the dropdown’s results. Keep the data together as one range or table, and avoid blank rows that may cause Excel to detect only part of the list.
Tips
Convert a growing list to a table. A table is useful when you add records often because it keeps headers and filters together and expands when new rows are entered directly below it. Create one with Insert > Table, and give the name field a clear heading. If new data is outside the table, add it to the table before filtering so Excel includes it.
Use search for scattered values, checkboxes for a short list. When the names are visible together, checking them directly is fastest. When the list is long, search for one value at a time, check it, clear the search, and continue. Before applying, remove the search text so you can inspect the full checklist and confirm that the intended values remain selected.
Keep a note of the chosen names. For a recurring report, write down the names or keep a separate criteria list. This makes it easier to repeat the selection and to notice if a name has changed in the source data. If you need a frequently reused visual control, consider adding a slicer to a table using Table Design > Insert Slicer, then select multiple name buttons in the slicer.
Know how to show everything again. Open the names dropdown and choose Clear Filter From [column name] to restore all names in that column. To remove filters from the whole range, use Data > Clear. Clearing a filter unhides rows; it does not change the underlying data or remove the dropdown arrows.
Mac and web users: In Excel for Mac, use the filter arrows or Data > Filter; the exact layout of the dropdown can differ slightly by release. Excel for the web also offers filter dropdowns with searchable checkbox lists. If a button is positioned differently, look for the same column arrow and checkbox controls rather than relying on the Windows ribbon layout.
Troubleshooting
The filter arrow is not visible. Click a cell in the data and choose Data > Filter. If the range is a table, check that the header row is displayed and that filter buttons have not been turned off in the table settings. Also check whether the worksheet is protected; protection settings may prevent changing filters.
A name is not in the checklist. Clear the active filter in that column and search the source cells for the name. It may be outside the filtered range, misspelled, or stored with extra spaces or different punctuation. If you add a new row, make sure it is part of the table or range, then reopen the dropdown. A refreshed list can reveal values that were not present when the filter was first set up.
Only one name appears after applying. Reopen the filter and inspect the checkboxes. If you typed in the search box and then clicked a result, you may have selected only that one value. Clear the search text, search for each additional name, and tick its box before clicking OK. Also make sure you are filtering the intended column.
Rows you expected are still hidden. Another column may have an active filter, or the selected name may have a slightly different spelling in those rows. Check for filter icons in other headers and clear any criteria that should not apply. Remember that different column filters work together, so a row must satisfy all active column filters to remain visible.
The visible rows look incomplete or the filter behaves oddly. Confirm that the data range includes every record and that its first row is a header, not a data entry. Remove blank separator rows and merged cells where possible. If the worksheet is grouped, protected, or in an unusual view, return to a normal worksheet view and check whether the filter controls are available. You can clear filters and apply them again after correcting the range.
Frequently Asked Questions
Can I select several names in one Excel filter?
Yes. Open the column’s filter dropdown, clear Select All, check each name to include, and click OK. Excel displays rows matching any of those selected names.
Do I need to hold Ctrl to choose multiple names?
No. In a standard Excel filter checklist, each checkbox toggles a value independently. Check the names you want and leave the others unchecked; Ctrl-clicking is not required.
Can I select names that are not next to each other in the list?
Yes. The checklist does not require adjacent values. You can check names in any order, or use search to locate one name at a time and preserve each selection as you clear and change the search text.
How do I filter for several names in a PivotTable?
Open the PivotTable field dropdown. For a Report Filter, enable Select Multiple Items, check the names, and apply the selection. Row and column field dropdowns also have item checkboxes. PivotTable controls differ from the regular table filter described above.
Can I choose names in two columns at the same time?
Yes, but Excel combines different column filters as AND conditions. For example, selecting several names and one city shows rows for any selected name in that city, not every selected name across all cities.
Will filtering delete the other names or rows?
No. A filter hides rows that do not meet the criteria. Clear the filter to show them again. Do not confuse filtering with deleting rows or copying only the visible results to another location.
Related
- How to Repair Excel Desktop App: Windows Steps and Fixes
- Rename a Sheet in Excel Without a Mouse
- How to Rename a Sheet in Excel Using the Keyboard
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Text Filter Wildcards: How to Use ThemIn Excel for Microsoft 365 on Windows, text-filter wildcards let you match patterns: use * for any number…
- Conditional Formatting Custom Formula: Excel RulesIn Excel for Microsoft 365 on Windows, a conditional formatting custom formula is a TRUE-or-FALSE formula that decides…
- Function Call Split? How to Divide Calls in ExcelYes, you can split a function call in Excel by nesting one function inside another, separating arguments with…
- String Handling Functions in C: A Practical GuideC string-handling functions are declared in the standard header <string.h> and work with null-terminated character arrays. The most-used…
- Excel Filter Dates by Month: Quick Steps and FixesTo filter dates by month in Excel, select a cell in your date column, choose Data > Filter,…
- Excel Formulas: Function List, Categories & ExamplesThere is no single finite list of every Excel formula: a formula is any expression you build, while…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.