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.
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.
Data from the clipboard can be pasted while retaining or discarding the original formatting.