Copy formulas

[Ant]

I want to copy a cell formula by means of another formula. For example:
A1=A2+A3. I want C1 to show that same formula. How do i do this?

 

[Ms-Exl-Learner]

Method 1:-
Place tha cursor in A1 cell and press F2 and press shift+Home key now the
whole formula will be getting selected now press cntrl+c for copying the
formula. Now place the cursor in C1 cell and press cntrl+v to paste the
formula.

Method 2:-
The second method is if you have protected the A1 cell formula with the
dollar symbol like the below

A1 cell formula
=$A$2+$A$3

you need not to press F2 for copying the formula, just place the cursor in
A1 cell and press cntrl+c to copy the formula and place the cursor in C1 cell
and press cntrl+v to paste it. The cell reference of the formula will not be
getting changed, since it is protected with the dollar symbol.

Remember to Click Yes, if this post helps!

 

[T. Valko]

If you want to *copy* the formula then you have to make the column
references in the original formula absolute:

A1: =$A2+$A3

Then, select cell A1>right click>Copy>select cell C1>right click>Paste

It might be easier to just link to cell A1:

C1: =A1