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