Copy formula

[chuck]

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?

 

[KC Rippstein hotmail com>]

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.

 

[Shane Devenshire]

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.