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 is ending with "Km", you have to search cells one by one and select them manually. Kutools for Excel's Select Specific Cells utility can quickly select cells, entire rows or entire columns based on criteria. With this utility, you can quickly select cells, entire rows or entire columns based on criteria, such as Equals to specific value, Does not equal to specific value, Greater than a value, Greater than or equal to a value, Less than a value, Less than or equal to a value, Begins with a value, Does not begin with a value, Ends with a value, Does not end with a value, Contains specific value, and Does not contain specific value.

Select cells, entire rows or entire columns based on criteria or value

Select cells, entire rows or entire columns containing specific text or value

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

Select cells, entire rows or entire columns based on criteria or value

Supposing you have a range of data as following screenshot, and now you want to select the cells, entire row or entire columns which contains values grater than or equal to 80 and less than or equal to 100. With this Select Specific Cells utility, you can quickly deal with it.

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

2. In the Select Specific Cells dialog box, please select the Selection Type: Cell, Entire row or Entire column. Tip: If you want to select entire rows, please select entire row. The same to entire column. Then specify the criteria from Specific type. See screenshot:

3. Then click OK or Apply, a prompt box will pop out to tell you how many cells, rows or columns haven been selected.

4. And then click OK. All of the cells which meet your criteria have been selected. See screenshots:

Select cells, entire rows or entire columns containing specific text or value

For instance, if you have a range of cells and you want to select cells, entire rows or entire columns which contain the letters "Excel". You can get it done as follows:

1. Highlight the range from which you want to select cells, entire rows or entire columns. And then applying this utility by clicking Kutools > Select Tools > Select Specific Cells.

2. Go to the Select Specific Cells dialog box, Please select the Selection Type: Cell, Entire row or Entire column. Tip: If you want to select entire rows, please select entire row. The same to entire column. Then specify the criteria from Specific type. See screenshot:

3. Then click OK or Apply, a prompt box will pop out to tell you how many cells, rows or columns haven been selected.

4. And then click OK. All of the cells which contain the specific text have been selected. See screenshots:

This is only one feature of Kutools for Excel

It includes more than 120 functions and tools for Excel 2013, 2010, 2007 and Office 365.