See all How-To Articles

How to Find & Select Specific Cells in Excel

In this tutorial, you will learn how to find and select cells that contain a specific value in Excel.

 

find and select cells final data

 

Find and Select Cells by Specific Value

Say you have a data set with names in three columns (B, C, and D), as shown below.

 

find and select cells initial data

 

To select all cells that contain a specific value (for example, Michael), follow these steps:

1. In the Ribbon, go to Home > Find & Select > Find.

 

find and select cells find data

 

2. In the Find and Replace window, (1) enter the text you want to find (Michael), and (2) click Find All.

 

find and select cells find data 2

 

3. The bottom part of the window shows all cells where the searched value appears. (1) Select one line in the found cells, press CTRL + A on the keyboard to select all cells, and (2) click Close.

 

find and select cells find data 3

 

As a result, all cells containing Michael are selected (B7, C3, and D4).

 

find and select cells final data

 

Note: You can also use VBA code to find and select cells based on a specific value.