Scroll bar moves too short

[Dima]

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

 

[Niek Otten]

Hi Dima,

Look here:

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

 

[Dima]

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

 

[Bob I]

Select and delete all rows after 473.

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

:

 

[Dima]

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

 

[Dima]

Thanks David for replying!
I'm sure that I saved, closed the file, and reopened.

 

[Bob I]

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

 

[Dima]

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]

Then perhaps you have a macro that accesses a cell on row 50147?

 

[Dima]

Thanks Bob for the suggestion!
I did not find a macro that accesses a cell on row 50147 and I deleted all
marcos in the Macro window. But I still get a a window asking if I want to
allow running of macros at the xls file opening.
Regards,
Dima

 

[Bob I]

There is certainly more to this than meets the eye. Perhaps you want to
copy just that worksheet to a new workbook instead.

 

[Dima]

Thanks Bob for your suggestion!
The problem exists in the copy in another work book too.

 

[Dima]

The prompt window to allow a macro does not appear when I open the other file
with the copy of the sheet.

 

[Bob I]

Where does CTRL-G, Special, Last Cell take you to now?

 

[Dima]

CTRL-G, Special, Last Cell takes me to the same cell BG473

 

[Bob I]

Ok, then all is correct with the location Excel is identifying as Last
Cell. Perhaps there is something set in Print area that is doing this?

 

[Dima]

Thanks Bob for suggesting!
The print area ends in row 472.

 

[Dima]

I still have not resolved the problem.

Ok, then all is correct with the location Excel is identifying as Last
Cell. Perhaps there is something set in Print area that is doing this?

 

[Bob I]

We have exhausted the items that I know of, perhaps you may run Office
Diagnostics on the Office installation.

 

[Gord Dibben]

I don't see anywhere that OP SAVED the workbook after deleting rows and
columns not being used.

Where does CTRL + End go?


Gord Dibben MS Excel MVP