Ctrl + end on my excel sheet takes me to row 1048576 but last data is in row 5139

Hi,

I have an excel file that is currently 27,421KB.
It was previously 33,000KB but I have taken out 15 tabs sheets and packaged this up as a separate file.

I still think I can bring it down further by clearing it up and one thing I am doing is stepping through each tab sheet and pressing ctrl + end.
And I noticed that a lot of them are taking me way far too down than where my last data actually is.

I am trying to clear these blank excess rows by deleting them but I get a warning message saying this operation affects a large number of cells > I click ok and then I get an Excel error message Excel ran out of resources.

I do not have any other applications running when I am doing this.

Is there anyone out there that has dealt with this kind of issue successfully?

Thank You

Try clearing the excess formatting.

you can read more about it at below links.

https://support.microsoft.com/en-us/...9-4874f7474738
https://support.microsoft.com/en-us/...rs=en-us&ad=us

.
Have you created a cell border that extends to every cell in a Column ? Down to row 1048576 ? That will cause the issue.

The same will occur if you have colored the cell interior / background for every cell in a column.