In Excel, the Find and Replace function is used widely and conveniently.
How to search or find multiple values at once in Excel?
However, the Find and Replace function only can search or find a value at one time. Sometimes, if you want to find two values at a once, how can you do? Now I will introduce a quick way for you to find more than one value at a time in Excel.
Search multiple values at once with Kutools for Excel. If you installed Kutools for Excel — a useful and handy Excel add-in, you can use its Select Specific Cells feature to quickly find multiple values at once.
See screenshot:. In the Select Specific Cells dialog, do as follow:.
Check Cell option in Selection type section;. Both select Equals in the two drop down lists, and enter the values you want to find in each text box in Specific type section;. Click Ok or Apply to apply the feature, and a dialog pops up to tell you the number of selected cells. Now you can see the values you want to find at once are selected.
If you want to search values in the whole worksheet, you can click this to select the whole sheet:. Select Specific Cells utility only can search or find two different values at once time. For more information on Select Specific Cells…. Log in.
PDF Dateien durchsuchen - auch unter Windows 7 64bit
Forgot your password? Forgot your username? Password Reset.
Please enter the email address for your account. A verification code will be sent to you.
Once you have received the verification code, you will be able to choose a new password for your account. Please enter the email address associated with your User account. Your username will be emailed to the email address on file.
Forum Get forum support. How to search or find multiple values at once in Excel? Read More Free Download You are guest Sign Up?
Login Now. Loading comment The comment will be refreshed after