how to delete empty rows in Microsoft Excel

admin ExcelComments369Read

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

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

how to delete empty rows in Microsoft Excel文章源自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

how to delete empty rows in Microsoft Excel文章源自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

how to delete empty rows in Microsoft Excel文章源自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

how to delete empty rows in Microsoft Excel文章源自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.

how to delete empty rows in Microsoft Excel

So that’s it.

 
匿名

Comment

Anonymous

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

Decide