Ask Your Question

How to move a range including formulas?

asked 2015-12-22 09:17:09 +0100

qwerty gravatar image

updated 2016-03-11 23:44:20 +0100

Alex Kemp gravatar image

I just upgraded to LibreOffice and noticed that it works slightly different than the old version when moving a range of cells. I noticed the same behaviour in both Linux and Windows versions.

Lets say that I enter 1 in B2, =B2+1 in B3, and copy the formula in B3 to B4:B9. In other words the range B2:B9 will contain the numbers one through eight. If I move the entire column or the range B2:B9 everything works as expected, but if move the range B6:B9 to e.g. C6:C9 the formulas will remain unchanged. The range C6:C9 will contain numbers 5, 1, 1, and 1 instead of 5, 6, 7, and 8 what I would have expected.

To get the expected behaviour I have to move first B6 to C6 whereafter I can move the range B7:B9 to C7:C9. The extra step increases the risk of errors and is annoying. How can I move the entire range in one step without messing up the formulas?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-12-23 10:13:07 +0100

pierre-yves samyn gravatar image

updated 2015-12-23 10:20:05 +0100


  • Select B6:B9
  • Right clickInsertShift cells rightOk

Of course this will also shift the cells that are to the right ...


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-12-22 09:17:09 +0100

Seen: 84 times

Last updated: Dec 23 '15