merging cells and comments
 

Two questions according merging 2 cells together; 1 with contents and
comments, 1 empty cell.
When I merge 2 cells (vertically) together of witch the bottom cell contains
the data and comments, why does the comments disappear and the content stays?
I want to keep them both.
And secondly, when I unmerge the same two cells (with comments and
contents), why does the top cell contains always these data after unmerging,
and not the bottom cell?
How do I solve these problems?

thanks,
roland, belgium

merging cells and comments
 

Hi Roland,

Only the top left cell of a Merged area can contain data or comments. When
you merge you will lose everything in the other cells. There's no way round
this, other than to check manually or programatically what you might want to
keep in the "other" cells, and if necessary move elsewhere before merging.

Regards,
Peter T

"Roland" wrote in message
...
Two questions according merging 2 cells together; 1 with contents and
comments, 1 empty cell.
When I merge 2 cells (vertically) together of witch the bottom cell
contains
the data and comments, why does the comments disappear and the content
stays?
I want to keep them both.
And secondly, when I unmerge the same two cells (with comments and
contents), why does the top cell contains always these data after
unmerging,
and not the bottom cell?
How do I solve these problems?

thanks,
roland, belgium