Yes, you read that right, this article is to share how to delete blank rows. Have you started to think about why there is such simple content? Come on, It’s not so easy as your thinking. I guess most of you guys choose to right-click the row and delete it.

Let’s try the better and faster way.

Press Ctrl + A to select all the rows, then press Ctrl and G to open the “Go to” box.

Click on Special in the Go To box. And select the Blanks in Go To Special box.

Now you will find that all the blank rows are selected. Then you right-click and click delete.

Just choose Entire row in the Delete box. You will find that all the blank rows are deleted immediately.