delete formulas but retain answer

[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

 

[Claus Busch]

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

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


Regards
Claus Busch

 

[SS]

Am Sun, 11 Jul 2010 13:23:22 +0100 schrieb SS:


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

Thanks I will do that.

 

[SS]

Thanks I will do that.

Worked a treat, thank you.

 

[Stan Brown]

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 in F8. Edit » Copy. Then Edit » Paste Special » Values.