problem selecting rows (or columns)

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.
 
R

RagDyer

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top