T trip_to_tokyo Feb 11, 2010 #2 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.
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.
J Joe User Feb 11, 2010 #3 Diane said: Is there a quick way to copy a formula down thousands of rows? Click to expand... 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.
Diane said: Is there a quick way to copy a formula down thousands of rows? Click to expand... 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.
