Delete Blank Rows in Excel
In this example, we will guide you how to identify and then delete the blank rows in a worksheet.
To have a good understanding of this process, please follow the steps below:
1. Under the Editing group on HOME tab, click on Find & Select and select Go To Special from the dropdown list
2. On Go To Special window, select Blanks and click OK
3. This will select all the blank sections within the Worksheet
4.Now, to delete these blank rows, click on Delete under the Cells group, on HOME tab and select Delete Sheet Rows from the dropdown list.
5. This will remove the blank rows selected using the Go To Special function.