 # How to copy the formula by row and not by column

• I want to link the sums from one sheet to another.

In the first sheet the sums are in the rows. I want to link them so when i copy my formulas through columns in the first sheet it refers to the rows in second sheet.

I've been trying this on cell L6, ='sheet2'!T31
Now i want cell M6 to be ='sheet2'!T32. But when i copy, it becomes U31.

I see the logic in why my formula dosent work, but i dont know how to fix it.

• Re: How to copy the formula by row and not by column

=offset(sheet2!\$T\$31,column()-12,0) should do the trick.

• Re: How to copy the formula by row and not by column

Thank you very much, work perfect!
could you explain what "column()" means?

• Re: How to copy the formula by row and not by column

The column function returns the column number that the reference cell is in, or the cell the formula is in if no reference is supplied. So if you put =column() in A1, you'll get 1, and if you put it into Z2 you'll get 26.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!