Hello Everyone. Welcome to Excel 10 Tutorial. In this quick tutorial I will show you how
to remove blank or empty cells in Microsoft Excel. Let's get started. Take a look at here,
I have some data in these cells, and there are lots of empty cells in between
and I want to remove them. To do that, let's click at here, "Find and Select",
Click on the down arrow. Now select "Go to Special". Now select the "Blanks" click "OK".
Now all of the Blank cells are selected. Just right-click on any empty cell. Click on the
"Delete" & "Shift cells up". Click OK. See all of the empty cells are deleted and the data has
been moved up. That's what I wanted to show you. Thanks for watching. Feel free to like, comment,
share and don't forget to subscribe and special announcement we have just started a VBA course,
"excel vba programming course". If you are interested check out the playlist. Thank you.