• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Delete Multiple Rows from big spreadsheet with ease

rumshar

Member
Sometimes you may have to delete rows(filtered data) from big spreasheets. It may take long time and sometimes even excel might crash also.I have encountered this may times and learnt a better way to deal with this situation.
Instead of deleteing entire rows(Ctrl + -) it is advisable to clear the contents only(del key) and then delete blank rows.
Another option is once you have removed the contents, you may sort your data. The blank rows come at the bottom, from there you can remove them very easily.
 
Top