Select Specific Cells, Entire Rows or Columns Based on Criteria in Excel!!
Tags: kutoolsexceltutorial, stepstoselectspecifi, kutools
Published: 2020-11-07 04:19:48

---
title: Select Specific Cells, Entire Rows or Columns Based on Criteria in Excel!!
published: true
date: 2020-11-06 12:10:23 UTC
tags: KutoolsExcelTutorial,StepstoSelectSpecifi,Kutools
canonical_url: https://geekexcel.com/select-specific-cells-entire-rows-or-columns-based-on-criteria-in-excel/
---

In this article, you will learn the steps to **Select Specific Cells, Entire Rows, or Columns Based on Criteria in Excel Office 365** using **Kutools.** Let’s get into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Select Cells, Entire Row, or Column Based on Criteria/Value:

To do this, you need to follow the below steps.

- Let’s consider an example, here we have shown the range of values where we want to select cells, entire rows, columns that contain a value **greater than 70** and **less than 90**.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-5.png)<figcaption id="caption-attachment-16884">Input Range</figcaption>

- You need to **select** the **range** and then on the **Kutools Tab, click** the **Select** option, **choose** the **Select Specific Cells** option from the menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-3.png)<figcaption id="caption-attachment-16887">Kutools Tab</figcaption>

- It will open the **Select Specific Cells Dialog Box**.
- **Selection**  **type –** You need to **choose any one** of the **options** as you wish.
- **Specific type –** In this section, you need to specify the criteria.

![Select Specific Cells Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-4.png)<figcaption id="caption-attachment-16902">Select Specific Cells Dialog Box</figcaption>

### Note:

- **Cell –** If you choose this option, it will select specific cells only.
- **Entire row –** It will select the specific rows.
- **Entire Column –** This option is used to select specific columns.
- **Select entire row or column in the selection –** It will select the entire row or column only in the selection.

- Then, **click** the **OK** button. A **prompt box** will pop-out to tell you how many cells, rows, or columns have been selected.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-the-OK-button-5.png)<figcaption id="caption-attachment-16899">Click the OK button</figcaption>

- And then, **click** the **OK** button.
- Now, you can see that all the cells that meet the given criteria have been selected as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Result-8.png)<figcaption id="caption-attachment-16900">Result</figcaption>

## Steps to Select Cells, Entire Rows/Columns Containing Specific Text or Value:

If you have a range of cells with some values and you want to select cells, entire rows, or columns that contain the specific text, do as follows.

- First, you need to **select the input range.** Here, we are going to select the cells, entire rows/columns containing the text **“Example”.**

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-4.png)<figcaption id="caption-attachment-16904">Input Range</figcaption>

- Go to the **Kutools Tab, click** the **Select** option, **choose** the **Select Specific Cells** option from the drop-down menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-3.png)<figcaption id="caption-attachment-16887">Kutools Tab</figcaption>

- It will open the **Select Specific Cells Dialog Box**.
- **Selection**  **type –** You need to **choose any one** of the **options** as you wish.
- **Specific type –** In this section, you need to **select** the **Contains** option from the first drop-down list and then **type the text/value** in the second drop-down list.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-2.png)<figcaption id="caption-attachment-16905">Click the OK button</figcaption>

- Then, **click** the **OK** button.
- A **prompt box** will pop-out to tell you how many cells, rows, or columns have been selected.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-1.png)<figcaption id="caption-attachment-16906">Prompt box</figcaption>

- **Click** the **OK** button to close it and see the result as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-1.png)<figcaption id="caption-attachment-16907">Output</figcaption>

## Wind-Up:

In this article, you can easily understand the steps to **Select Specific Cells, Entire Rows, or Columns Based on Criteria in Excel Office 365** using **Kutools.** Leave your **suggestions/feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Sum/Count/Average Visible Cells, Rows, Columns in Excel](https://geekexcel.com/how-to-sum-count-average-visible-cells-rows-columns-in-excel/)
- [Extract and List All Comments to New Worksheet/Workbook in Excel 365!!](https://geekexcel.com/wp-admin/post.php?post=16798&action=edit)