Thanks Bob for replying!
I did not delete contents. I deleted the rows with R-click menu Delete. (not
pressing Delete key)
Regards,
Dmitry

"Bob I" wrote:

Sounds like you deleted contents not the rows. Delete the rows with
R-click menu Delete.(not pressing Delete key)

Dima wrote:

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