If we combine both the cases (for movements in x & y), the final value would be '=B$1*$A2', means, for first value, use 1st row keeping column as variable based on your cell and for second value, use column A as fixed, but change the row based on your cell. Means, for the second value, we want to change the row based on the row of the formula cell, but we want to keep the column fixed as A. Now, when we copy this to B3, the final value should be '=B1*A3'. This would ensure that row remains 1 for each cell, but column keeps changing. Means, for first value, we want to change the column keeping row as 1. However, when we copy this to C2, we want to make the value as '=C1*A2'. In this we would start with the value for B2 as '=B1*A2'.
