Copy down to end of data

  • Thread starter Thread starter steve
  • Start date Start date
S

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
 
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.
 
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)
 
Back
Top