Buzz
Excel now offers users built-in tools for searching, making it easy for users to find names in Excel. Features like Find & Replace and Auto Filter streamline the process, along with shortcuts for searching across multiple sheets.
Using Find & Replace or Auto Filter to locate names in Excel
Guide to Finding Names in Excel
In this Excel name search guide, we'll demonstrate how to search in Excel 2019, along with older versions like Excel 2016, 2013, 2010. The process remains similar across these versions.
- Learn how to update and install Excel 2019 here.
1. Searching for Names in Excel Using Find & Replace
Searching for names in this Excel table is widely adopted by many Excel users due to its simplicity and ease of execution.
Step 1: If you want to find names, open the Excel file you want to search -> select the name column and press Ctrl + F or go to the Home tab ->Find & Select -> choose Find to open the search window.
Step 2: When the Find and Replace interface appears, in the Find tab -> enter the name you want to search in the Find what box. For advanced search -> click Options -> then customize some settings.
Step 3: Then, press Find Next to search sequentially, and Find All if you want to search for all occurrences.
If you choose Find Next, the Excel application will sequentially search for each entered name.
If you select Find All, a list of found names will appear and will be displayed in the list below. Simply click on any name -> the Excel application will show you that name.
2. Searching for Names in an Excel Column Using Auto Filter
With this method, users can quickly find names in a column list, and you can use the Auto Filter tool.
Step 1: In the Excel file interface -> select the column you want to search for names -> then click on Data at the top and choose Filter to create a content filter.
Step 2: In the column where the user has just selected, the filter will be displayed, click on the arrow icon -> then enter the name you want to search in the search bar -> then press OK at the bottom.
The result is the Excel table will only show the names that you have entered, along with the specific positions corresponding to the names the user is searching for.
3. Searching for Names in Multiple Excel Sheets
If you want to find identical names across multiple sheets in an Excel file, you still use the Find & Replace tool. Here's how to search across multiple sheets in Excel:
Step 1: Press the shortcut Ctrl + F to open Find & Replace in Excel. In the Find section of the Find and Replace dialog box -> enter the name you want to find in the Find what box -> then select Options.
Step 2: In the displayed section, add options below. In the Within section, select Workbook -> then click Find All to search for names.
Step 3: And you will see the results displaying all locations across the sheets where the name you're searching for is found. When you click on any location in the search results, Excel will navigate to that exact position in the data table.
Here's the complete guide on how to find names in Excel to help you quickly locate the desired information. If you encounter a long list and need to search for names in Excel, you can use the Auto Filter tool to filter data in Excel and then search, or use the Find and Replace method in Excel. Wish you success!
