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 Expand viewCollapse view
`=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