When you copy a 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:
Move the data: Press until the cells appear to lift, then drag the cells to another location in the table. Existing data is replaced by the new data.
Paste and overwrite existing content: Choose Edit > Copy (from the Edit menu at the top of your screen). Select the top-left cell where you want to paste the data, then choose Edit > Paste.
If the data range contains formulas, choose Paste Formula Results.
Paste without overwriting: Choose Edit > Copy (from the Edit menu at the top of your screen), select the destination cells, then choose Insert > Copied Rows or Insert > Copied Columns. New rows or columns are added for the copied cells.
Paste a cell style: Choose Format > Copy Style. Select the cells where you want to copy the style, then choose Format > Paste Style.
Paste cell contents without its style: Choose Edit > Copy, select the cells where you want to paste, then choose Edit > Paste and Match Style. The pasted cells adopt the formatting of the new location.
Paste outside of an existing table: Drag the cells where you want them. A new table is created with the pasted cells.