If you work with spreadsheets, then you know how frustrating it can be to work for hours and find blank rows that are just there to irritate you. If this is something that you have faced before then you need not worry. Removing blank rows in Excel is pretty easy and all it takes is a couple of clicks. Here we are going to look into how you can easily remove those pesky blank rows.
Manually deleting a single row
If you need to delete a single row, then you can do so by following the steps below:
- Click on the row number of the left side of the sheet
- Right click on the row
- Select delete
The row will be removed. If you only need to remove a couple of blank rows in Excel, then this is an easy way of doing it but it can be a long process if you need to remove more than just a few.
Delete multiple blank rows quickly
If you are dealing with more than a few blank rows, then you can follow these steps in order to get rid of them all at once:
- Select the entire area from which you want to delete rows
- Press the Home tab
- Press Find & Select
- Click on Go To Special
- Select Blanks option
- Click Delete in the Cells section of the Home Tab
By using this method even though you have selected rows that are not blank, only the rows that are blank will be deleted. This is an easy way of deleting all the blank rows in your Excel sheets.
There are plenty of ways in which you can delete rows in Excel. Here we have looked into two of the most effective ways. The first method will let you delete a single blank row while the second method will allow you to quickly remove multiple empty rows in Excel.