How can I autofill a formula in Numbers, but keep some referenced values the same?
Solution 1:
Click on the up arrow to the right of the cell reference (at the bottom of your screenshot) for the one you want to fix, then check the Row and Column boxes to fix the reference to both the row and column.