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
--
Regards, Jack Sadie
jaxalad-(E-Mail Removed)

On Mar 27, 11:44 am, "Jack Sadie" <jacksa...@btinternet.com> wrote:
> 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
> --
> Regards, Jack Sadie
> jaxalad-buy...@yahooREMOVE.co.uk

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

Glen

SAVE *before* closing!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Mar 27, 11:44 am, "Jack Sadie" <jacksa...@btinternet.com> wrote:
>> 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
>> --
>> Regards, Jack Sadie
>> jaxalad-buy...@yahooREMOVE.co.uk
>
> One way is to select all blank rows and delete. Then close and open
> the spreadsheet. That should reset the scroll bar.
>
> Glen
>

On 27 Mar 2007 12:01:02 -0700, "(E-Mail Removed)"
<(E-Mail Removed)> wrote:

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

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

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.

--
Zilbandy

Debra Dalgleish documented some techniques:
http://contextures.com/xlfaqApp.html#Unused

Maybe it's worth one more attempt.

Zilbandy wrote:
>
> On 27 Mar 2007 12:01:02 -0700, "(E-Mail Removed)"
> <(E-Mail Removed)> wrote:
>
> >> 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 ?
>
> >One way is to select all blank rows and delete. Then close and open
> >the spreadsheet. That should reset the scroll bar.
>
> 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.
>
> --
> Zilbandy

--

Dave Peterson

On Wed, 28 Mar 2007 07:05:49 -0500, Dave Peterson
<(E-Mail Removed)> wrote:

>Maybe it's worth one more attempt.

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.

--
Zilbandy

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!

--
Regards, Jack Sadie
jaxalad-(E-Mail Removed)
"Jack Sadie" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

> 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
> --
> Regards, Jack Sadie
> jaxalad-(E-Mail Removed)
>