How do you copy a formula in a spreadsheet to another cell?

Answer by  Arpit (12)

Apply formula in one of the cell and then either drag the cell or double click on right side bottom corner of the cell, it will copy the formula in remaining cells of the column. Please use "$" before Column Name and Row number to make absolute address e.g. $a$1

Answer by  Hoardy (454)

Click on the cell and a big bold border should appear. There should be a square at the bottom right of the border. Drag this border to the cell you want to copy the formula to.

Answer by  gigo (1706)

I you go on the cell with the formula to copy, you should see the formula in the adress/descriptor line. Now copy the formula out of this line, go to another cell and insert it in the descriptor line of the new cell.

Answer by  jamie11 (604)

To copy a formula, have the formula you want in one cell. Click on the formula, drag or select the formula, and select copy. Place copied formula in text where you want it and select paste. The formula needs to be the same fields you want to be compiled, so check to be sure that is what you want.