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