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: kzread.info...
#Excel #ExcelTips #ExcelTutorial
Пікірлер: 44
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
Thank you. Excellent explanation.
@trumpexcel
6 ай бұрын
Glad you found the video useful
Long time no see!
@trumpexcel
6 ай бұрын
Been a while since I created videos. Planning to release new video every week now.
Fantastic!!! Congratulations👍
@trumpexcel
6 ай бұрын
Thank you... Glad you found the video useful
Thank you. Very useful
@trumpexcel
6 ай бұрын
Thanks... Glad you found the video useful :)
Very nice and we'll explained as usual
@trumpexcel
6 ай бұрын
Thanks for commenting... Glad you found the video useful
Hi Sumit!!! Excellent explanation!!
@trumpexcel
6 ай бұрын
Thanks Iván... Good to see you in the comments section 😊
👍Very useful, especially for spreadsheets with many blank rows to be eliminated.👍
@trumpexcel
6 ай бұрын
Glad you found the video useful 😊
Thanks, Power Query is also a good way to do it :)
@trumpexcel
6 ай бұрын
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/
Nice and very informative.
@trumpexcel
6 ай бұрын
Glad you found the video useful
Thank u Trump for this nice video especially the VBA solution
@trumpexcel
6 ай бұрын
Thanks... Glad you found the video useful :)
Happy New Year Sumit! Great video and will tune in to more as I am subscribed. 💯🎉
@trumpexcel
6 ай бұрын
Thank You and Happy New Year 😊
Lovely Brother
@trumpexcel
4 ай бұрын
Glad you found the video helpful 🙂
@chintanvasavada5475
4 ай бұрын
@@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.
HNY! Thanks!
@trumpexcel
6 ай бұрын
HNY Peter... Glad you found the video useful :)
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?
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
6 ай бұрын
But that can be issue if the blank cell is only in column A and the rest of the row in not blank
Explain about hlookup and pivot table
@trumpexcel
6 ай бұрын
These videos might interest you: - kzread.info/dash/bejne/qaKTu7FqpJypZdI.html - kzread.info/dash/bejne/ZoVkqLucpqzMdso.html - kzread.info/dash/bejne/Z4iftNCAlKaXfrA.html
Where have you been...?? 🤔🤔 Now it's time for BI.. ✔️
@trumpexcel
6 ай бұрын
Soon my friend.. I need to learn BI well enough first to start making videos on it
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
6 ай бұрын
It would mess up the original dataset. So if that is not a concern, we can sort and get rid of the blank rows
sir, we can delete row by using filter also
@trumpexcel
6 ай бұрын
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
hI DO YOU DO ONLINE TUTORIAL ??
Delete ni hora Bhai please help me