All operating systems that PlanMaker supports have an extremely useful feature: the clipboard.
The clipboard works as follows: You select something in the worksheet and then cut or copy the selected content to the clipboard. You can then reinsert the selected content elsewhere in the worksheet. The clipboard thus facilitates the deletion, copying and moving of cells (as well as objects).
All necessary commands can be found on the ribbon tab Home | group Edit:
Command |
|
Explanation |
Cut |
|
The ribbon command Home | Cut deletes the content of a selection – but not permanently. This content is moved to the clipboard, where it remains available for subsequent insertion anywhere. |
Copy |
|
The ribbon command Home | Copy copies the content of the selection to the clipboard. |
Paste* |
|
To paste the contents of the clipboard, use the Home | Paste command. Place the marker at the desired position and then choose this command (click directly on the icon itself). You can also insert the content of the clipboard multiple times in this manner. |
Paste special |
|
If you click on the small arrow below the icon rather than directly on it at Home | Paste, a dropdown menu opens with additional options for pasting the content. For more information, see Paste special. |
* How to paste from the clipboard without overwriting the existing values of the active cell, see chapter Inserting copied cells.
These works in the same manner for objects such as pictures, charts and drawings.
Pasting into a selected cell range
When you copy cells to the clipboard and select a range of cells before inserting them with the ribbon command Home | Paste, the pasted cells will be fit into the selection.
This is shown as follows:
▪If the selected cell range is smaller than the cell range to be pasted, all cells which do not fit are omitted.
▪If the selection is larger than the cell range to be pasted, the cells are repeated until the selected range is completely filled.
▪There's one exception:
| If the selected cell range consists of just one row, PlanMaker will still paste all columns of the source cells. |
| The same applies when the selected cell range contains only one column. |
Moving and copying using the mouse ("Drag and Drop")
Android/iOS: This function is not available in the Android and iOS version.
To move or copy cells using the mouse: Select the cells, drag them to a different place and drop them there. With this technique, known as drag and drop, you can move or copy cell contents very quickly.
To do so, proceed as follows:
| 1. | Select the desired cells. |
| 2. | Press the left mouse button on the selected cells and wait about one second until a small dashed rectangle appears at the mouse cursor. |
| 3. | While still holding the mouse button down, drag the selected cells to the desired position. |
| 4. | When you release the mouse button, the cells will be moved to the new position. |
| If you hold down the Ctrl key down while releasing the mouse button, the cells will instead be copied to the new position. |
| If you hold down the Alt key down while releasing the mouse button, a dialog box appears where you can choose if you want the cells to be copied or moved. When you choose "Copy", you can also specify if just the cell contents should be copied or also their formattings. |
Moving and copying formulas containing relative coordinates
If you copy cells that contain formulas, the cell addresses in the formulas are automatically updated to the new place in the worksheet.
An example:
Suppose you have a formula in cell A7 that adds up the values from the four cells above:
=SUM(A3:A6)
Now you copy this formula to position B7. PlanMaker will automatically update the formula so that it will work again with the four cells above the total row. Cell B7 will therefore contain the following formula:
=SUM(B3:B6)
If you do not want this to happen, use absolute cell addressing instead of the usual relative cell addressing (see Relative versus absolute cell references).