Clearing unseen data

[Ralphael1]

I have a Excel page with data that ends at linbe 602 however when I
click alt end it jumps down to 2750.
I have tried deleting all the rown 603 to 2750 and clearing the
contents but it does not work. Anyone have a to solve this.
Thanks,
Ralphael, the OLD one

 

[Niek Otten]

After deleting the rows, save the file. That will set the new last cell.

 

[Gord Dibben]

And make sure you delete the rows, not just "Clear Contents".


Gord Dibben Excel MVP

 

[Ralphael1]

And make sure you delete the rows, not just "Clear Contents".


Gord Dibben Excel MVP

Thank you Gord, you have relieved a portion of my computer pain.

Ralphael, the OLD one