View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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