Thanks Bob for replying!
I deleted all rows after 473. This does not resolve the problem in my file.
Regards,
Dmitry
"Bob I" wrote:

Select and delete all rows after 473.

Dima wrote:

Thanks Niek for replying!
I did what is written on http://www.contextures.com/xlfaqApp.html#unused
This does not change anything in my file.
My scrollbar goes to row 50147 -- my data ends in cell BG473.
Regards,
Dima

"Niek Otten" wrote:


Hi Dima,

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dima" wrote in message
...

Hello!
A sheet scrolls to a data end with a vertical scroll bar in 1/50 of a
lenth
of a scroll bar area from the upper end.
How to make the sheet scroll to the data end with the scroll bar movement
to
the scroll bar area end?
Regards,
Dima