Need Help in MS Office Excel [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
I want to multiply cells A1to A190 to cells B1 to B190 and put the results of each row in the next column in (cells D1 to D190) and then copy and paste the results from cells D1 to D190 to cells G1 to G190 and keep the results there,
However when I then delete and number or values from any of the cells A1 to A190 orB1 to B190 the results gets deleted too, how do I delete the numbers in the rows a1 to a 190 so that the results does not get deleted please


2 replies

I want to multiply cells A1to A190 to cells B1 to B190 and put the results of each row in the next column in (cells D1 to D190) and then copy and paste the results from cells D1 to D190 to cells G1 to G190 and keep the results there,
However when I then delete and number or values from any of the cells A1 to A190 orB1 to B190 the results gets deleted too, how do I delete the numbers in the rows a1 to a 190 so that the results does not get deleted please
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
763
Because of formula. If you have to delete the cell, then only thing you can do is once the formula is there, then use copy and paste special as value to remove the formula and just have calculated values

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!