If I hit ctrl + end, I end up half a million rows past my data. I go to my last data point, select all the rows from past my data, shift+ctrl+down arrow, delete, clear all, remove rows, save, close, reopen. But once again, ctrl + end and I'm at the same spot. No formulas calling past my data, no formatting, nor any named ranges. Anything to do with this sheet causes a near collapse of excel and the file size has jumped up 10x. Anything I'm missing? Any help would be greatly appreciated