If you're going to far to the right or too far down, it could be because excel
sees your used range as more than you see it.

Debra Dalgleish has some techniques for resetting the last used cell at:
http://www.contextures.com/xlfaqApp.html#Unused

Surreal wrote:

I want to be able to hit "end of page" (CTRL END) and have it go no further
than row 100 and column AZ but i cannot figure out how to do it.

--

Dave Peterson