Excel Comment will not “disappear”.

Topic

New Reply

I have a Comment in one cell and I wanted to Copy the contents to a Comment in another cell.  The problem is that now the first cell will not self-hide, even after clicking on the <Exit…> on the affected Note.  The second one to which the first note material was copied behaves properly.  How do I get the first note to self-hide?

Ron M

Reply | Quote

Replies

What version of Excel are you using?

Reply | Quote

I can’t replicate the problem in 2013 (an .xlsx file). But have you tried right clicking the offending cell, and clicking Show/Hide Comments?

Reply | Quote

PKCano, I am using Excel for Office 365.

Ron M

Reply | Quote

Kirsty wrote:

I can’t replicate the problem in 2013 (an .xlsx file). But have you tried right clicking the offending cell, and clicking Show/Hide Comments?

Yes, I have tried that and, for some reason, it does not seem to work.

Ron M

Reply | Quote

Well, I do not know what changed, but when I opened the spreadsheet tonight, the comment box was where it was supposed to be – “self-hidden”.   I don’t know what the problem was and I don’t know why closing the spreadsheet and reopening it a later time resolved the problem.  Some things in life will remain a mystery, at least to me. 😎

Ron M

1 user thanked author for this post.

Elly

Reply | Quote

Hi Ron

Just curious whether that comment-cell that was giving you grief was perhaps in the header-rows of a worksheet where you had used Excel’s freeze-panes???

In my experience, whenever copying cells to/from such areas I always ‘turn off’ the freeze-panes settings first. Then afterwards, turn the required freeze-panes settings back on.

This tends to avoid the visual ‘glitches’ that can happen.

If you are using cell comments in column-headings , for example to ‘describe’ the purpose of that column in more detail, then maybe you could use the data-validation-message-box for this purpose, as I often do. Just saying.

zeddy

Reply | Quote

zeddy, the Comment cell was not in a Header row, but thanks for the insight.

 

Ron M

Reply | Quote