Excel 2010. I have a sheet of about 900,000 records in which there are about 90,000 I would like to delete. The rows are marked for deletion but I am not aware of a way to delete them and not have Excel hang there forever. I have tried filtering to the rows I would like deleted and cutting them, but that does not seem to be very quick. I have also tried just filtering the rows I want and copying them to a new sheet, leaving the unnecessary rows behind but that also is slow. Finally I have tried going cell by cell to do the deletion and again, it's painfully slow. My end goal is to be able to do this via a macro.

I hope there is some magical way out there that I don't know of to do this better but until then, I am stuck. If anyone has any suggestions, they would be greatly appreciated.

Joel