Instructions for finding names in Excel

To search for any content on Excel, you can use the Search function in Excel or use the Find tool in Excel. Using more support tools makes searching easier, instead of having to search manually. And to find the names in the Excel data sheet, we have a lot of different names, such as finding names in the same sheet, finding names in many sheets, looking for names using Auto Filter. The following article will guide you to read the name search cases in Excel.

1. How to use Advanced Filter to filter data on Excel
2. How to filter duplicate data on 2 Excel sheets
3. Instructions for separating column content in Excel
4. How to arrange names in alphabetical order in Excel

1. Find the name in Excel using Find & Replace

This is a method of searching content, searching names in Excel tables that are used by many people because of their simple and easy to use methods.

To find out how to search for a name using the Find & Replace tool, read the article "Complete guide to Excel 2016" (Part 10): Use the Find and Replace function.

With specific exercises you read in the Search and replace instructions in the Excel table.

Instructions for finding names in Excel Picture 1

2. Find names in Excel columns with Auto Filter

If you want to quickly find a name in a list column, you can use the Auto Filter tool. This method will apply to Excel 2013 or later.

Step 1:

At the interface on Excel the user blackens the column to be searched for the name, then click on Data on the same content and then select the Filter tool to create the content filter.

Instructions for finding names in Excel Picture 2

Step 2:

At the column that the user blacked out displayed the filter, click the arrow icon and enter the name to search in the search bar and click OK below.

Instructions for finding names in Excel Picture 3

The Excel table results show the name we entered, along with a specific location according to the name we searched for.

Instructions for finding names in Excel Picture 4

3. Find the Excel name in multiple Excel sheets

If we want to find the same name in multiple sheets in Excel, we also use the Find & Replace tool.

Step 1:

First press Ctrl + F to open Excel's Find & Replace tool. In the Find section of the Find and Replace dialog box, enter the name you want to find in the Find what box, and select Options .

Instructions for finding names in Excel Picture 5

Step 2:

Show more optional content below. In Within section, we will switch back to Workbook and select Find All to search.

Instructions for finding names in Excel Picture 6

Step 3:

As a result, you see the entire location of the sheets with the name you want to search. If you click on any location in the search table, the user is moved to that location in the Excel data sheet.

Instructions for finding names in Excel Picture 7

So finding a name on Excel has a lot of ways to do it, depending on your current Excel data sheet. With the Auto Filter tool, it is only appropriate to find content in Excel column.

I wish you all success!