Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    London, Middlesex, England
    Thanked 0 Times in 0 Posts

    How to anchor Comment Bubble


    The screen-shot shows how the comment bubble is cut-off the right part of the Excel worksheet.

    I've tried to Edit the Comment & move it to the left.
    Then when I click back in the sheet, it jumps to the Right again.

    How can one ANCHOR the comment bubble in a preferred location?



  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Pittsburgh, Pennsylvania, USA
    Thanked 342 Times in 335 Posts

    Re: How to anchor Comment Bubble

    I can not replicate the problem (though I use xl97, not xl2003)

    If i insert a comment in a cell
    Show the comment
    Move the comment to a position
    Now I can change sheets, change workbooks, close the file, whatever

    When I go back the the sheet the comments are displayed where I put them.

    You didn't indicate this, but I will speculate:
    As far as I know, the placement of the column is only for "shown" comments (then it is a "visible shape"), not "hidden comments" If after you set the size while the comment is shown, and then "hide the comment" the placement is not stored and when you go to the cell the "popup comment" is relative to the cell. The location you set is for the comment "shape", not the comment "popup", to see the "popup comments" you will have to move the window further to the left.


Posting Permissions

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