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)
Смотрите видео How to delete all blank rows in Excel (but keep the ones with empty cells) онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал Minh Nguyen 12 Март 2017. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 17,883 раз и оно понравилось 102 посетителям.
