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