ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Lower Boundary of Vertical Scrollbar (https://www.excelbanter.com/excel-discussion-misc-queries/63278-lower-boundary-vertical-scrollbar.html)

noplasma

Lower Boundary of Vertical Scrollbar
 

I've got a little annoyance that I'm hoping someone can help me with.
My excel table contains 2500 lines of data. If I hit Ctr-End, it
correctly takes to me the 2500th line. However, if I scroll to the
bottom of the spreadsheet using the vertical scroll bar, it takes me to
the 4600th line (past about 1500 blank lines below my data).

I've tried selecting rows 2500 through 4600, deleting them, and then
saving the file -- this approach usually fixes the problem for me --
but that isn't fixing my problem.

Any ideas?


--
noplasma
------------------------------------------------------------------------
noplasma's Profile: http://www.excelforum.com/member.php...o&userid=30154
View this thread: http://www.excelforum.com/showthread...hreadid=498355



All times are GMT +1. The time now is 04:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com