Delete Blank Rows in Excel Worksheet

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

go to special

2. On Go To Special window, select Blanks and click OK


3. This will select all the blank sections within the Worksheet

select all

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.

delete sheet rows

5. This will remove the blank rows selected using the Go To Special function.

Go To Special function