Show All
Copying and moving cells
To copy and insert rows or columns
- Select the rows or columns you want to copy.
- Press Ctrl+C.
- Place the insertion point in another row or column.
- Press Ctrl+V.
- If you are copying rows, click Insert above or Insert below, depending on where you want to insert the copied rows. If you are copying columns, click Insert left or Insert right, depending on where you want to insert the copied columns.
- Click OK.
To copy the contents of a block of cells to another block of cells
- Select the block of cells whose contents you want to copy. (The selection must be a rectangular block of cells.)
- Press Ctrl+C.
- Place the insertion point in the first cell of the destination block.
- Press Ctrl+V.
- Click Paste contents only and then click OK.
When pasting the contents of a block of cells to another block of cells, the target block must have at least as many rows and columns as the source block.
To move rows or columns
- Select the rows or columns you want to move.
- Do one of the following:
- Drag the rows or columns on top of another row or column.
- Press Ctrl+X, place the insertion point in another row or column, and then press Ctrl+V.
- If you are moving rows, click Insert above or Insert below, depending on where you want to insert the rows you are moving. If you are moving columns, click Insert left or Insert right, depending on where you want to insert the columns you are moving.
- Click OK.
To copy or move a block of cells into another cell as a child table
- Select the block of cells you want to copy. (The selection must be a rectangular block of cells.)
- Do one of the following:
- To copy the cells, press Ctrl+C.
- To move the cells, press Ctrl+X.
- Place the insertion point in another cell.
- Press Ctrl+V.
- Click Insert as a child table and then click OK.
To create a new table by copying cells from an existing table
- Select the block of cells you want to copy. (The selection must be a rectangular block of cells.)
- Press Ctrl+C.
- Place the insertion point outside the table.
- Press Ctrl+V.