Quickly select specific cells, entire rows or entire columns based on criteria in Excel
Kutools for Excel
Boosts Excel With 300+
Powerful Features
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.

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.

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
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.
Kutools for Excel
The functionality described above is just one of 300 powerful functions of Kutools for Excel.
Designed for Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 30 days.