HDTutorial
EN
How to remove all blank rows in Excel (but keep the empty cells)

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to remove all blank rows in Excel (but keep the empty cells)

18,063 views November 2, 2017 2:20

Watch on YouTube
ChannelMinh Nguyen

Description from the creator

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: 1drv.ms/x/s!AtIsh44H_L8q1kX2agsT7-zTF5FG

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)

About this tutorial

Minh Nguyen published this 2:20 video tutorial on November 2, 2017. It has been watched 18,063 times on YouTube.

Category
Education
Duration
2:20
Published
November 2, 2017
Views
18,063
Likes
102

Tags

Share

This tutorial in other languages