Select Non-Blank or Non-Empty Cells in a Range in Excel Office 365!!
Tags: kutoolsexceltutorial, selectnonblankornone, kutools
Published: 2020-09-19 10:38:36

---
title: Select Non-Blank or Non-Empty Cells in a Range in Excel Office 365!!
published: true
date: 2020-09-19 04:12:46 UTC
tags: KutoolsExcelTutorial,SelectNonBlankorNonE,Kutools
canonical_url: https://geekexcel.com/select-non-blank-or-non-empty-cells-in-a-range-in-excel-office-365/
---

## Select Non-Blank or Non-Empty Cells in a Range in Excel:

In this article, we are going to see how to **Select Non-Blank or Non-Empty Cells in a Range in Excel**  **Office**  **365** using **Kutools**. 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.

## **Steps to Select Non-Blank or Non-Empty Cells in a Range:**

To select non-blank or non-empty cells in a range, do as follows.

- You need to **select** the **range** with non-blank cells that you need to select.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-74.png)<figcaption id="caption-attachment-14250">Example</figcaption>

- On the **Kutools** tab, **click** the **Select** tab, **choose**  **Select**  **Nonblank**  **Cells** option from the drop-down menu.

![Choose Select nonblank cells option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-69.png)<figcaption id="caption-attachment-14251">Choose Select Nonblank Cells option</figcaption>

- Then it will open **Kutools for Excel** dialog box to tell you how many non-blank cells have been selected from the range.
- You need to **click** the **Ok** button to get the result.

![Kutools for Excel Diaolg Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-32.png)<figcaption id="caption-attachment-14252">Kutools for Excel Dialog Box</figcaption>

- Now, you can be able to see all the **non-blank cells have been selected** as shown in the below screenshot.

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

### Video Tutorial:

<!--[if lt IE 9]><script>document.createElement('video');</script><![endif]--><video id="video-14249-1" width="770" height="433" preload="metadata" controls="controls"><source type="video/mp4" src="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Select-Non-Blank-Cells.mp4?_=1"></source><a href="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Select-Non-Blank-Cells.mp4">https://geekexcel.com/wp-content/uploads/2020/09/Select-Non-Blank-Cells.mp4</a></video>

## **Summary:**

In this article, you can clearly understand the steps to **Select Non-Blank or Non-Empty Cells in a Range in Excel**  **Office**  **365** using **Kutools**. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Read Ahead:

- [How to Filter Merged Cells in Microsoft Excel 365?](https://geekexcel.com/how-to-filter-merged-cells-in-microsoft-excel-365/)
- [How to change Font Style in Microsoft Excel 2013?](https://geekexcel.com/how-to-change-font-style-in-microsoft-excel-2013/)