keyboard shortcut

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

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 wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thank you very much.
That worked.


"Debra Dalgleish" <[email protected]> wrote in message
news:[email protected]...
> 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 wrote:
>> 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
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>

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

"Dave" wrote:

> Thank you very much.
> That worked.
>
>
> "Debra Dalgleish" <[email protected]> wrote in message
> news:[email protected]...
> > 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 wrote:
> >> 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
> > Excel FAQ, Tips & Book List
> > http://www.contextures.com/tiptech.html
> >
>
>
>