LisaH wrote:
I have been working on spreadheets with large amounts of data, that I have
manipulated and some of which I have deleted, when I want to select it all,
and press CTRL+SHIFT+END is goes row 14000 where the data originally ended
instead of 6000 where it ends now.
I wondered if there was anyway to reset what excel considers the last used
cell to be?

Hi LisaH

Save the workbook, the used range will be re-calculated.

Regards

Steve