A clever way to copy excel formulas to different cells without having their references changed. The basic idea is to replace the "=" with some other character so it is no longer a formula. Then, you copy the formula to a new cell. Finally, you replace the other character with "=" again.
Go here for the specifics: http://www.extendoffice.com/documents/excel/598-excel-copy-without-changing-formulas.html