save sum of 2 number after deleting them

tesoke · #1 12-16-2015, 02:01 PM

Hi, I need help for a simple problem about Excel. Please help like always. Bless you.

I had a simple Excel file, like the attached picture, which have 2 numbers. Cell B4 calculates sum of them. I want to save the value of B4 in B6 and then delete B2, B3 and B4. So, I copy B4 in B6; but after deleting B2, B3 and B4, the value of B6 is deleting too. Is there another method, except copy/past or writing the value of B4 in B6 by hand, to save the value of B6 even deleting the values of B2, B3 and B4?

Thanks for any help.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to create a table with a number of line depending a number entered by user	Cellendhyll	Word Tables	3	07-10-2014 05:49 AM
Deleting a script in an equation without deleting the whole term	allankey	Word	1	02-15-2014 07:09 AM
When I try to save an existing word doc, save as pops up and will not save...	samanthab	Word	3	01-19-2013 06:27 AM
excel 2010 not deleting tmp files on save/close	willbaker13	Excel	0	04-26-2012 05:08 PM
Files deleting on save	email_Signup123	Excel	0	04-29-2007 04:42 AM