keyboard shortcut

[Dave]

Hello
According to Office Assistant Online, if you click Ctrl Home, it places the
insertion point to the beginning of the worksheet. And if you click Ctrl
End, it moves the insertion point to the last used cell on the worksheet.
My last row is 256 but Ctrl End takes the cursor to row 449 which is miles
away.
I've made absolutely sure there is nothing between 256 and 449 but it still
does it.
Can anyone help please
Dave

 

[Debra Dalgleish]

Sometime Excel remembers data or formatting that you removed from the
worksheet. There are instructions here for resetting the last cell:

http://www.contextures.com/xlfaqApp.html#Unused

 

[Dave]

Thank you very much.
That worked.

Sometime Excel remembers data or formatting that you removed from the
worksheet. There are instructions here for resetting the last cell:

http://www.contextures.com/xlfaqApp.html#Unused

 

[Guest]

Also, "save-as" the file to itself works for me.

Thank you very much.
That worked.