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.
|