Did you save the workbook?

Did you close it and reopen it (then check it)?

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused

Woody13 wrote:

sorry if this is a double post. My excel workbook is too large and I think
the problem is that I copied formats to the end of the sheet. When I hit
"Ctrl + End" it goes to the end of the sheet even though I have deleted the
cells and the rows manually. Any help is appreciated?

--

Dave Peterson