See Debra Dalgleish's site for some ways to reset the last used cell:
http://www.contextures.com/xlfaqApp.html#Unused

deepnsteep wrote:

If information is deleted in a set of cells, it seems like Excell
retains the scrolling properties. What I mean is that the scrollbar
still shows that there is data to where it was before it was deleted.
Anyone know how to fix this?

Also, when using shortcut keys....in particular copying a formula to
the end of a data set, is there a way to use the CTRL+SHIFT+END to
scroll to the end of a particular column if say that column was just
added in the middle of a data set?

Thanks!

--
deepnsteep
------------------------------------------------------------------------
deepnsteep's Profile: http://www.excelforum.com/member.php...o&userid=25005
View this thread: http://www.excelforum.com/showthread...hreadid=385308

--

Dave Peterson