too fast scrolling down when selecting several rows

[Sabine]

Hello,

I would like to change the speed that my screen is scrolling if I am
selecting several rows. I know that it depends of how far down you move your
mouse, but on some pc's the scroll speed is fine but on others it drives me
cracy. Have tried the mouse settings but this doesn't seem to help. Who
knows what is causing this high-speed and - even more important - a way to
slow down this behaviour?

Thank you in advance

Sabine

 

[Nick Hodge]

Sabine

There is no specific setting in Excel, but this usually shows that XL
'thinks' it has more rows than it actually does. When you use a worksheet
and delete rows they are not reclaimed immediately by XL, so if you use say
1000 rows and delete 900 XL will scroll much faster, normally past the 100
very quickly.

To rectify this pres Ctrl+End to see where XL believes the last cell
exsists. Now select all the 'extra' rows. (Note: complete rows, not just
the cells). Now take Edit>Delete (Not clear). This will do very little
(apparently). Do the same for 'excess' rows.

Now save the workbook and the 'UsedRange' should be reset.

This will help, but XL can still be frustrating sometimes ;-)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Sabine]

Nick,

Thank you for your help. I checked my spreadsheet (14 sheets, 72 kb) and
deleted all empty columns en rows as you described, but still it is almost
impossible to select with my mouse row 40 to (lets say) 300, it just races
on!
Strange enough it does not occur with a new, empty sheet, there the
scrolling speed can be much easier controlled by holding the mouse not lower
than the area with the sheet-tabs.

I also just found out that when I select / scroll in the A column then the
scrolling is annoyingly fast, but if I scroll in the B column it is normal.
Then I realized that I had the the A column freezed (freeze panes). When I
un-freeze the A-column the scrolling in the A column is normal. When I
freeze the A column again, the scroll speed is uncontrollably fast again.
Amazing is that if I during scolling drag my mouse over the active sheet
name then it is too fast, but if I I drag it over the next sheet (which is
not active) then the scroll speed is normal. Any explanations?

Looking forward to comments / help

Sabine

 

[David McRitchie]

Use the name box to the left of the formula bar and
enter 40:300