Question

to apply the same formula of a cell to the cells below it drag down the

Answer 1

right click and drag down the mouse

Answer 2

Microsoft Excel renders a remarkably quick approach to copy a formula down a column.

Insert code in the first cell.

Choose the cell with the code, and hang the mouse cursor over a little intersection at the below right-hand edge of the cell, which is designated as the Fill handle. As you perform this, the cursor will shift to a full black cross.

Press and drag the fill handle down the column over the cells where you desire to replicate the code.