Copy Cell or Column without advancing formula reference?

S

sgluntz

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.
 
D

Duke Carey

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.
 
Top