And when you say you deleted the rows you mean you selected the rown numbers
from say 50 down to 1,048,576 and press Ctrl+- (control minus), not the Del
If you did that, try moving to a new blank worksheet and inserting a row at
row 1. If it works you know that there is a problem on the other sheet. It
may be a hidden object, such as a chart, shape, textbox, comments..., you can
try to find them by choosing Office Button, Excel Options, Advanced and
making sure that
For cells with comments, show is set to something other than No comments or
And that For objects, show is set to All.
Then return to the spreadsheet and choose Home, Find & Select, Selection
Pane, and see what you find.
Alternative #2, copy everything from your current sheet to a new sheet.
Select on the rows where you think there is stuff.
If this helps, please click the Yes button.