copy & paste formulas while referring to same cells

[Guest]

I'm trying to copy a group of calculations (say A1 to A10) to another
location in the same workbook (say D11 to D20) while having the cells
referred to by the calculations stay the same.

For ex., I want the calculation 'B1+C1' in cell 'A1' to still refer to 'B1'
& 'C1' when it is moved to 'D11' (usually the calc would refer to cells 'B11'
& 'C11'). Can I do this without having to use $'X'$'#' ?. Is there a
keyboard shortcut?

Thanks

 

[Dave Peterson]

I don't know of a keyboard shortcut to do the copy, but you could change the
relative address to absolute address by hitting the F4 key.

I like to change my formulas to text:
select the range
edit|replace
what: = (equal sign)
with: $$$$$
replace all

Then copy|paste those text strings.

Then change the $$$$$ back to = signs (in both spots)