Copy down to end of data

[steve]

How do I copy down to end of data without having to drag
all the way down. Sometime My mouse acts up and I have to
keep going up and down and so on...... There should be a
key or something i can hit to go to the bottom of data
only isn't there?

Thanks a bunch
Steve

 

[Andy B]

Hi

If you mean AutoFill (using the plus in the bottom right corner) just
double-click on it to extend to the end of the data in the column to the
left of it.

 

[Peo Sjoblom]

Ctrl + shift & down arrow will take you to the bottom of the data. Don't
know if that is what you wanted though?
Assume you have a formula in A1 and you want to copy down the formula to
A500, type A1:A500 in the name box
and press Ctrl + D

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)