Thread: Excel Formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe User[_2_] Joe User[_2_] is offline
external usenet poster
 
Posts: 905
Default 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.