Hi! I've got the following issue. Sorry for comparison with Excel but I find PlanMaker behaviour unexpected and counterintuitive in this example.

Operation: cut or copy range with formulas. Behaviour in Excel:

- I cut and paste range with formulas if I want to preserve references to the same cells. In effect values in these cells with formulas do not change.

- I copy and paste range with formulas if I want to keep offsets of the formulas' reference cells. In effect values in these cells change.

In PlanMaker both copy and paste keep offsets. How do I move cells with formulas while keeping values and formulas like in Excel?

## Moving range with formulas

### Re: Moving range with formulas

Actually, PlanMaker has some different mechanism of the cut paste of cells but working as expected. In PlanMaker, you can cut/paste a cell on multiple locations. If you want to move the cell with formulas and all references please move the cell with the drag-drop feature.

To move cells:

a) When you have several cells selected you can click into the selection and drag it.

b) When you have only a single cell without selection color then click into the cell and hold the mouse button. After half a second the drag cursor is shown.

When you drag-drop cell to a different location you will find the formula and references will be there.

Thanks

To move cells:

a) When you have several cells selected you can click into the selection and drag it.

b) When you have only a single cell without selection color then click into the cell and hold the mouse button. After half a second the drag cursor is shown.

When you drag-drop cell to a different location you will find the formula and references will be there.

Thanks

### Re: Moving range with formulas

Aha! Can't say that it was obvious but works like charm ! Thanks