Ask Your Question

How do you move a column without changing the formulas

asked 2020-05-09 22:26:09 +0100 gravatar image

updated 2020-05-12 07:38:27 +0100

ajlittoz gravatar image

How do you move a column without changing the formulas that are in the column. If you copy and pasta the formula changes to the new locations which will not work.

edit retag flag offensive close merge delete


Please change tags! don seems to be your name and has nothing to do with LO.

Apparently, your question is not related to the formula editor Math but to the spreadsheet app Calc. In this case, the correct tag is calc.

ajlittoz gravatar imageajlittoz ( 2020-05-10 08:23:34 +0100 )edit

Question retagged for site consistency. If you disagree, and also to give a more appropriate tag, use the retag link under your question.

ajlittoz gravatar imageajlittoz ( 2020-05-12 07:40:46 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2020-05-11 21:07:13 +0100

Vez gravatar image

You can also use Cut and Paste instead of Copy and Paste.

If you also want to keep the original first Copy and Paste to a temporary space. Then Copy and Paste back from here after the above.

edit flag offensive delete link more

answered 2020-05-09 23:22:23 +0100

Opaque gravatar image


use absolute addressing ($A$1 instead of A1) in your formulas - see LibreOffice Help - Addresses and References, Absolute and Relative

Hope that helps.

If the answer helped to solve your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-05-09 22:26:09 +0100

Seen: 94 times

Last updated: May 11 '20