How can I copy and paste a formula changing only the cell references made on the active sheet and leave references to ranges on another sheet as is?

1 Answer 1


Can you share what you've tried so far? Screenshots/formula would be helpful.

Here is my attempt to answer your question based on the available information:

=A2+'Copy of Sheet1'!$D$2

Add $ to reference what you want to keep. $ will retain either column, row, or both.

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.