How to delete all blank rows in Excel (but keep the ones with empty cells)
In this video, we will be looking at how to remove all the empty rows in Excel at once. We will also be looking at a more common scenario, where our data consist of not only blank rows, but also blank cells. For example, there are contacts with missing phone number, or missing email, or missing title. We want to remove the blank rows, but keep the empty cells because even though there are missing info, it is still of value to us.
Download the practice file and follow along: https://1drv.ms/x/s!AtIsh44H_L8q1kX2a...
Don't forget to like, comment and subscribe if you'd like to see more videos like this one!
Support my work: paypal.me/nguyenthihaminh
Happy learning
Nguyen Thi Ha Minh (Sky Aries)
Watch video How to delete all blank rows in Excel (but keep the ones with empty cells) online, duration hours minute second in high quality that is uploaded to the channel Minh Nguyen 12 March 2017. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 17,883 times and liked it 102 visitors.
