You could give B200:B300 a range name.

Or instead of copying the cell, go into the cell by hitting F2, highlight
all of the formula, copy it, escape out of edit mode, go to the new cell, hit
F2, Ctrl+V to paste the formula in, then Enter.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"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?