View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Naveen Naveen is offline
external usenet poster
 
Posts: 100
Default skip every other row when copying formula

I think you want ...

A B
1 =A1
2
3 =A2
4
5 =A4

if that is the problem,
You just copy B3, and paste it to remaining cells in B
That's it.

*** Please do rate ***


"RHD3" wrote:

I would like to be able to skip every other row when copying a formula. If I
have data in column A for example, and I want to use a simple formula in
column B like "=a1"(in cell b1) and "=a2"(in cell b3) and "=a3"(in cell b5)
and so on. I have tried using the drag and fill but I end up missing cells.