You certainly know that when you copy cell/range that contains no absolute formulas (no $ sign), the result of the formula must be different because the formula will automatically change. But how if we want to copy the formula to other cell with the same result without having to change the formula, although the cell reference is not made absolute? With the Copy and Paste Exact Formulas feature you can do it easily. The result will be identically same.
The picture is as follows:
Yellow shaded cells are the cells that has formulas. If you copy the range A3:C7 and pasting at A9, then the result will be zero. This is because the formula reference at row 2 turns to 8. By using this feature the result will be as follows:
Steps:
- Select range A3:C7 and click OK
- Seelct range that will be pasted, ex: A9:C13 and click OK
0 komentar