How to remove blank or empty cells in microsoft excel

How to delete or remove empty or blank cells in excel
Removing empty cells is one of the most important tasks in Microsoft Excel. Sometimes it become so crucial that without knowing the proper ways to delete black cells can cost you hours.
This is why in this tutorial I’m going to cover these topics.
There are several ways to delete or remove empty cells in Microsoft Excel and I’m going to show you the easiest one.
First select the data from where you want to remove empty cells.
Click on the “Find & Select” button at the top right corner. In the drop- down list you’ll find “Go To Special” Click that.
In the pop up you’ll find “Blanks”, check-mark that and press OK.
Now you will see all the blanks or empty cells are selected and now click on the right mouse button and click delete. Again in the pop up select “Shift Cells Up”. Done
Now all the blank cells are deleted and the data has shifted up. This is how you delete or remove empty or blank cells in Microsoft excel.
-------------------------------------------------------------------------------------------------------------
Special Announcement: Excel VBA Programming Course just started. Interested people should take a look bit.ly/excelvbacourse
-------------------------------------------------------------------------------------------------------------
#removeblankcells #emptycells
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
/ excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
goo.gl/uL8fqQ
Playlists:
Advance Excel Tutorial: goo.gl/ExYy7v
Excel Tutorial for Beginners: goo.gl/UDrDcA
Excel Case: goo.gl/xiP3tv
Excel VBA Programming Course: bit.ly/excelvbacourse
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: excel10tutorial.blogspot.com
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: hubpages.com/@excel10tutorial

[@minlim6870]

Thanks!

[@Excel10tutorial]

Thanks a million for your support.

[@nagarajshetty3214]

Uses full information 😊

[@TheDominitri]

You are a king, worked with excel for years digitizing documents and I did not know of this trick, saved me a lot of time!

[@Excel10tutorial]

Glad I could be of help. Please Subscribe and Share the video.

[@shawnydaze280]

Fast and to the point. Thanks!

[@Excel10tutorial]

Glad it helped!

[@NYCRocks]

Great tutorial! I'll be sharing! Thanks for posting to the group!

[@Excel10tutorial]

Thank you very much. Appreciate your support.

[@taiwoowoseni9364]

I wish you happiness. Thank you for making the intro short and the tutorial short as well.

[@Excel10tutorial]

Glad you like it.

[@wasimhussain1983]

Thank you for such a useful tutorial. It saved me lot of manual work.

[@Excel10tutorial]

You're welcome.please subscribe.

[@abisgetachew8160]

Thank you. Precise and effective

[@Excel10tutorial]

You're most welcome. Please subscribe and share.

[@efe_aydal]

Thank you. I needed to know this.

[@Excel10tutorial]

Glad it was helpful!

[@hazelgrace2626]

You're a life savor thank you

[@Excel10tutorial]

You're welcome. Please subscribe and be in touch.

[@senthilkumarkulandaivel920]

Thanks for a very simple and crisp video. Keep sharing

[@Excel10tutorial]

My pleasure 😊

[@duanedonaldson2262]

Thanks friend, you just saved me an hour everyday

[@Excel10tutorial]

Glad to hear that!

[@henrypraise4873]

Really helpful. Thanks.

[@Excel10tutorial]

You're welcome! Please subscribe and be with us.

[@adamwallimohamed322]

Thank you!!

[@Excel10tutorial]

You're welcome

[@kirabana]

Thank you!

[@Excel10tutorial]

You're welcome. Please subscribe

[@rajchinnaraj2669]

Short and sweet

[@Excel10tutorial]

Thanks a million

[@arungovindan7028]

Thanks brother

[@Excel10tutorial]

Any time. Please subscribe and share.

[@superseasnails8368]

THANK YOU!!!!!

[@Excel10tutorial]

You're welcome. Please subscribe and share the video.

[@rickjamez06]

Bless you

[@Excel10tutorial]

Thanks

[@bhaskarjetla8872]

Thanks

[@Excel10tutorial]

Welcome

[@kartikyadav4128]

amazing ❤

[@Excel10tutorial]

Thank you! Cheers!

[@truthlover6511]

Thank u

[@Excel10tutorial]

Welcome

[@rosa817]

Very helpful, thank you so much!

[@Excel10tutorial]

You're most welcome. Please subscribe and be with us.

[@rosa817]

@@Excel10tutorial Sure, just did!

[@Excel10tutorial]

Thanks a million

[@joram807]

Beautiful

[@Excel10tutorial]

Thanks.

[@alexgoldsack3313]

Hi, I was wondering whether you know this function is possible on pages as well? Thanks

[@Excel10tutorial]

Please explain.

[@alexgoldsack3313]

@@Excel10tutorial Hi, for the pages program on the Apple computers (MacBookAir).

[@LuisRamirez-yl1et]

I always get an error "No cells were found" what can I do?

[@invenew]

Ok. good and many thanks. but please what if the cells have " hidden empty text" They appear blank but actually are nonblank? Thanx again

[@Excel10tutorial]

Like you said they are non Blank. This tutorial will only remove Blank.

[@rajeshdhamecha6946]

👍🏻

[@Excel10tutorial]

Thanks

[@janetrachelalejandro9626]

How about if you will not delete it only hide

[@Excel10tutorial]

You can hide either row or column. You can't hide a single cell.

[@htlau542]

it says cannot use that command on overlapping selections

[@Excel10tutorial]

Send me the file. I'll take a look.