Copy/paste without moving cell reference

[nicolehalliday]

Hi,
I have a column of values that are returned by a formula, which is derived by referencing a few cells in my spreadsheet. I want to copy the entire column of values and paste it into an adjacent column. However, when I do this the cells that are referenced in the formula shift one column over. I can't do find/replace because each row is a different number, and it doesn't work if I try to replace the column letter with another letter. Does anyone have any suggestions? Thanks!

 

[JamesW]

Hi there,

Put the range reference in dollar signs ($), like this:

=$A$3+$A$2

The $ before the column means don't change column when copied, and the $ next to the row means don't change row # when copied.

So copying =$A3+$A4 will not change A, but will change 3 and 4 when copied downwards.

 

[nicolehalliday]

That's exactly what I need, thank you! Is there a way to add the $ signs to the formula's without manually going through each cell? I have about 500 cells with formulas that reference 3 different cells so that might take me a while...

 

[JamesW]

This may be of use to you:

http://www.mrexcel.com/forum/showthread.php?t=27670