The formulae are entered into the top cell of each column which is row 4.
The first formula is =F4. This is entered into the top cell as shown in your image then after entering, the cell is selected (clicked on) and the little square in the lower right of the selected cell is grabbed by the mouse cursor (left button held down) and then the cursor is dragged down the column. This will fill each cell with the formula being incremented to be correct for the cell that it is in because of the RELATIVE references of the formula (no $ in front of the column letter or row number).
Another way of filling the formula down the column is to enter the formula in the top cell as above then click on that cell to select it and while holding down the left button drag the mouse down as far as required to select all the cells that you want the formula in. Then with the cells selected, hold down the Ctrl key and hit the D. This will fill the selection with the formula.
Repeat for all the columns with formulae.
Bookmarks