Excel Scroll Bar

[Mark31]

Is there a way to reset the vertical scroll bar in excel so that it is calibrated to the information on the sheet rather than what used to be on the sheet?

 

[IRstuff]

You close and re-open the sheet. If there's still a problem, then the added cells contain non-null data or formatting that keeps the active sheet extents out past what you think is data.


TTFN

 

[onlyadrafter]

Hello,

How about copying the known rows to a new sheet and then deleting the old sheet.

----------------------------------
Hope this helps.
----------------------------------

maybe only a drafter
but the best user at this company!