How do I copy cells and skip lines?
 

I want to copy a relative formula from cell A1 to cells A3, A5, A7,.... A3001.

In previous verisons I could highlight A1..A3000 select copy then go to A3
and select paste, and it would work. It would copy A1 to A3, then A2 to A4,
then A3 to a5, all the way down to a3001. This no longer works. How can I
quickly do this?

I don't understand exactly what you're describing that you did before, but
if you're looking to copy your relative formula to every other row, try
this:

Enter your formula in A1 and A3.
Select A1 to A4.
Click the fill handle of the 4 row selection and drag down to copy as
needed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"con_jon" wrote in message
...
I want to copy a relative formula from cell A1 to cells A3, A5, A7,....
A3001.

In previous verisons I could highlight A1..A3000 select copy then go to A3
and select paste, and it would work. It would copy A1 to A3, then A2 to A4,
then A3 to a5, all the way down to a3001. This no longer works. How can I
quickly do this?