How to copy a formula down a column. Select cell c3 and click on it. Drag the formula down to the other cells in the column by clicking and dragging the little icon at the bottom right of the cell. As you do this the cursor will change to a thick black cross.
Hold and drag the fill handle down the column over the cells where you want to copy the formula. Copying the vlookup function to the entire column. Double click the left mouse button while on the fill handle.
Select all the cells to which you wish to copy the formula. Either press control c or click the copy button on the home ribbon. To copy the formula down a column we need to follow these steps.
Option 2 will stop inserting formulas when.