Excel Formulas
 

Is there a quick way to copy a formula down thousands of rows?

Excel Formulas
 

Just Ctrl-C in the cell where the formula is then highlight the range to
which you wish to paste the formula then Ctrl-V to paste it.

If my comments have helped please hit Yes.

Thanks.



"Diane" wrote:

Is there a quick way to copy a formula down thousands of rows?

Excel Formulas
 

"Diane" wrote:
Is there a quick way to copy a formula down
thousands of rows?

First, copy the formula (select the first cell or row, and press ctrl+C).

Then enter the remaining range into the Name Box, and press ctrl+V.

This presumes that you have used relative and absolute cell references in
the formula as intended. Be sure to review the result.