Quickly select specific cells, entire rows or entire columns based on criteria in Excel

Normally if you need to select cells, entire rows or entire columns based on specific criteria in Excel, such as you want to select all cells, which are ending with "Km", you have to search cells one by one and select them manually. Kutools for Excel's Select Specific Cells utility can help quickly select cells, entire rows or entire columns based on one or two criteria.

Select cells, entire rows or entire columns based on one criterion
Select cells, entire rows or entire columns based on two criteria

Click Kutools > Select > Select Specific Cells. See screenshots:

Select Cells, Entire Rows Or Entire Columns Based On one Criterion

Suppose you have a school report as shown in the screenshot below, to find Nicol and his scores for all subjects, please do as follows.

1. Select the entire school report, and then click Kutools > Select > Select Specific Cells to enable this feature.

2. In the Select Specific Cells dialog box, please configure as follows.

2.3) In the Specific type section, select Equals in the first drop-down list and enter a text “Nicol” into the text box (or you can click the dropper icon to extract the text from a cell). Make sure that the second-drop-down list shows the None option.

2.4) Click the OK button or Apply button.

3. Then a Kutools for Excel dialog box pops up to tell you how may cells were found and selected, click the OK button to close it.

Then Nicol and his scores for all subjects are selected in the school report as shown in the screenshot below.

Select Cells, Entire Rows Or Entire Columns Based On two Criteria

Suppose you have a product order list as shown in the screenshot below, to search and select the cell that starts with the text “KTW” and ends with the number “04” in the Order_ID column, this Select Specific Cells utility can also help to quickly handle it.

1. Select the Order_ID column range, and then apply this utility by clicking Kutools > Select > Select Specific Cells.

2. In the Select Specific Cells dialog box, please configure as follows.

2.4) Click the OK button or Apply button

3. Then a prompt box pops out to tell you how many cells (rows or columns based on your section type) were found and selected, click the OK button.

You can see cells that match the specified criteria are selected.

Things to know for selecting date format cells based on date criteria:

Demo: Select cells, entire rows or entire columns based on criteria