Comments on: How to remove all blank rows in Excel

In this quick tip I will explain why deleting Excel rows via select blank cells -> delete row is not a good idea and show you 3 quick and correct ways to remove blank rows without destroying your data. All solutions work in Excel 2016, 2013 and lower. Continue reading →

Comments page 5. Total comments: 129

  1. Very Nice Macro

  2. Really useful to me and saved my lots of time.

  3. Its really useful to me and saved my lots of time.

  4. This crap doesn't work for large data sets, whats the point?

  5. Hi,

    In fact your tutorial was very helpful to me and I really thank you for that. Hope to learn a lot from you. Thanks once again.

  6. Thank u very much. Saved my precious time.

  7. is there a way to delete the rows on the bottom of my work sheet so i only see the data that i am finished with.

    1. I am sorry it is not very clear what result you want to get. Please send an example to support@ablebits.com

  8. Hello, When I tried to remove the empty rows using the Option 1,i.e (Apply filter to key column), the first row is also being deleted after the data is filtered.
    i.e I don't see the first row after deleting the empty rows. When I press Ctrl+Home after filtering, the first row is also getting included along with blank rows.
    Any idea , How to get rid of this??

  9. it really helped...many thanks..

  10. Thanks! I've been doing this the long way for far too long. This was excellent help!

  11. i cant find the albeits quick tool on excel. help

  12. Thank you Alexander :)

  13. Thanks a ton,something new i learned.

  14. If you have unique data in each row or wish to only keep unique records, another way is to select all data, go to Data -> Remove duplicates. A pop-up will appear and you can select the column you wish to use as your key. it will remove all blank rows after the first blank row in that column. Repeat for each column that has blank rows.

    1. Hi Mason,

      Thank you for this tip. Just want to point out for other users that this method removes the duplicate rows with data as well.

  15. Works simply wonderful! You have to copyright this boss or Microsoft is going to steal this idea!

  16. i used to do
    1>just filter blank only
    2> insert one row
    3> delete which row i insert
    4> now i can delete in one click all blank row

    1. Could you explain in detail ？ It doesn't make sense to me.

  17. The instructions were great! What a time saver. Thanks!

  18. did not help me as i hve data with merges fields and i want to delete only the rows which are completely empty in all the cells

  19. Life Saver!

  20. Finally! The F5 option is available everywhere, but messed up my lists - this was exactly what I wanted, thanks a lot =)

    1. Glad to know it has been useful for you : )

  21. this worked wonders thanks

  22. Just wanted to point out that the options suggested above which use Key column and filter will only work when you are working with filters within a table. This is a just a small nuance that makes a big difference. If you do try to filter without a table, you will delete all rows that are not seen as well.

    Thanks for this post Alex. Found it very helpful!

  23. Very thanks boss..

  24. Thank you for this tip,
    I'm looking to remove empty columns (and yes, I did inadvertently nuke valuable data by using the online recommendation for the find/special/blanks method-arghh.)

    I would like to purchase your product for download but my company is paranoid about any downloads that aren't authorized.
    Do you have some sort of "safety" insurance that I could provide to our CTO to assure them that there isn't a bug or other problematic hidden code in your software?
    Thanks much,
    Lynn

    1. Hi Lynn,

      Thank you for your interest in our product.

      Obtaining an official "safety insurance" document is a pretty long and quite expensive procedure, which is why we cannot provide any. However, all our code and all setup packages of our add-ins are signed with Symantec Code Signing Certificate. Our company, Add-in Express Ltd., has been working on this market for many years and we are a long-term Microsoft Visual Studio Industry Partner.

  25. Thank you very much for the article. Very helpful.

  26. Dont try F5 way to del, very nice tutorial. thanks alot bro

  27. 110% applicable. I've tried personally.

  28. nice.......

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)