Zend certified PHP/Magento developer

How do you copy and paste formulas exactly as is in Excel?

I have a large number of formulas I need to copy and paste without changing cell references, but excel keeps changing it.
I also want to do it without replacing the = sign in the formula. There are multiple = signs in the formula and in other places in the worksheet that I do not want to risk screwing up.
You cannot tell me that excel has been out for this long and there is no simple way to copy and paste formulas without changing the reference.