How to Delete Blank Rows in Excel

Sign up for our Excel webinar, times added weekly: www.excelcampus.com/blueprint...
In this video we look at 3 WAYS to delete blank rows in Excel with Filters, Formulas, and a VBA Macro. These techniques focus on deleting or removing entire blank rows from a worksheet.
This is a common task for exported reports, and we need ways to delete the blank rows quickly.
I explain how to filter for blanks, how to create a column of COUNTA formulas to count all the cells in a row that are not empty, and how to use a macro to quickly select the blank rows.
Here are the links mentioned in the video:
Download the file with the macro & read the full article: www.excelcampus.com/tips/dele...
Beginner's Guide to Excel Tables Video: • Excel Tables Tutorial:...
How to turn off Table formulas (structured references):
www.excelcampus.com/library/t...
Excel Filters Training 3 Part Series: • Excel Filters Training...
Personal Macro Workbook 4 Part Series: • The Personal Macro Wor...

[@JohnsonKongor]

Great exercise, Jon. Thank you.

[@uc7602]

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

[@ExcelCampus]

You're welcome! 😀

[@danielblank497]

Very helpful. Thank-you Jon!

[@janezklun]

Very useful macro, thank you for sharing

[@brucemalek2811]

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

[@alfredoespinozapelayo]

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

[@knowledgekapiti8673]

Excellent video, thank you

[@bigtall8199]

Thanks Jon. Enjoying the tips

[@melissamagdelinmoodley4382]

Thank you!!! So helpful and quick.

[@johnmorgan1808]

Thanks Jon. This was very helpful!

[@DougHExcel]

Thanks for the tips!

[@qwantez1973]

Dude, you are freaking awesome. Thank you sir.

[@RS-io8rp]

Your videos are well sorted, neat and straight to the point where it's easy to understand , I am a pro nurse transitioning to data analyst and your video help me very well. Thanks man

[@ExcelCampus]

Thanks Richard! ;-)

[@gopinath8556]

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

[@gopinath8556]

Iam very happy now.after so many comments posted on your channel This is the first time i got like from you

[@beassanchala]

Thanks! It helped.

[@m.raedallulu4166]

Smart way!
Thank you!

[@zeeshanahmed4443]

Very Helpful... Thanks

[@apprendredavantage]

Thanks lot for the shared lessons learned and its helpfully

[@enganga8335]

Thank you, Jon.

[@Vanisha942]

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

[@hussamalh8554]

Great Tip, Thanks

[@mohamedchakroun4973]

Thanks For the tip very Handy

[@atysillia2490]

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!!

[@ExcelCampus]

You're welcome! 😀

[@edwarddizengoff8414]

Great video thank you so much!

[@sasavienne]

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

[@RahulKumar-ly6ly]

Thanks sir

[@zikrekhair83]

Thanks a lot, you make my day bro!

[@cncplasmacuttingmachineaut3090]

I am sure you are a excel genius

[@AnalyticsInDetails]

One of a time saving macro, Sir your explanation and efforts are appreciated.

[@ExcelCampus]

Thanks Vijay! ;-)

[@elijahpowers6987]

Very useful
Thank you very much Sir

[@RajanikantaSit]

Thank you Sir

[@FawazMorad]

Thanks, good tips

[@khanraseen]

thanks for the help

[@CCAFO]

Great!

[@9840708603]

Hi Jon, Your videos are of great help.Another function that I use is filter the blank rows then press F5, select visible cells only and then hit delete. I hope this works too.

[@ExcelCampus]

Thanks for the suggestion Shinu. The Go To Special menu is another good alternative if you have a column that only contains blank cells in the entire blank rows. Thanks again and have a good one! :-)

[@jaygee401]

Thank you.

[@Orbi_2024]

thanks very much

[@LabyrinthSchool]

Sir you are the man live long and teach

[@aguerojg]

Thank you very much Jon, the tips are great and save much time!

[@samcollura8034]

thanks

[@imranali-iy5wk]

Very nyce sir

[@mahmoodhassan7158]

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

[@ExcelCampus]

Glad it helped! 😊

[@rogerrabbit2902]

Same.. I loved it..

[@tannertucker22]

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

[@satheeshkumar-jm4hl]

perfect

[@justintomas5740]

Another good video Jon! I like the COUNTA function, I've never used this before.
The method I use to find blank rows is 'Go to' then 'Special' then filter for blanks.

[@ExcelCampus]

Thank you Justin! The Go To Special menu is another good alternative if you have a column that only contains blank cells in the entire blank rows. Thanks for the suggestion! :-)

[@hits5047]

awesome
awesome
awesome
awesome
awesome
awesome

[@mohamedbadawy3677]

thx

[@paulbryan3757]

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

[@asani7087]

Very useful, thanks
How to delete automatically in Macros?

[@MarA-md8sc]

for raw data use sort function

[@zerogr88]

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

[@JRFamily.]

thanks

[@sachinjain5698]

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

[@scottcalvert7984]

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

[@epca_aq6511]

This works nicely (if you select all you cells first AND are sure there are no dups except blanks).

[@LiazulIslam]

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.

[@RohitSingh-nu7ek]

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

[@muhammadobaidullah561]

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

[@muhammadzafar420]

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

[@supercollectionstudio5572]

You can quickly delete or remove or highlight empty rows using this Dose for Excel add-in which provides also more than 100 functions to Excel:
www.zbrainsoft.com/excel-delete-rows.html

[@ernaniramos1292]

Thank you Sir