how to delete empty rows in Microsoft Excel

I am going to learn how to delete empty rows in Microsoft Excel.

Select column A文章源自LuckYou.ORG-https://luckyou.org/120.html

文章源自LuckYou.ORG-https://luckyou.org/120.html

Go to the “home” tab and then in the “editing ” section, click on “find and select”, then click on go to special.文章源自LuckYou.ORG-https://luckyou.org/120.html

文章源自LuckYou.ORG-https://luckyou.org/120.html

And select blanks here and then click on “OK”, now you can see that the blank rows will be selected.文章源自LuckYou.ORG-https://luckyou.org/120.html

文章源自LuckYou.ORG-https://luckyou.org/120.html

Again in the home tab go to the cells section.文章源自LuckYou.ORG-https://luckyou.org/120.html

And click on the delete drop down arrow, here click on delete sheet rows and all the empty rows will be deleted.文章源自LuckYou.ORG-https://luckyou.org/120.html

文章源自LuckYou.ORG-https://luckyou.org/120.html

attention:文章源自LuckYou.ORG-https://luckyou.org/120.html

Don’t select the entire table, if it contains blank cells in the row you want to be remained.

So that’s it.