I'm creating a high school directory using Excel 2002. Once in a while I
will get typing a little too fast and turn off Num Lock and then I end up in
the wrong cell. I'd like to be able to return to the last line in the
table; I thought Ctrl-End would take me there, because Ctrl-Home always
takes me to A1. But even though the last entered line is (currently) 243,
Ctrl-End takes me to 10098.

Help!

Julia

Visit Debra Dalgleish's site for some techniques for resetting that
lastusedcell.
http://www.contextures.com/xlfaqApp.html#Unused

Julia wrote:

I'm creating a high school directory using Excel 2002. Once in a while I
will get typing a little too fast and turn off Num Lock and then I end up in
the wrong cell. I'd like to be able to return to the last line in the
table; I thought Ctrl-End would take me there, because Ctrl-Home always
takes me to A1. But even though the last entered line is (currently) 243,
Ctrl-End takes me to 10098.

Help!

Julia

--

Dave Peterson

Thank you! That worked.

Julia

"Dave Peterson" wrote in message
...
Visit Debra Dalgleish's site for some techniques for resetting that
lastusedcell.
http://www.contextures.com/xlfaqApp.html#Unused

Julia wrote:

I'm creating a high school directory using Excel 2002. Once in a while I
will get typing a little too fast and turn off Num Lock and then I end up
in
the wrong cell. I'd like to be able to return to the last line in the
table; I thought Ctrl-End would take me there, because Ctrl-Home always
takes me to A1. But even though the last entered line is (currently)
243,
Ctrl-End takes me to 10098.

Help!

Julia

--

Dave Peterson