Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2005
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    mergecells and comments (1)

    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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: mergecells and comments (1)

    When merging, Excel keeps the contents and comment of the top cell; those of the bottom cell are lost. When unmerging, the contents and comment are placed in the top cell; the bottom cell will be blank. Why? Just a design decision, I think.

    Not much you can do about it. I fear you will have to live with it, unless you want to create your own macros to merge and unmerge.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •