How To Quickly Delete Blank Rows In Excel?

Date:2021-3-3 Author:Sandra

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.

How To Quickly Delete Blank Rows In Excel?
How To Quickly Delete Blank Rows In Excel?

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.

How To Quickly Delete Blank Rows In Excel?
How To Quickly Delete Blank Rows In Excel?

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.

How To Quickly Delete Blank Rows In Excel?

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

How To Quickly Delete Blank Rows In Excel?
How To Quickly Delete Blank Rows In Excel?
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *