Re: problem selecting rows (or columns)

From: Beau Beau (anonymous_at_discussions.microsoft.com)
Date: 04/27/04


Date: Tue, 27 Apr 2004 09:41:11 -0700

The problem is I don't always know where I want to stop.
As I'm moving the pointer downwards I occasionally stop to review, holding down the mouse button down, I'll stop to review, then continue down.

I don't want to have to pre-decide what I want to select. That would be time consuming
Any other suggestions?
Is this more a mechanical thing, or is the program "remembering" I have moved quickly down in the past?
     
     ----- RagDyer wrote: -----
     
     Couple of thoughts.
     
     Instead of clicking and dragging to create your selected range, try
     selecting the "start" cell, (the top left cell), then click in the name box
     and enter the "end" cell, (the bottom right cell), then hold down <Shift>
     and hit <Enter>.
     You now have your range immediately selected!
     
     Another way is to place the entire range in the name box and then hit
     <Enter>.
     For example, click in the name box and type in:
     A1:Z100
     And simply hit <Enter>
     
     --
     
     HTH,
     
     RD
     ==============================================
     Please keep all correspondence within the Group, so all may benefit!
     ==============================================
     
     "Beau Beau" <anonymous@discussions.microsoft.com> wrote in message
     news:E0402B6C-0289-4F12-990A-D8E03FA7A12C@microsoft.com...
     When working in a large spread*** I often have to highlight a range of
     cells or rows encompassing a few hundred rows.
     When dragging the pointer down to the bottem of the page, the *** usually
     moves down in a normal manner. However, at times it speeds up so quickly I
     can't control where I need to stop. This is NOT the same thing as speeding
     it up a little by dragging the pointer a little lower, this is FAST. I know
     others who have this problem.
     I've gone into Control Panel to adjust speed, doesn't work.
     It seems to happen when I've been working on a *** a long time.