To filter by name in Excel, select a cell in your data, choose Data > Filter, then use the dropdown in the name column to search for or select the names you want to see. Filtering hides rows that do not match; it does not delete them. Start with a clearly labeled list, with one header row and a name in each row.
What You’ll Need
- An Excel workbook containing a list of names, such as customer, employee, or attendee records.
- A header row with a clear label for the name column, such as Name or Customer Name.
- The full list arranged in a continuous range, with no completely blank row or column splitting the records.
The instructions below are for Excel for Microsoft 365 on Windows. The same basic filter controls are available in Excel for Mac and Excel for the web, though the ribbon layout can differ slightly. If you have several columns of related information, such as a name, email address, and order total, keep each person’s details on the same row so the filter hides or shows the whole record.
Step-by-Step
- Check the layout of your data. Make sure the first row contains a separate heading for each column and that each record begins directly below it. For example, a simple list might have Name in A1, Department in B1, and Email in C1, with the people listed from row 2 onward. Avoid merged cells in the header and remove completely blank rows within the list. These checks help Excel identify the whole range rather than filtering only part of it.
- Click inside the list. Select any cell in the data, including a name or another field. You usually do not need to drag over the entire range: Excel can detect a connected block of records from the active cell. If the worksheet contains separate blocks of data close together, select the complete range you want to filter first, including its header row, so Excel does not include unrelated cells.
- Turn on the filter arrows. On the ribbon, choose Data > Filter. A dropdown arrow should appear beside each column heading. In Excel for Mac, use the Data tab and choose Filter; in Excel for the web, use Data > Filter. If arrows appear on the wrong row, switch filtering off, correct the header or selection, and turn it on again.
- Open the dropdown for the name column. Click the arrow beside Name, Customer Name, or the heading that contains the names. Do not use a different column’s dropdown unless you intend to filter by that field instead. The menu shows the values Excel found in that column, along with search and text-filter controls.
- Choose how to match names. To find a particular person, click the search box in the dropdown and type all or part of the name. Excel narrows the checklist to matching entries. Select the checkbox beside the name or names you want to keep, and make sure other unwanted entries are unchecked. You can also clear Select All and then select only the required names. Click OK to apply the selection.
- Use a text condition for a broader match. If you want every name containing a word or letter sequence, open the name dropdown and choose Text Filters, then select an option such as Contains, Begins With, or Ends With. Enter the text in the dialog and confirm. For example, Contains with Lee can return names such as Lee, Leeman, or Ashley, depending on the values in the column. Use an exact checklist selection when you need only one specific full name.
- Review the visible records. Excel hides rows that do not match, while the row numbers skip over hidden rows. Check that the remaining names are the ones you intended and that their other details still appear alongside them. A filter affects the whole record row, so an email address or department should not become detached from its person’s name. If the result is unexpected, reopen the dropdown and review the search text and checked values.
- Change or remove the filter when finished. To show all names again but leave the filter arrows available, open the name dropdown and choose Clear Filter From the name column, or use Data > Clear to clear filters on the range. To remove the arrows as well, choose Data > Filter again. Clearing a filter reveals hidden rows; it does not erase any records.
If the list is an Excel table, its headers already include filter arrows when filtering is enabled, and new rows added directly below the table are generally included automatically. To make a plain range into a table, select a cell in the range and choose Insert > Table, confirming that the table has headers. Tables are useful for lists that grow over time, but they are not required for filtering by name.
Common Mistakes
- Filtering the wrong column: A list may have several dropdown arrows. Open the one beside the name heading, not a department, date, or status heading.
- Leaving old selections active: A filter can retain checked values from a previous search. If expected names are missing, open the dropdown, clear the old search, and inspect the checkboxes before applying the new selection.
- Assuming hidden means deleted: A filtered-out row is still in the workbook. The row numbers may jump, which is normal. Clear the filter to display all records again.
- Selecting only the name cells: Sorting or filtering a single column separately from its related columns can scramble which details belong to which person. Apply the filter to the complete list so each row remains together.
- Including a blank or unclear header: If the first row is empty, contains merged cells, or is actually a data row, Excel may identify the range incorrectly. Give every column a unique, descriptive heading and keep the headings on one row.
Tips
- Use search for long lists. Scrolling through hundreds of checkbox values is slower than typing a distinctive part of a name in the dropdown search box. Review the matches before clicking OK, especially if several people share a surname.
- Use Contains when names are inconsistent. A text condition can find a fragment even when the list includes different first names or additional words. For example, filtering for a surname fragment may locate entries with middle initials or suffixes as well. Check the returned rows to make sure the fragment identifies the people you intend.
- Remember that filtering is not sorting. Filtering controls which rows are visible; it does not arrange the remaining names alphabetically. To alphabetize the visible list, use the name dropdown’s sort options, such as Sort A to Z, or use Data > Sort when you need more control.
- Combine filters when useful. You can filter the name column and then filter another column, such as Department, to narrow the visible records further. Excel shows rows that meet the active filters together. If the result seems too small, check whether another column still has a filter applied.
- Keep a source copy for important lists. Filtering is reversible, but a separate untouched copy can make it easier to compare results or recover from accidental edits. If you share the workbook, tell collaborators when some rows are hidden by a filter.
Troubleshooting
No dropdown arrows appear: Click inside the list and choose Data > Filter. If that does not help, confirm that the worksheet or workbook is not protected in a way that prevents filtering, and check whether you selected a range with a blank row separating the header from the records. A merged heading can also interfere with a clear filter range; unmerge it and use one heading per column.
The name I need is not in the checklist: Clear any text in the dropdown search box and make sure the filter is not narrowing the list with an earlier condition. Then check that the value actually exists in the name column and that Excel’s selected range includes its row. Differences such as a middle initial, extra space, or spelling variation can make a value different from the one you expect. Searching for a shorter, distinctive fragment can help locate it.
The filter shows too many or too few names: For a checklist selection, verify the checkboxes individually and make sure Select All has not left unwanted values selected. For Text Filters, confirm whether you chose Contains, Begins With, or Ends With, and check the text entered in the condition. Contains intentionally includes longer names that have the entered text somewhere inside them.
Some records seem to have vanished: Clear the filter from the name column and any other filtered columns. Also check for manually hidden rows: clearing a filter will not unhide rows that were hidden separately. If you need all records visible, select the relevant rows, right-click a row heading, and choose Unhide where available.
New names are not included: If you are filtering a plain range, a row added below the range might not be part of it. Turn off the filter, expand or reselect the complete range, and apply the filter again. Converting a regularly updated list to an Excel table can help its range expand as you add records.
Frequently Asked Questions
Can I filter for more than one name at once?
Yes. Open the name dropdown, search for a value if helpful, and select the checkboxes for each name you want to show. Apply the selection to display rows for all checked names.
Can I filter by part of a name?
Yes. Search for a fragment in the dropdown, or choose Text Filters > Contains and enter the fragment. Contains can return multiple full names, so check the visible results for unintended matches.
Does Excel’s name filter distinguish uppercase and lowercase?
No. The standard AutoFilter search and text conditions are not case-sensitive, so a search for Lee can match lee or LEE. If capitalization matters, ordinary filtering is not a way to separate those entries.
Can I filter a name column that has duplicate names?
Yes, but a checklist filter selects matching cell values, not a unique person. If two records contain the same name, both can appear. Use another field, such as an email address or employee ID, to distinguish records.
Will filtering change or delete the original data?
No. Filtering hides rows that do not match and leaves the underlying records in the worksheet. Clear the filter to show them again. Take care when copying visible results, since copy behavior can depend on the selection and workbook setup.
Can I filter names in Excel for Mac or the web?
Yes. The same basic approach works: enable Filter from the Data tab, open the dropdown for the name heading, then search or select values. Ribbon placement and wording can vary slightly by platform or update, but the filter controls work similarly.
Related
- How to Drag Serial Numbers in Excel: Fill a Series
- Word Wrap in Excel: How to Make Text Wrap in Cells
- How to Do Subscript in Excel With a Shortcut
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Filter in Table Format: How to Set Up and Use ItTo filter data in an Excel table, click a cell in the table and use the drop-down arrow…
- Excel Formula for Adding Days to a Date: ExamplesTo add days to a date in Excel, add the number of days to the date cell: with…
- How Excel SUMPRODUCT Works: Examples and Practical UsesExcel’s SUMPRODUCT function multiplies corresponding values in one or more arrays, then adds the resulting products. For example,…
- How to Filter Multiple Values in Excel: A Practical GuideTo filter for several values in one Excel column, open its filter dropdown, clear (Select All), check each…
- 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,…
- COUNTIFS Does Not Contain: Excel Formula and ExamplesTo count cells that do not contain a particular text string in Excel, use a COUNTIFS criterion with…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.