View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default skip every other row when copying formula

Type formula in the first cell and nothing in the cell below.
Select these two cells; use copy
Move to Third cell and select to end of range; use Paste
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"RHD3" wrote in message
...
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.