Scrolling Annoyances

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!

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

To fix the scrolling problem, the information here will help you reset
the used range:

http://www.contextures.com/xlfaqApp.html#Unused

To fill a formula down to the last row of data, you can select the cell
with the formula
Then, double-click the fill handle, at the bottom right of the selected
cell.
That will fill down, as far as the data on the left.


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!
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html