I'm having a little bit of a problem and was wondering if your expert knowledge could help me out. Formula in question:


Now the issue is I want to apply this formula to each row, allowing it to work out the cost of shipping a product. However I only want it to change certain parts of the formula, while keeping other cells intact. This is because some of the cells use data that is needed to solve the equation and if it shifts the cells down it screws the entire thing up. If you have any idea on how to solve this please let me know, I would really appreciate it.

1 Answer 1


Prepend the column letter and/or row number that you don't want to change with $.

Let me illustrate:

Let's say in cell B2 I have this formula


If I copy that to C2, what is pasted in C2 is


But that's not what I want. I always want to multiply against A1. If, instead, B2 was


Then when I copied to C2 I'd get


If I pasted into Z99 I'd get


This includes using auto-fill.

If you only want one of the coordinates to stay "static", just put the $ before it. Like


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.