Copy formulas

  • Thread starter Thread starter Ant
  • Start date Start date
A

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?
 
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!
 
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
 
Back
Top