Here is something that has always bothered me about Excel.

If I open a very big spreadsheet, lets say one with 1000 rows. The
scroll bar works as expected. It is sized to reflect the fact that
there are 1000 rows, and it scrolls such that when it hits the bottom,
I am at the 1000th row.

If I then delete say 900 rows, the scroll bar does not adjust itself.
Now, the scroll moves just a nudge, and I am at the bottom the sheet.
This makes it impossible to click in the "gutter" of the scroll bar.
Surprisingly, this continues even after I close and re-open the sheet,
as though the information about the "size" of the sheet is stored in
the file.

Is there any way to correct that?

Dom

Hi Dom,

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message oups.com...
| Here is something that has always bothered me about Excel.
|
| If I open a very big spreadsheet, lets say one with 1000 rows. The
| scroll bar works as expected. It is sized to reflect the fact that
| there are 1000 rows, and it scrolls such that when it hits the bottom,
| I am at the 1000th row.
|
| If I then delete say 900 rows, the scroll bar does not adjust itself.
| Now, the scroll moves just a nudge, and I am at the bottom the sheet.
| This makes it impossible to click in the "gutter" of the scroll bar.
| Surprisingly, this continues even after I close and re-open the sheet,
| as though the information about the "size" of the sheet is stored in
| the file.
|
| Is there any way to correct that?
|
| Dom
|

Thanks. Works great.

Dom



Niek Otten wrote:
Hi Dom,

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message oups.com...
| Here is something that has always bothered me about Excel.
|
| If I open a very big spreadsheet, lets say one with 1000 rows. The
| scroll bar works as expected. It is sized to reflect the fact that
| there are 1000 rows, and it scrolls such that when it hits the bottom,
| I am at the 1000th row.
|
| If I then delete say 900 rows, the scroll bar does not adjust itself.
| Now, the scroll moves just a nudge, and I am at the bottom the sheet.
| This makes it impossible to click in the "gutter" of the scroll bar.
| Surprisingly, this continues even after I close and re-open the sheet,
| as though the information about the "size" of the sheet is stored in
| the file.
|
| Is there any way to correct that?
|
| Dom
|

In .com,
spake thusly:

Here is something that has always bothered me about Excel.

If I open a very big spreadsheet, lets say one with 1000 rows.
The scroll bar works as expected. It is sized to reflect the
fact that there are 1000 rows, and it scrolls such that when it
hits the bottom, I am at the 1000th row.

If I then delete say 900 rows, the scroll bar does not adjust
itself. Now, the scroll moves just a nudge, and I am at the
bottom the sheet. This makes it impossible to click in the
"gutter" of the scroll bar. Surprisingly, this continues even
after I close and re-open the sheet, as though the information
about the "size" of the sheet is stored in the file.

Is there any way to correct that?

I believe it corrects when you save the file. Can you confirm?

-dman-

Saving isn't sufficient. Nick gave the answer above.

Dom



Dallman Ross wrote:
In .com,
spake thusly:

Here is something that has always bothered me about Excel.

If I open a very big spreadsheet, lets say one with 1000 rows.
The scroll bar works as expected. It is sized to reflect the
fact that there are 1000 rows, and it scrolls such that when it
hits the bottom, I am at the 1000th row.

If I then delete say 900 rows, the scroll bar does not adjust
itself. Now, the scroll moves just a nudge, and I am at the
bottom the sheet. This makes it impossible to click in the
"gutter" of the scroll bar. Surprisingly, this continues even
after I close and re-open the sheet, as though the information
about the "size" of the sheet is stored in the file.

Is there any way to correct that?

I believe it corrects when you save the file. Can you confirm?

-dman-

In .com,
spake thusly:

Saving isn't sufficient. Nick gave the answer above.

Okay, thanks. I saw his post hit my server after I posted
and refreshed the group.

-dman-