Copy Cell or Column without advancing formula reference?

[Guest]

I have a spreadsheet with formulas referring to another worksheet. I need to
copy the columns however, each time I do, the formulas advance to another
cell. Which is an incorrect reference, skewing my results.

 

[Guest]

You need to modify the formulas to use absolute references. Edit each of the
cell addresses in the formula and put $ (dollar signs) in front of the column
letters.