problem selecting rows (or columns)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When working in a large spreadsheet 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 sheet 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 sheet a long time.
 
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!
==============================================

When working in a large spreadsheet 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 sheet 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 sheet a long time.
 
Back
Top