[Solved] copying formulas

[harfis01]

I am wanting to copy a formula but leave one of the cell references the same.

The specific formula I am working with is....=LCM(C1,A3)/A3.....with the C being the column and A being the row.

I want to copy the formula down a row but leave the column reference the same, and the same for going across.
Here is how I want the spreadsheet to look with the first cell reference (C1, D1, E1, etc) being the columns and the second cell reference (A3, A4, A5, etc) being the rows.

Code: Select all

=LCM(C1,A3)/A3     =LCM(D1,A3)/A3     =LCM(E1,A3)/A3     =LCM(F1,A3)/A3

=LCM(C1,A4)/A4     =LCM(D1,A4)/A4     =LCM(E1,A4)/A4     =LCM(F1,A4)/A4

=LCM(C1,A5)/A5     =LCM(D1,A5)/A5     =LCM(E1,A5)/A5     =LCM(F1,A5)/A5

[FJCC]

To make the references to the row in C1 and the column in A3 absolute, so they don't change, use

Code: Select all

=LCM(C$1, $A3)/$A3

Absolute and mixed references are explained in this tutorial.

[harfis01]

Thank you very much for the reply.

I misunderstood the first instructions I found somewhere else about the absolute cells thinking if I put the $ in front of the cell reference ($D1) it would affect both values, the D and the 1.

I did find the tutorials here and the explanation given there was much better and I was able to figure out how to do what I wanted to do.