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?
--
Ant

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!

--------------------
(Ms-Exl-Learner)
--------------------


"Ant" wrote:

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?
--
Ant

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 A1right clickCopyselect cell C1right clickPaste

It might be easier to just link to cell A1:

C1: =A1

--
Biff
Microsoft Excel MVP


"Ant" wrote in message
...
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?
--
Ant

Copy from the formula bar, and paste.
--
David Biddulph

Ant wrote:
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?