I have a formula in Excel that needs to be run on several rows of a column based on the numbers in that row divided by one constant. When I copy that formula and apply it to every cell in the range, all of the cell numbers increment with the row, including the constant. So:
If I copy cell C4 and paste it down column C, the formula becomes
when what I need it to be is
Is there a simple way to prevent the expression from incrementing?