Dave F wrote...
Interesting. I try to do everything witht he keyboard and avoid the mouse.
But I can see how this would be easier to people used to using the mouse.....
....

If copying A1:A9000 to B1:B9000,

[Ctrl]+[Home]
[Shift]+[Ctrl]+[Down]
[Ctrl]+C
[right]
[Ctrl]+V

If copying B1 down into A1:A9000 with A1:A9000 filled in but B2:B9000
blank and B1 the active cell,

[Ctrl]+C
[Shift]+[left]
[Tab]
[Shift]+[Ctrl]+[Down]
[Tab]
[Shift]+[right]
[Ctrl]+V

or

[Ctrl]+C
[F5]B2:B9000[Enter]
[Ctrl]+V

Latter is quicker when you know the rows, but former is more general.