Controlled Scrolling 1

[rdbuller]

I knew how to do this at one time ....

I scroll through an excel spreadsheet and select rows that extend beyond a single sheet.
How do I slow the scroll and prevent its speed scroll to high row numbers?

rbul@Toast.net

 

[tf1]

I guess you meant to say beyond a windows pane. If you press F1 and type in Keyboard Shortcuts, one of the (many) sections is Move and Scroll within Worksheets. There are many advanced ways to move around your worksheet using keyboard shortcuts and it is worth looking to see all the options available. On large worksheets, it is far more effective than using the scrolling mouse as you can jump instantly from one end to the other end of a populated range, or named range, etc.

You can also adjust the scrolling from the Intellimouse setup. You may find that reducing or even turning off the scrolling acceleration may find it more amenable to your use.

Regards: tf1

 

[rdbuller]

Oops! Move and Scroll is not an entry of Help as I am still using Win98 SE.

Am still looking for a keyboard avenue for decreasing scroll speed or scrolling through sheets row by row ( or column by column.

Thanks,

rbul@Toast.net

 

[tf1]

I was talking about F1 in Excel rather than Windows!

tf1

 

[rdbuller]

In pursueing a solution I re-discovered how this works.

This works in QPro 5.0 for Windows also.

After selecting the block of cells hold down shift and press the down arrow as necessary to expand the block beyond the current pane.

Thanks for respoding, rdbuller