Can copy but not paste

[lukerees83]

I am trying to copy the results of a set of sheets into a new workbook.

When I so this for the first group of cells (about 8 rows by 5 columns) it works fine, then below it I want paste a set of cells exactly the same size. When I try this it says "The information cannot be pasted because the Copy area and the paste area are not the same size and shape". (Excel Mac 2011)

But they are the same size and shape, as the formatting has all been taken from the same source. How can I make it stop giving this error and just paste the stuff in I want anyway? Even if it auto-reformats the cells to fit stuff in.

All I want to do is paste special and put in the values on their own anyway, so it shouldn't make any difference.

Any thoughts?

 

[jmthompson]

Try pasting into just the first cell of your destination area.

Is your source data filtered or do you have any hidden cells? Any merged cells?

 

[lukerees83]

I've check for those three things, I think I have sorted it out now.

Many thanks.

Out of interest, what effect does merged cells have on such actions. It seems merged cells can cause all manner of problems.