Suppose I would like to do something like this.

Instead of calculating interest by hand, of course we should use formula to do that.

We can put=A2*B2/100,=A2*B3/100 and=A2*B4/100 toC2,C3 andC4 respectively. But it is troublesome to prepare different formulas for each row.

Instead, we can use$ to lock both column index and row index forA2, so when we "paste" the formula, Excel will update the row index ofB for us.

We put=$A$2*B2/100 toC2 and copyC2.

When we paste the copiedC2 toC3, we will get=$A$2*B3/100 without additional modification.

But still, we need to keep pasting the formula to other cells. We can simply drag the small dot at the right bottom corner of the cell to the cells you want it to copy to.