Extend formula row reference across columns

  • Thread starter Thread starter Joe M.
  • Start date Start date
J

Joe M.

I would like to drag to extend the row reference across columns. See below
example. Can this be done?

Col A B C D
E.....
=sheet2!D1 =sheet2!D2 =sheet2!D3 =sheet2!D4


Thanks,
Joe M.
 
Back
Top