Previous Topic Next Topic

Need Help in MS Office Excel

Closed
Sammi - Apr 26, 2010 at 10:24 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 26, 2010 at 10:37 AM
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


Related:

2 responses

Answer 1 / 2
Sammi
Apr 26, 2010 at 10:25 AM
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
0
Answer 2 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 26, 2010 at 10:37 AM
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
0