microsoft office excel

There are many ways to copy a formula down a column in Excel, but by far the quickest is to simply double-click on the AutoFill Handle.  To do this:

  1. Select the cell containing the formula you want to copy.
  2. Hover the mouse cursor over the AutoFill Handle.

The AutoFill HandleHover the mouse cursor over the bottom right-hand corner of the selected cell.

  1. Double-click on the AutoFill Handle to copy the formula down.

Copied formula

Excel will stop copying on the row before the next blank cell in the adjacent column.

4. This is another method below to copy a formula

Just copy cell in which you have a formula, and than select all the cell in which you want the same formula to be applied. Excel will automatically recalculate rows & columns.