stop the runaway when highlighting a range of cells!

[COZWV]

When I try to highlight a range of cells to copy data etc... to those cells, once I go below the window the sheet shoots down about 300 rows before I can stop it. For instance, I want to highlight cell A1 and move down the row to cell A75. When I try to move beyond the edge of the open window it will shoot down to about cell A300 before I can get it to stop. If I am really careful and move the pointer very carefully at the edge of the window then it will scroll down very slowly. Basically trying to highlight anything beyond the actual screen you are on will result in this.

How can I get the sheet to stop moving so fast when I do this?

 

[DaleWatson123321]

One option would be don't use the mouse, but instead...

a) While holding down the <Shift> key,
b) Use the <PageDown> key, and the <Arrow> keys

And of course, instead of "holding down" the <PageDown> key and <Arrow> keys, only "hit" the keys. This will give you the necessary precise control you're seeking.

Hope this helps

Regards, Dale Watson

 

[khobson]

Dale's tip works fine of course. The problem and solution are typical for many windows applications. To add to that, I like to press Shift+End and then Shift+down. This selects to the next empty cell down.

Using the mouse, you can solve the problem if you turn off autocalculation first.

 

[COZWV]

Thanks very much, That helps tremendously!

COZWV