Deleting Blank Rows

[azizrasul]

I have deleted some populated rows at the end of a worksheet. How do I delete the blank rows at the end of the worksheet so that when I press Ctrl + End it goes to the last populated row rather than the original last row prior to deleting the records?

 

[Richard Schollar]

Hi

You may need to save the file down to reset the last row.

 

[azizrasul]

Thanks. So simple.