Paste the last cut or copied data

You can paste previously copied or cut data from the clipboard. If a range of cells, rows or columns was copied or cut, the data will take the same size range when inserted.

warning

Inserting data into non-empty cells or ranges deletes the previous data without warning. To retain existing data, use shift cell insertion. Exception: for ranges with filtered cells, shift insertion is not available.

When pasting into a range containing hidden or filtered cells, only visible cells will be overwritten. You cannot paste into such a range:

• A range with merged cells.
• A range containing an entire pivot table.
• Ranges containing an entire table.
• Array formulas.

Data from the clipboard can be pasted while retaining or discarding the original formatting.