Vertical Scrolling

  • Thread starter Thread starter Jack Sadie
  • Start date Start date
J

Jack Sadie

In most of my spreadsheet files if I drag the scroll button to the bottom it
moves the sheet down to the extent of my data.

However I have one small rogue spreadsheet file with less than 500 rows.
The vertical scroll button is so tight to the top of its traverse that I
cannot click in the space above the button. If I drag the button to the
bottom limit it brings me to the limit of the spreadsheet i.e. approx the
65000th row !

How on earth have I come to configured it thus and, please, how can I adjust
it back to normal ?
TIA
 
In most of my spreadsheet files if I drag the scroll button to the bottom it
moves the sheet down to the extent of my data.

However I have one small rogue spreadsheet file with less than 500 rows.
The vertical scroll button is so tight to the top of its traverse that I
cannot click in the space above the button. If I drag the button to the
bottom limit it brings me to the limit of the spreadsheet i.e. approx the
65000th row !

How on earth have I come to configured it thus and, please, how can I adjust
it back to normal ?
TIA
Click to expand...

One way is to select all blank rows and delete. Then close and open
the spreadsheet. That should reset the scroll bar.

Glen
 
One way is to select all blank rows and delete. Then close and open
the spreadsheet. That should reset the scroll bar.
Click to expand...

I, too, have some worksheets that behave that way, I've highlighted
all unused rows, deleted, and saved and the behavior still exists. On
other worksheets, I have no problems. I'm using Office 97. Maybe
someone has some additional ideas. :)
 
Maybe it's worth one more attempt.
Click to expand...

Her technique worked. I was selecting the rows by clicking on the
number in the row column at far left of worksheet, then using
<ctrl-shift-downarrow> to highlight all the remaining rows. Then I
would hit the delete key. Her method said to click a single cell in an
unused row and then use <ctrl-shift-downarrow> to highlight all the
remaining cells in that row. Here's the major difference in our
techniques. Her instructions then said to right click on the
highlighted cells and choose delete. Then check the box for "Entire
row" and hit "Ok". This worked, where just using the "delete" key
didn't. At that point, I saved the file and shut down Excel, as
suggested for older versions (I'm using Excel 97). Upon restarting
Excel, the scrolling issue was fixed. Thanks for link, and thanks to
Debra for the page. :)
 
Thanks so much all of you. And especially Dave Peterson / Debra Dalgleish
cos like Zilbany, that worked for my file.
Really grateful to all of you!
 
Back
Top