When you use past special | values, and try to paste a large bunch of data
with merged cells into another sheet, it will not let you paste just the
values. This requires un-merging the cells. The problem that I have with
this, is that the error message makes NO sense. It says "This operation
requires the merged cells to be identically sized". Well, guess what? They
are!!! I just copied them in from another worksheet. I even used paste
special | column widths to ensure that the were indeed the same size. I
don't understand what the big deal is anyway? If Excel can paste formulas
into merged cells, why not values? I think that this should be fixed.
Thanks!

FYI, I am a highly advanced user of excel and the obvious workaround is to
unmerged the cells, paste and remerge them. It is just a pain in the butt
and like I said, if you can paste formulas using merged cells, why not
values? It makes no sense!

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc