How to accurately search for people s names in many Excels?

Press Ctrl and F, enter your name, and press Enter.

Device: Lenovo computer.

System: win8

Software: Excel2016

1. First open an excel**, click on the search and select in the upper right corner of excel**.

2. In the pop-up interface, you can see many options for finding and selecting, click the first one, that is, search.

3. In this way, you have entered the search interface of excel, and in the search bar, you can see the input box of the content you are looking for.

4. Enter the name of the person you want to find in the following interface, and click Find All in the lower right corner.

5. In this way, you can find all the places where the person's name appears in the excel**. Click Find Next to view them in turn.

1. Open Excel**, enter the name data in the cell, and repeat Zhang San's name in the cell.

2. Click the "Filter" button on the page toolbar.

3. After clicking, a drop-down box symbol will appear on the Name cell.

4. Click the drop-down box to display a checkbox.

and select the check box in front of the items you want to filter.

5. Click "OK" to select "Zhang San" in the selected cell.

1. First of all, we open the exce** in the computer to open the target data list.

2. Select the header of the data table and click the "Start" button in the Excel menu bar.

3. Under the "Start" menu bar, find the "Filter" function key and click it. At this point, the header of the target data will appear in the header of the target data that can be filtered.

4. For example, if we want to see which class has 25 girls in the whole grade, we can directly find the brushing condition in the "Girls" column, we can find the "25" condition according to the "Content Screening Meditation Selection", and then click on the back to filter only this item.

5. At this time, excel will help us filter out the target results, and we can quickly find the data we need.

1. First of all, let's open an excel**.

2. Then, let's click on the bridge at the top right of excel** to find and select, as follows.

3. After entering the name of the person we want to find in the following interface, click Find All at the bottom right.

4. In this way, we can find all the places where the person's name appears in the excel**. Click on the lead digging to find the next one to view them in turn.

5. Of course, we can also quickly look up a person's name by pressing CRTL+F.

Excel often needs to use the skill of searching for people's names, how to search for the names of people in the data? The following is the tutorial I bring you to search for people's names in excel for your reference.

As shown below, it is a surname worksheet!

In the Excel work window, perform the following operation:

Step 4: As shown above, switch to the "Find" tab, and then enter the last name or full name of the person you want to search in the search content input box, click "Find All" or "Find Next", and after that, it will be the same as above! When we find the name of the person, excel will automatically run to that position and select the current row, so that we can see it at a glance.

Step 5: For a very large amount of name data**, if you only want to see the name of a person with a certain surname, and hide the data of other surnames, then we can use the following method to operate.

Step 6 of searching for personal names: select the whole column with the last name, such as column A in this article, note, click the column header of column A to select, and then execute "Data" "Filter" "Auto Filter", at this time, in the A1 cell of column A, a drop-down list box will appear. As shown below!