Cannot use formula in other cells. I am trying to copy a formula moving down a c

Question

Cannot use formula in other cells.

I am trying to copy a formula moving down a column in Exceel with the formula maintaining the same sequence properties as the first two in the column. Exampple of first formula in the column, =A1+A1, example of the second formula in the column, =A2+A1, eexample of the third formula in the column, =A3+A1, etc.

When I highlightt the first three rows of the noted formulas in the same column and attempt to copy/drag to rows continuing down the spreadsheet the formula nomenclature is not preserved. Instead, in row four the formula would read, =A4+A4 instead of what I would have expected on the PC version of Excel, =A4+A1.

There certainly must be an easy fix, because no one would continue to type the formula nomenclature down multiple rows of a large spreadsheet.

Any solutions would be very helpfful.

Thanks

Explanation / Answer

Hi,,

Excel for mac is not soomething I have ever used but see no reaeson why it shouldn't be the same as other versions of Excel, try this and drag down

=A1+$A$1

Note the $ signs lock the reference and make it absoluete

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.