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?

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?

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?