delete formulas but retain answer

  • Thread starter Thread starter SS
  • Start date Start date
S

SS

I have used this formula SUM($E$3*E8) to give answer in cell F8

It is part of a contract document which I have to return to them
In cells e3 to e8 are my rates and other info used to arrive at a total.

Now I only want to return this document with the column that is now in F8
minus E3 to E8

If I delete E3 to E8 I lose the total that is in F8 (cause I will have
deleted the formulas)

Is there a way to retain the info in F8 but delete columns E3 to E8


thanks
 
Am Sun, 11 Jul 2010 13:23:22 +0100 schrieb SS:
Is there a way to retain the info in F8 but delete columns E3 to E8
Click to expand...

F8 copy => F8 Edit => Paste special => Paste values


Regards
Claus Busch
 
I have used this formula SUM($E$3*E8) to give answer in cell F8

It is part of a contract document which I have to return to them
In cells e3 to e8 are my rates and other info used to arrive at a total.

Now I only want to return this document with the column that is now in F8
minus E3 to E8

If I delete E3 to E8 I lose the total that is in F8 (cause I will have
deleted the formulas)

Is there a way to retain the info in F8 but delete columns E3 to E8
Click to expand...


Click in F8. Edit » Copy. Then Edit » Paste Special » Values.
 
Back
Top