View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default copy a formula over two rows but increase the row # by 1 only

Dave,

Copy it to row 'b' then drag the copy from 'b' to 'c'

HTH,
Bernie
MS Excel MVP


"Dave" wrote in message
...
How do you copy a formula from one cell in row "a" to row "c", but only
increase the row reference to "b" automatically?