We all know how to copy the values and formulas in Excel, but sometimes we need either copy value as result of formula or same formula without moving references and ranges. Let’s look how to do that.
To copy a value not a formula we need copy cell and then use Paste Special and select Values:
To copy the formula without moving references we can copy formula not through the cell but in Formula Bar.
Then insert it into another cell. The formula will be refer to the same cells and ranges without any fixing of rows and columns inside.
But such approach doesn’t work if we want to copy many formulas. In such case we can use one trick.
So:
.