Copying and Pasting Cell in Plan

In the Plan table, you can use keyboard shortcuts to copy and paste the contents of one or more cells, rows or columns. For example, you can copy the value of the measure of a formula without copying the formula or copy only the formula.

Note: If you double-click a cell so that it is open for editing before pasting, the contents of the multiple cells are pasted into it.

You can copy and paste cell contents between Plans and third-party applications, such as Microsoft Excel, Google Sheets, SmartSheets, and Microsoft Project.

To copy and paste the content of a single cell or multiple cells:

  1. In the Plan Lines, select the value of the measure cell to copy and press Ctrl + C.
  2. Select the destination of the measure cell where you want to paste the value and press Ctrl + V.
  3. When you paste the copied cell, the dependencies in the cell will be updated to match the new location.

    For example, if you copy a cell with a calculation that sums a column and paste it in a different location. The dependencies that match the original cell will be updated to match the new location.

  4. [Optional] Select the Absolute References checkbox to copy a cell with absolute dependencies and paste it in a new location. If you set filters in 2019, period 001, they will be created as normal. If you select the Absolutes checkbox, a dollar ($) sign will be added before the value of the dimension, and it will freeze or block the value. Click Apply for the filters to be evaluated in the same way as if they had no dollar sign. The main difference is that copying and pasting the cell will retain the same filters and period (i.e., 001, 2019). If you mark the year without the dollar sign, copy and save it, it will update because of how copy and paste. But, if you select it for another year, it will only update if it's absolute. It affects every filter and cannot be supported for specific filters only. If you deselect the checkbox, it will not affect any of the filters. You can select and set your filters and check the absolute whenever you want.
  5. Click Save.