3 Easy Ways to Delete Blank Rows in Excel ✅

[@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 😊

[@ktp.]

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

[@trumpexcel]

Thank You and Happy New Year 😊

[@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?

[@IvanCortinas_ES]

Hi Sumit!!! Excellent explanation!!

[@trumpexcel]

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

[@Unpleasant_Truth96]

Thank you. Very useful

[@trumpexcel]

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

[@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

[@carteeku]

Long time no see!

[@trumpexcel]

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

[@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/

[@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

[@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

[@suneethamerlapaku8723]

Explain about hlookup and pivot table

[@trumpexcel]

These videos might interest you: - kzbin.info/www/bejne/rZ_CioJnqZ52a9E - kzbin.info/www/bejne/aoKTd4yZq66ZfMk - kzbin.info/www/bejne/a4XOg6F9mahkhK8

[@peterstratton9516]

HNY! Thanks!

[@trumpexcel]

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

[@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.

[@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

[@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

[@mohmmedimran3000]

Delete ni hora Bhai please help me

[@meghajoshi1545]

hI DO YOU DO ONLINE TUTORIAL ??

[@salmaalaa6158]