Let’s understand how we could paste excel formula in alternate rows.

We see multiple scenarios in which we have to drag the formula with a cell gap between them.

We will see how we can achieve the below goal by pasting formula in alternate cell.

Suppose we have a difference column which calculates the difference of the cell value and the value just below the cell with the formula in B2 is **=A3-A2.**

**Step 1**

Enter the formula **=IF(MOD(ROW(),2),A2-A1,””)** in the cell B2 and copy paste the formula in the entire range as shown below.

We could leverage this technique to manipulate every nth row by replacing 2 in the MOD formula with n.

Hope this helped.