Ask Your Question

How do I copy than paste a formula to multiple cells without the formula changing.

asked 2017-10-29 17:10:06 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

If I try to copy and paste a formula, the formula changes to match the next row. How do I paste the same simple formula into many cells with out it changing.

example: =IFS(B109=0,Q2,B109=1,Q3,B109=2,Q4,B109=3,R2,B109=4,R3,B109=5,R4)

Each result (i.e. Q2, Q3 Q4 etc.) has a different text that gets placed into the cell depending on the number typed into B109 or B110 or B111 etc.

And, by the way, if I every make it through the tags and the reCaptcha, I will probable never use this site again. It is a waste of time trying to get verified that I am not something from outer space. The thing keeps coming up in a different langue. And the requirements for tags is ridiculous. it is never satisfied.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-10-29 18:35:19 +0200

pierre-yves samyn gravatar image

updated 2017-10-29 18:35:33 +0200


If the question is not about absolute addressing here is how I proceed in this case:

Click in the formula bar, Ctrl+A, Ctrl+C, Esc

That's it just paste, the formula is not changed...


edit flag offensive delete link more

answered 2017-10-29 17:48:26 +0200

m.a.riosv gravatar image

In the help it's explained how to do it.

Addresses and References, Absolute and Relative

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-10-29 17:10:06 +0200

Seen: 3,532 times

Last updated: Oct 29 '17