You can trust PCWer: Our team of experts use a combination of independent consumer research, in-depth testing where appropriate - which will be flagged as such, and market analysis when recommending products, software and services. Find out how we test here.

If you want to learn how to delete blank rows in Excel, then we’ve got you covered right here.

Excel is all about organization and efficiency, so having blank rows can be really annoying on a spreadsheet. However, removing these blank rows from an Excel sheet can be a big headache, especially if you’re dealing with a large dataset. The worst part is that you can end up accidentally removing important rows if you’re not careful enough.

To help you out, we’ll explain three different ways that can help you get rid of empty rows in Excel.

Using right-click

This step is easy to do when an empty row appears due to error or when you just spot a singular one.

First, select an empty row which you wish to delete from the sheet.

Now, press right-click top open a menu. From this, select ‘Delete’ and then select ‘Entire Row.’ This will remove the empty row from the sheet.

Screenshot of an Excel spreadsheet with cells displaying models and values, with a context menu open highlighting the "Delete" option to remove empty rows. — Delete button

Using a Ribbon

You can also remove an empty row in Excel using a Ribbon.

Simply highlight the row by clicking on it.

Go to the ‘Home’ tab and click the ‘Delete’’ Ribbon which will open another drop down box. From this drop down menu, select ‘Delete sheet rows’.

Screenshot of Microsoft Excel showing the "Delete Sheet Rows" option highlighted in the drop-down menu under the "Delete Cells" button. — Delete Ribbon

Using a keyboard shortcut

For those who want efficiency, this keyboard shortcut can save lots of time.

First, select a blank row on the sheet. You can either select an individual row or several at once.

Now, press CTRL – + on your keyboard. Make sure to press all three of them simultaneously. This will open up a menu on the screen, from where you can select ‘Entire row’ and click ‘OK’ to delete the selected blank rows.

Screenshot of Microsoft Excel menu displaying options including "Delete," "Shift cells left," "Shift cells up," with "Entire row" selected. — Delete menu

Final thoughts

As you can see, there are many ways to delete a blank row from an Excel sheet. This can help you keep your sheet organized. By using the methods mentioned in our guide, you can either delete a single blank row or get rid of several at once.

If you want to learn more about Excel and how it works, we’d recommend giving these guides a read:

How to delete blank rows in Excel – our guide to removing an empty row

Table of Contents

Using right-click

Select an empty row

Use right-click

Using a Ribbon

Highlight the row

Click on ‘Delete’

Using a keyboard shortcut

Select a blank row

Use the keyboard shortcut

Final thoughts

Kevin Pocock

How to delete blank rows in Excel – our guide to removing an empty row

Table of Contents

Using right-click

Select an empty row

Use right-click

Using a Ribbon

Highlight the row

Click on ‘Delete’

Using a keyboard shortcut

Select a blank row

Use the keyboard shortcut

Final thoughts

Related