When you copy a table cell, or move a cell’s data to a new location in the table, all of the cell’s properties are also copied or moved, including its data format, fill, border, and comments.
Select the cells you want to copy or move.
Do one of the following:
Paste and overwrite existing content: Tap Copy, select the top-left cell where you want to paste the data, then tap Paste.
If your data contains formulas, tap Paste Formulas or Paste Value Only. The data overwrites any existing data.
Paste outside of an existing table to create a new table: Tap near the edge of the screen, then tap Paste. A new table is created with the pasted cells.
Move the data: After selecting the cells, touch and hold the selection until the cells appear to rise off the table, then drag them to another location in the table. Any existing data is replaced by the new data.