How to Delete Blank or Hidden Rows/Columns In Excel 365?
Tags: deleteblankorhiddenr, kutoolsexceltutorial, kutools
Published: 2020-11-16 07:28:41

---
title: How to Delete Blank or Hidden Rows/Columns In Excel 365?
published: true
date: 2020-11-13 11:02:54 UTC
tags: DeleteBlankorHiddenR,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-delete-blank-or-hidden-rows-columns-in-excel-365/
---

In this tutorial, you will learn the steps to **Delete Blank or Hidden Rows/Columns 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.
## Delete Blank Rows/Columns from a Range, Selected Sheets, Active Sheet, or All Sheets:

If you want to delete blank rows or columns from a range, selected sheets, active sheet, or all sheets, then follow the below steps.

- Let’s consider the below example.

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

- Go to the **Kutools Tab, select** the **Delete** option, then **choose** the **Delete Hidden (Visible) Rows & Columns**.

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

- It will open the **Delete Hidden (Visible) Rows & Columns** dialog box.
- **Look in –** You need to **specify** the **scope** that you want to apply the operation from the drop-down list. We **select** the **In Selected Range** option.
- **Delete type – Select** the **Rows** option.
- **Detailed type –** You need to **select** the **Blank rows** option.

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

- It will open the **prompt box** to show you how many rows are deleted successfully.

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

- Then, **click** the **OK** button. All the blank rows have been deleted from the selected range.

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

## Steps to Delete Hidden Rows/Columns from a Range, Selected Sheets, Active Sheet, or All Sheets:

To delete hidden rows/columns from a range, selected sheets, active sheet,  or all sheets, do as follows.

- In the below image, you can see the example data with some hidden rows.

![Example data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-19.png)<figcaption id="caption-attachment-17304">Example data</figcaption>

- Go to the **Kutools Tab, select** the **Delete** option, then **choose** the **Delete Hidden (Visible) Rows & Columns**.

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

- It will open the **Delete Hidden (Visible) Rows & Columns** dialog box.
- **Look in –** You need to **select** the **In Selected Range** option from the drop-down list.
- **Delete type – Select** the **Rows** option.
- **Detailed type –** You need to **select** the **Hidden rows** option.

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

- Then, **click** the **OK** button.
- You will see the **prompt box** as shown in the below image.

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

- The hidden rows have been deleted from the selected range.

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

## Delete Visible Rows/Columns from a Range, Selected Sheets, Active Sheet, or All Sheets:

If you delete visible rows/columns from a range, selected sheets, active sheet, or all sheets in Excel, follow the below steps.

- In the below image, you can see the hidden rows in the selected range.

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

- On the **Kutools Tab, select** the **Delete** option, then **choose** the **Delete Hidden (Visible) Rows & Columns**.

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

- It will open the **Delete Hidden (Visible) Rows & Columns** dialog box.
- **Look in –** Choose the In Selected Range option from the drop-down list.
- **Delete type –** You need to **select** the **Rows** option.
- **Detailed type –** Select the Visible rows option.

![Delete Hidden (Visible) Rows & Columns dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-12.png)<figcaption id="caption-attachment-17309">Delete Hidden (Visible) Rows &amp; Columns dialog box</figcaption>

- Then, **click** the **OK** button. T
- A prompt box will pop-out, you need to **click OK** to close the dialog box.

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

- The visible rows have been removed from the selected range and the hidden rows.

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

## Conclusion:

In this tutorial, you can learn the steps to **Delete Blank or Hidden Rows/Columns in Excel Office 365** using **Kutools. ** Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [How to Duplicate Rows or Columns Based On Cell Value in a Specific Column or Row in Excel?](https://geekexcel.com/how-to-duplicate-rows-or-columns-based-on-cell-value-in-a-specific-column-or-row-in-excel/)
- [How to Select Interval Rows or Columns in Excel Office 365?](https://geekexcel.com/how-to-select-interval-rows-or-columns-in-excel-office-365/)