From a posr by Ron Rosenfeld
Start Ron post*********************
You can control the speed of your copy based on how far down the screen you
drag the mouse. Drag it so it's just touching the top part of a Worksheet
tab and it copies slowly but steadily. Drag it down to the bottom of the
Worksheet tab and it copies faster. Drag it as low as the Status Bar (or any
toolbar positioned between the Status Bar and the Worksheet Tabs) and it
copies faster still. Drag it below the Status Bar and it races down the
screen.
The same goes for copying across columns. The farther to the right you drag
your mouse the faster it copies. It can be tricky at first but I always drag
to the Worksheet Tab/Vertical Scroll Bar, then slowly move down/right until
I reach the speed I'm comfortable with.
One additional technique:
1. Select all of the cells first, by clicking the first cell, then using the
scroll bar locate the last cell and shift-click it (Norm mentioned this)
2. Once they're all selected, including the first cell containing the data
you want to copy, click the Formula Bar (white line above the sheet)
This switches Excel to the Edit mode and thinks you want to change the
first cell (which we're not going to do).
3. Press Ctrl+Enter on the keyboard
This copies the first cell to the other highlighted cells.
Note: If you're trying to copy multiple cells of data down multiple columns,
this technique will not work as desired. It always copies the first cell in
the selected area down AND to the right.
--
_______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com
End Ron post******************************
Gord Dibben Excel MVP
