How to not show empty cells in excel

00:00Hello Everyone. Welcome to Excel 10 Tutorial.  In this quick tutorial I will show you how  

00:05to remove blank or empty cells in Microsoft  Excel. Let's get started. Take a look at here,  

00:13I have some data in these cells, and  there are lots of empty cells in between  

00:23and I want to remove them. To do that,  let's click at here, "Find and Select",  

00:29Click on the down arrow. Now select "Go to  Special". Now select the "Blanks" click "OK".  

00:38Now all of the Blank cells are selected. Just  right-click on any empty cell. Click on the  

00:46"Delete" & "Shift cells up". Click OK. See all  of the empty cells are deleted and the data has  

00:55been moved up. That's what I wanted to show you.  Thanks for watching. Feel free to like, comment,  

01:02share and don't forget to subscribe and special  announcement we have just started a VBA course,  

01:09"excel vba programming course". If you are  interested check out the playlist. Thank you.