How to Delete Blank Rows in Excel

here is the simple way of doing . in the first date column insert 0 for all blank cells using find replace, then filter this column on 0 values, delete all the selected rows. don't waist time in learning macros for this simple task

Excellent video, thank you

for raw data use sort function

Excellent video. Thank you for teaching us another useful task in Excel too !

Great!

Thanks! It helped.

Hi john, I am becomes a huge fan of your excel videos.Almost I completed all videos of yours

Very Helpful... Thanks

Thank you so much for the video....much appreciated.

Great video thank you so much!

Thanks a lot, you make my day bro!

Thanks sir

Thanks Jon. This was very helpful!

Thank you.

perfect

thanks

Thank you!!! So helpful and quick.

It's really awesome!! It helps me to easing my work, thanks.

Very useful, thanks
How to delete automatically in Macros?

Use the "remove duplicates" function. Select all. Removes all blank rows

Thank You Very Much!!! You just save my world and save me so much time. I usually did manually most of the time and just today I remember to google how to do it in more efficient way and I found you. THANK YOU!!

How import of Excel sheets with empty rows in Power Query?

Always excellent. Do you have any advice on updating code when inserting adding and deleting columns? Is there a way to make the cell / range references dynamic in the code? Thank you

Best way, spot on...
Go to is a useless function...

Very helpful. Thank-you Jon!

thanks very much

awesome
awesome
awesome
awesome
awesome
awesome

Just amazing. 🌟 🌟 🌟 🌟 Thanks a lot. 👍

Thanks, I just found your page and i like the how this is all setup, great work

thanks for the help

Smart way!
Thank you!

Sir you are the man live long and teach

Thank you, Jon.

Very useful
Thank you very much Sir

Can you tell us how to cut and paste data from filtered list in excel

I am sure you are a excel genius

Dude, you are freaking awesome. Thank you sir.

Thank you man, very helpful, see you in the macro course!

Howdy. I’m in the process of creating an estimating spreadsheet with sheet 1 holding all the data. I just add dimensions and it works the cost out and links to an estimate sheet ( sheet 2) is it possible to do this without it creating blank rows on the estimating sheet? I used IF function to swap info to estimating sheet. If dimensions cells are filled etc

Great exercise, Jon. Thank you.

My method:
+ choose the column always has data.
+ Use function Goto in excel: Crtl+G > Special > Blank
+ Ctrl + "-" > Select "Entrire Row"

Hi!
I am Liazul, I am using Excel 2007. I don't find "My Macro" on Toolbar. How can i get it? Please tell me.

thx

Thanks Jon. Enjoying the tips

Thanks For the tip very Handy

Thank you Sir

Very useful macro, thank you for sharing