Make formula an absolute reference by typing a
dollar sign ($) before each part of the reference.
For example, $A$1 always refers to cell A1.
You can add a $ before the column letter and
the row number.
Copy and paste formula. The formula is the same, but it uses the new
cells in its calculation.
No comments:
Post a Comment