How to Search Within a Specific Column in Excel

*How to search within a specific column in excel*
In this intermediate excel tutorial, I’ll show you two ways to search within a column in excel. If we use “Find” or CTRL + F in excel we can search a value within a sheet or workbook. What if you need to search within a specific column? How can you do that. We are going to learn exactly that in this tutorial.

*Method 1*: Here we’ll use the “Find” feature of Microsoft excel. The keyboard shortcut for “Find”

*Step 1:* Select the entire column where you want to search.
*Step 2:* Press CTRL + F on your keyboard to access “Find”
*Step 3:* Now within “Find What” write the value you want to find and click “Find All”
*Step 4:* Now you’ll get the list of all found value within your specific column.
This is how you can limit searching to a specific column.

*Method 2*: Now we’ll use conditional formatting to highlight text/value within a specific column.

*Step 1:* Select the entire column you want for search within.
*Step 2:* From the “Home” tab click on the “Conditional Formatting” dropdown and select “Highlight Cell Rules”
*Step 3:* Now select “Equal To”.
*Step 4:* Write the value you want to highlight and click “OK”
Done. This will find and highlight cells with your specific text within your specific columns.

#Find #Columns #Highlight #msexcel

Thanks for watching.
----------------------------------------------------------------------------------------
Support the channel with as low as $5
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[andrewpervez]

Thank you so much. Very useful. Please keep up the good work. God Bless

[DaveEhle-zu]

this is exactly what i'm looking for... but how do you do this using a formula?