Copy, move or delete cell content in Numbers on Mac
Copy or move cell content
When you copy a cell or move a cell’s data to a new location in the table, 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: After selecting the cells, click and hold the cells until they appear to rise off the table, then drag them 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 (or select an area of the same dimensions as the cells you’re pasting), then choose Edit > Paste.
If your data range contains formulas but you want to paste only the results, select Paste Formula Results.
Paste without overwriting: Choose Edit > Copy, select the destination cells, then choose Insert > Copied Rows or Insert > Copied Columns (from the Insert menu at the top of your screen). New rows or columns are added for the copied cells.
Paste a cell style: Choose Format > Copy Style (from the Format menu at the top of your screen), select the cells where you want to paste the style, then choose Format > Paste Style.
Paste cell contents without the 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 to create a new table: Drag the cells outside the table. A new table is created with the pasted cells.
If you copy a range of cells that include hidden data (either hidden or filtered), the hidden data is also copied. If you paste to a range of cells with a matching arrangement of hidden cells, the hidden data is also pasted. Otherwise, the hidden content isn’t pasted.
Clear content from cells
Select the range of cells you want to clear.
Do one of the following:
Remove the content but preserve the cells’ data format, text style and cell style: Press Delete.
Remove all data, formatting and styles: Select Edit > Clear All (from the Edit menu at the top of your screen).
Tip: If a cell contains text and an object, you can only delete the object without deleting the text.