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

Table of Contents
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.
Prime Day is finally here! Find all the biggest tech and PC deals below.
- Sapphire 11348-03-20G Pulse AMD Radeon™ RX 9070 XT Was $779 Now $739
- AMD Ryzen 7 7800X3D 8-Core, 16-Thread Desktop Processor Was $449 Now $341
- ASUS RTX™ 5060 OC Edition Graphics Card Was $379 Now $339
- LG 77-Inch Class OLED evo AI 4K C5 Series Smart TV Was $3,696 Now $2,796
- Intel® Core™ i7-14700K New Gaming Desktop Was $320.99 Now $274
- Lexar 2TB NM1090 w/HeatSink SSD PCIe Gen5x4 NVMe M.2 Was $281.97 Now $214.98
- Apple Watch Series 10 GPS + Cellular 42mm case Smartwatch Was $499.99 Now $379.99
- ASUS ROG Strix G16 (2025) 16" FHD, RTX 5060 gaming laptop Was $1,499.99 Now $1,274.99
- Apple iPad mini (A17 Pro): Apple Intelligence Was $499.99 Now $379.99
*Prices and savings subject to change. Click through to get the current prices.
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.
Step
Select an empty row
First, select an empty row which you wish to delete from the sheet.
Step
Use right-click
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.
Using a Ribbon
You can also remove an empty row in Excel using a Ribbon.
Step
Highlight the row
Simply highlight the row by clicking on it.
Step
Click on ‘Delete’
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'.
Using a keyboard shortcut
For those who want efficiency, this keyboard shortcut can save lots of time.
Step
Select a blank row
First, select a blank row on the sheet. You can either select an individual row or several at once.
Step
Use the keyboard shortcut
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.
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: