How to move columns from one sheet to another retaining links and formulae?

asked 2016-05-15 21:40:10 +0100

How to move columns from one sheet to another retaining links and formulae?

Is this possible? I'm a beginner and made a very complicated sheet, which I want to split into 3. I'd nee to preserve links to other sheets, and other columns in the same sheet, and all the formulas.

I've tried cut and paste, but libre office crashes, so guessing it isnt that method.

Click+alt+drag does nothing also. (linux).

Regards

edit retag flag offensive close merge delete