I use Excel on a daily basis. One of the biggest gripes I have is that when
I'm dragging a forumula from one row to another is that I almost invariably
over-shoot where I want to go. I then have to drag the forumula back up, and
often end back up at the top of the document. I end up wasting a few seconds
going back and forth getting it adjusted.

My suggestion is to implement an adjustable scroll stop. The user could
click at on a row, activate the scroll stop either with a mouse click or from
a menu selection, and Excel would recognize that row as the end of the
document and prevent scrolling beyond that point.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

I totally agree with the problem, this gets me every now and then too and
drives me nuts. I had another solution though. I would like to control the
speed better. Right now it sometimes feels that if I just move my cursor 1
pixel the speed goes from 5 lines per second to a hundred.

My solution might sound a bit counter intuitive but I think it would feel
natural almost immediately. When dragging, e.g. down, the moment the cursor
goes outside the worksheet you don't drag further down but left or right.
Since there is more space either left or right there is more room to control
the speed. When you dip back into the worksheet the scrolling stops.

The downside to this is that selecting a block that is both very high AND
wide takes twice as long now because you have to do the scrolling part twice
e.g. first vertical and then horizontal. But I think that dragging is far
more performed on just one or a few rows or columns, at least in my work.



"Dr. Nonverbal" wrote:

I use Excel on a daily basis. One of the biggest gripes I have is that when
I'm dragging a forumula from one row to another is that I almost invariably
over-shoot where I want to go. I then have to drag the forumula back up, and
often end back up at the top of the document. I end up wasting a few seconds
going back and forth getting it adjusted.

My suggestion is to implement an adjustable scroll stop. The user could
click at on a row, activate the scroll stop either with a mouse click or from
a menu selection, and Excel would recognize that row as the end of the
document and prevent scrolling beyond that point.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

Hi Dr,
The little window at the top left of your Worksheet where the cell
address is.
If you click your mouse there and put in the new cell address you want
to go to,
then press Enter. (IE: A63) You will jump to that cell.

If you have a formula you want to copy (drag) down. With your curser in
the cell where your
formula is, "copy" it. Then click in the little window and put in the
range you want (IE A4:A63),
press enter. That range will highlight. then "paste" and you have
filled the range with your formula.

Dave
Dr. Nonverbal Wrote:
I use Excel on a daily basis. One of the biggest gripes I have is that
when
I'm dragging a forumula from one row to another is that I almost
invariably
over-shoot where I want to go. I then have to drag the forumula back
up, and
often end back up at the top of the document. I end up wasting a few
seconds
going back and forth getting it adjusted.

My suggestion is to implement an adjustable scroll stop. The user
could
click at on a row, activate the scroll stop either with a mouse click
or from
a menu selection, and Excel would recognize that row as the end of the
document and prevent scrolling beyond that point.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://tinyurl.com/a7kts


--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=438884