Remove All Blank Rows from Bottom/a Range in Excel Office 365!!
Tags: kutoolsexceltutorial, removeallblankrows, kutools
Published: 2020-10-30 11:57:12

---
title: Remove All Blank Rows from Bottom/a Range in Excel Office 365!!
published: true
date: 2020-10-30 09:29:35 UTC
tags: KutoolsExcelTutorial,RemoveAllBlankRows,Kutools
canonical_url: https://geekexcel.com/remove-all-blank-rows-from-bottom-a-range-in-excel-office-365/
---

In this guide, we will discuss how to **Remove Or Delete All Blank Rows from Bottom/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.
## Delete All Blank Rows From Bottom or a Range:

If you want to remove blank rows from the **bottom** of your worksheet, follow the below steps.

- You need to **place the cursor in the first blank row** of the worksheet, then **press (CTRL** + **SHIFT** + **END)** keys to select the blank rows.

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

- Then, **click** the **Delete** key and **save** the workbook.
- Now, all the blank rows have been removed from the bottom.

To remove multiple blank rows from a range, do as follows.

- You need to **select the range** where you want to remove blank rows.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-range-1.png)<figcaption id="caption-attachment-16532">Select the range</figcaption>

-  Go to the **Kutools Tab, select** the **Delete Tools** option, then **choose** the **Delete Blank Rows** option, **select** the **In selected Range** option.

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

- It will open the prompt box to tell you how many rows have been removed from the range.

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

- Now, it will delete all the empty rows from the selected range as shown in the below image.

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

## Delete All Blank Rows from the Active Sheet, Selected worksheet, or Whole workbook:

You can delete all blank rows from the active sheet by doing the following steps.

- Go to the **Kutools Tab, select** the **Delete** option, **choose** the **Delete Blank Rows** option, then **select** the **In Active Sheet** option from the menu.

![Select the In Active Sheet option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2-26.png)<figcaption id="caption-attachment-16536">Select the In Active Sheet option</figcaption>

- Then, all the blank rows in the active sheet will be removed.

### Note:

- You can use the above steps to remove all blank or empty rows from the selected worksheets or the whole workbook.

## Conclusion:

In this guide, you can learn the steps to **Remove Or Delete All Blank Rows from Bottom/a Range in Excel Office 365** using **Kutools. ** Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Split First, Middle, Last Names of the Full Name in Excel Office 365!!](https://geekexcel.com/split-first-middle-last-names-of-the-full-name-in-excel-office-365/)
- [Sort or Select Cells/Rows/Columns Randomly in Excel Office 365!!](https://geekexcel.com/sort-or-select-cells-rows-columns-randomly-in-excel-office-365/)