Scroll bar moves too short

D

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
 
D

Dima

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

Bob I

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

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
 
D

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
 
B

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.
 
D

Dima

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

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?
 
D

Dima

I still have not resolved the problem.

Bob I said:
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?
 
B

Bob I

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top