How to find names in Excel

You have a long list of hundreds and thousands of names, you are looking for ways to find names in Excel to help save time when processing data. So invite you to learn how to find names in Excel that TipsMake.com share below.

How to find names in Excel Picture 1

Here TipsMake.com shares with you how to find names in Excel, please follow along.

Find the name using the Find & Replace dialog box

Step 1: If you want to find the name, you select the name column and press Ctrl + F or you select Home -> Find & Select -> Find to open the search window.

How to find names in Excel Picture 2

Step 2: The Find and Replace window appears , on the Find tab, enter the name to search in the Find what box . For advanced search, click Options and set some customizations.

How to find names in Excel Picture 3

Step 3: Then you click Find Next to search in turn, Find All to search for all.

How to find names in Excel Picture 4

If you select Find Next , Excel will go to each searchable name in turn.

How to find names in Excel Picture 5

If Find All is selected , a list of the found names will be displayed in the list below. You just need to click on the name, Excel will display that name.

How to find names in Excel Picture 6

Find the name in the column using Auto Filter

You can create a Filter to quickly search for the name by selecting the name column. Next right click Data -> Filter to create a filter.

How to find names in Excel Picture 7

So the column you selected has created a filter, you click on the arrow icon of the filter, and enter the name to search in the Search box and click the search icon.

How to find names in Excel Picture 8

So the filter has been created and filtered by name, the list of names you search will be displayed.

How to find names in Excel Picture 9

Find names in multiple sheets

If the names you want to search are in many different sheets in the Excel file, then look for the following:

Step 1: Press Ctrl + F to open the search dialog.

How to find names in Excel Picture 10

Step 2: In the Find section of the Find and Replace dialog box , enter the name to search in the Find what box , and select Options .

How to find names in Excel Picture 11

Step 3: Select within Within is workbook and choose Find Next or Find All to search.

How to find names in Excel Picture 12

Thus the names in all sheets of the Excel file will be found.

How to find names in Excel Picture 13

So above TipsMake.com has shared with you how to find names in Excel. From now on if you need to find a name in a long list, you will quickly find the name you want. Hope this article will help you. Good luck!