Cutting and Pasting Cell Values

You can cut and paste cells to paste the values while deleting them from the source cells.

Cut and paste by selecting source cells and pressing Ctrl + X or Cmd + X , then selecting target cells and pressing Ctrl + V or Cmd + V .

In most cases, the cell that you cut will become unbooked when you paste the value. There are a few exceptions, though:

  • If the value of the source cell cannot be deleted, it will only be copied. You'll see a message in this case. See Deleting Values in a Table for a list of restrictions.

  • If you cut a group of cells and paste to an overlapping group of cells, new values are pasted to the overlapping cells.

  • If you cut a cell and paste it to a cell that aggregates up to the source cell, the source cell keeps its original value. For example, you can cut from 2020 and paste to December 2020. In this case, 2020 keeps the same value but only December is booked.

Otherwise, cutting and pasting cells works like copying and pasting them. For example:

  • Where possible, you'll paste underlying records by default.

  • You can cut multiple cells.

  • You can cut and paste across different tables, or between custom cells and cells with model data.

  • You can undo the operation to get the previous values back. If you cut and paste across versions, you can undo the change separately for each version.

For more details, see Copying and Pasting Cell Values.