I have a series of formulas I want to copy and paste. The problem is that everytime I copy and paste the formula (even using 'paste special') it changes it, I want it to remain the same!

For example if you had the formula B2 + C2 and you pasted it in the row below it would change it to B3 + C3. How do I tell excel to not try and be helpful and not do this (without having to copy everyline of text) and keep the formula as B2 + C2?

Thanks,

Dave