Hi,

Two ways at least

1. Put your cursor in the cell below the formula (empty cell, directly
below) and press Ctrl+' (control apostrophy) then cut and paste the result
anywhere.
2. Highlight the formula on the Formula Bar and click Copy. Press Enter or
Esc once, move to the destination cell and paste.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"chuck" wrote:

how can i copy a formula from one row to another with out changing the
refrences and with out using absolute refrences "$" eg. In row 2 i have
=average(B200:B300) I want to copy the exact formula into row 20 with out
having to change the formula in row 2 to =average(B$200:B$300) is this
possible?