3 Easy Ways to Delete Blank Rows in Excel ✅

In this video, I will show you three ways to delete blank rows in Excel.
00:00 Intro
00:10 Go To Special to Delete Blank Rows
02:51 Delete Blank Rows Using the SORT Option
05:25 Delete Blank Rows Using Find and Replace
08:20 VBA to Delete Blank Rows
--------------------------------------------------------------------------------
Here is the VBA code I used in the video:
'Code Developed by Sumit Bansal from TrumpExcel.com
Sub DeleteBlankRows()
Dim EntireRow As Range
On Error Resume Next
MsgBox Selection.Row.Count
Application.ScreenUpdating = False
For i = Selection.Rows.Count To 1 Step -1
Set EntireRow = Selection.Cells(i, 1).EntireRow
If Application.WorksheetFunction.CountA(EntireRow) = 0 Then
EntireRow.Delete
End If
Next
Application.ScreenUpdating = True
End Sub
----------------------------------------------------------------------------------
While most people I see use the Go To Special option, it has a big drawback. It would also delete rows where only some of the cells are blank. None of the methods I have covered in this video have this issue.
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: ruclips.net/user/trumpexc...
#Excel #ExcelTips #ExcelTutorial

[@trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.
Also, I have made all of my Excel courses available for free. You can check these out using the below links:
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course

[@Satwant2463]

Thank you. Excellent explanation.

[@trumpexcel]

Glad you found the video useful

[@nadermounir8228]

Thank u Trump for this nice video especially the VBA solution

[@trumpexcel]

Thanks... Glad you found the video useful :)

[@brianmaggs8714]

👍Very useful, especially for spreadsheets with many blank rows to be eliminated.👍

[@trumpexcel]

Glad you found the video useful 😊

[@Unpleasant_Truth96]

Thank you. Very useful

[@trumpexcel]

Thanks... Glad you found the video useful :)

[@einoconsult5563]

Thanks, Power Query is also a good way to do it :)

[@trumpexcel]

True... I think I got lazy and didn't add that as another method. I did include it in the written article here - trumpexcel.com/delete-blank-rows-excel/

[@udayasankar5930]

Fantastic!!! Congratulations👍

[@trumpexcel]

Thank you... Glad you found the video useful

[@pancux670]

Very nice and we'll explained as usual

[@trumpexcel]

Thanks for commenting... Glad you found the video useful

[@rajeevgosavi4514]

Nice and very informative.

[@trumpexcel]

Glad you found the video useful

[@ktp.]

Happy New Year Sumit! Great video and will tune in to more as I am subscribed. 💯🎉

[@trumpexcel]

Thank You and Happy New Year 😊

[@IvanCortinas_ES]

Hi Sumit!!! Excellent explanation!!

[@trumpexcel]

Thanks Iván... Good to see you in the comments section 😊

[@uppalapatikarthik]

Long time no see!

[@trumpexcel]

Been a while since I created videos. Planning to release new video every week now.

[@roselyncrasco6318]

Thank you Sir for the update. It is very useful for me who are using excel for our Daily Monitoring Data. I have concerns for my data. Since I add more cell and column and rows , as I search for the specific data I want to input my daily monitoring it is very loading............. Is there anything I must do to lessen the search or loading?

[@chintanvasavada5475]

Lovely Brother

[@trumpexcel]

Glad you found the video helpful 🙂

[@chintanvasavada5475]

@@trumpexcel yes and problem was solved as well. Although I was able to remove blanks using the filter post the first step of naming the blanks and not blanks.

[@soniccheese01]

Like the different approaches to removing blanks. I would highlight column A and turn on Filters, then select Blanks and delete the returned blanks rows, then switch off filters.

[@trumpexcel]

But that can be issue if the blank cell is only in column A and the rest of the row in not blank

[@peterstratton9516]

HNY! Thanks!

[@trumpexcel]

HNY Peter... Glad you found the video useful :)

[@suneethamerlapaku8723]

Explain about hlookup and pivot table

[@trumpexcel]

These videos might interest you:
- ruclips.net/video/wn_YO1t9C5o/видео.html
- ruclips.net/video/4Q0FYcvIfFg/видео.html
- ruclips.net/video/5TkRnGdC1NM/видео.html

[@michaellundsrensen2292]

Thanks, long time!
In the example, why not click on the box above "1" and to the left of "A". And then sort column A?

[@trumpexcel]

It would mess up the original dataset. So if that is not a concern, we can sort and get rid of the blank rows

[@abhisheksamantray5244]

sir, we can delete row by using filter also

[@trumpexcel]

It can be issue if the blank cell is only in column where you have applied the filter and the rest of the row is not empty

[@akashdeshmukh116]

Where have you been...?? 🤔🤔
Now it's time for BI.. ✔️

[@trumpexcel]

Soon my friend.. I need to learn BI well enough first to start making videos on it

[@mohmmedimran3000]

Delete ni hora Bhai please help me

[@meghajoshi1545]

hI DO YOU DO ONLINE TUTORIAL ??

[@salmaalaa6158]