excel ctrl + home

[thesquirrel]

help

I have a spreadsheet that I have modified where data ewas stored previously. Since modification the end of the spread sheet has changed. I press 'ctrl+end' to go to the new end, but, I end up at the old 'ctrl+end'. Can anyone shed any light on this.

 

[TonyJollans]

Hi thesquirrel,

There have been many discussions on this subject here. If you have deleted some data so that the last cell has come closer to home, the last cell used pointer does not get updated until you save the workbook.

Enjoy,
Tony

 

[straybullet]

Delete the now-unused rows (entire rows), hit Ctrl+Home to go back to A1 - then hit Save. The new destination for Ctrl+End should be the "true" end.