---
title: "How to remove blank rows in Excel"
description: "Blank rows in Excel can mess up your data and make your spreadsheet look disorganized. Here's how to delete blank rows in Excel using the desktop app or online."
image: "https://images.ctfassets.net/lzny33ho1g45/2S0H6GfYCc2HqJb0tQIvPQ/f188f5eb70a93984e9b42153d257e622/excel_hero.jpg"
---

# How to remove blank rows in Excel

Blank rows in Excel can mess up your data and make your spreadsheet look disorganized. Here's how to delete blank rows in Excel using the desktop app or online.

I teach part-time at a local college. One thing they don't tell you about the gig is that there's way more spreadsheet work than you might think. Most of it involves consolidating grade sheets from various apps and organizing it all in one mega [Excel](https://zapier.com/blog/excel-online-guide/) spreadsheet. It doesn't sound like much, but when you're left with a mess of data, including mysterious blank rows scattered all around, it can mess with your data.  

If you need to remove blank rows in Excel, here's how to do it in both the desktop app and online. 

**Table of contents**: 

- [How to remove blank rows in Excel (desktop)](#desktop)
- [How to remove blank rows in Excel online](#online)
- [How to remove blank rows in Excel individually](#individual)

## How to remove blank rows in Excel (desktop) 

If you're using the Excel desktop app, congratulations—deleting blank rows is going to be simple. (If you're using Excel online, [jump ahead](#online). The process is more manual.) 

**Note:** If you have a mix of completely blank rows and rows with _some_ empty cells, you're better off [filtering for blank rows and then deleting them yourself.](#online) Otherwise, Excel will [delete the entire row that contains the empty cells](https://cdn.zappy.app/9db5f125dc37d12ef8c6da2223996406.gif), which you probably didn't want. 

With all that, let's delete some blank rows. We'll remove blank rows from this student roster as an example: 

1. With your Excel workbook open, highlight the cell range that you want to edit. If you want to delete blank rows from your entire workbook, you don't have to do this.
2. From the _Home_ tab, click **Editing** > **Find & Select** > **Go To Special**_. _

3. In the _Go To Special_ popup, click **Blanks**, and then click **OK**.

4. Excel will automatically highlight all blank rows and cells.

5. From the _Home_ tab, click **Cells**, and then select **Delete**.

That's it. 

## How to remove blank rows in Excel online

For some reason, Microsoft doesn't give you the same (Go To) Special powers in Excel online as it does with the desktop app. If you want to remove multiple blank rows at once, you'll have to use a filter to identify all the blank rows and then delete them yourself. 

This method also works if you have a mix of fully blank rows and rows with some blank cells, but you want to delete only fully blank rows. Here's how to do it. 

1. With your Excel workbook open, highlight the data range you want to modify.
2. Click the **Data** tab, and then select **Filter**.
3. Dropdowns will appear next to every column header.

4. Click the dropdown next to any header.
5. At the bottom of the dropdown that appears, deselect **Select all**, and then click **(Blanks)**.
6. Click **Apply**.

7. You should see only blank rows now. Select those rows, right-click your selection, click **Delete**, and then click **Rows** **[row numbers selected]**.

8. To change the view back to see all of your remaining data, click the dropdown next to any column header.
9. Click **Select All**.
10. Click **Apply**.

You'll notice that row 11 in my example, which contains some blank cells, is still visible. Meanwhile, all the fully blank rows have been removed. 

## How to remove blank rows in Excel individually

If your spreadsheet is filled with blank rows, but you want to delete only specific ones, it's easy to do. I'm using the desktop app, but you can do the same in Excel online.

1. With your spreadsheet open, hold `command` (Mac) or `Ctrl` (Windows), and select the rows you want to delete.
2. From the _Home_ tab, click **Cells**, and then select **Delete**. Or right-click your highlighted selection and click **Delete**.

## Automate Microsoft Excel

Now that you're the proud owner of a pristine spreadsheet, keep it working for you. [Connect Excel to Zapier](https://zapier.com/apps/excel/integrations), so you can automatically do things like send data to your Excel workbook from other spreadsheets, databases, or any other app you can imagine. Learn more about [how to automate Excel](https://zapier.com/blog/automate-microsoft-excel/), or get started with one of these pre-made workflows.

Related reading:

- [How to remove duplicates in Excel](https://zapier.com/blog/find-remove-duplicates-excel/)
- [How to use VLOOKUP in Excel](https://zapier.com/blog/vlookup-excel/)
- [How to use conditional formatting in Excel](https://zapier.com/blog/excel-conditional-formatting/)

_This article was originally published in May 2019 with contributions from Justin Pot and Melissa King. The most recent update was in April 2025_.