How to delete irregular Blank Rows in Excel

How to delete irregular Blank Rows in Excel

You have a lot of data rows and you want to delete rows that are empty, but those rows are irregular and very large. this method will help you.

I have data like this. There are some empty rows, and I want to delete them without clicking one by one.

Block all your data, then press the F5 key, Go To window will appear, click the Special button.

The Go To Special window will appear, then click the Blanks option, then click OK.

then all empty rows will be selected, right-click on one of these rows and click Delete. select delete option (Entire row)

congratulations you avoid wasting time.

How to delete irregular Blank Rows in Excel