Excel Excelsheet problem

B

bocabyth

Joined
Mar 7, 2009
Messages
1
Reaction score
0
Is there any possibility to cut the link between the dependent cells and a result, meens, can I keep the result of an operation somewhere and contnue to use the dependent cells for new calculations?
 
Hi,

When you copy the calculated result to some other cell , right click and use "paste special" option, then select option "Values ". This should copy the values or result into different cell, and you can continue recalculating with new data.

Hope this addressed your query

rgrds
Manohar.
 
Hello,

What is more, one can write a macros to copy only value of a cell. You can assign a keyboard letter to the macros or create a visual button to start the macros by mouse.

All the best,
Chereda
 
Back
Top