inserted comment not displays in the cell it displays on top row

[S.Kumar]

if i insert a comment in cell number D1110 the comment is not displaying near
that cell number, it displays in top of the row means row number 1, please
help to rectify it

 

[Gord Dibben]

Does this happen with any new Comment you insert in any cell?

I can't explain that but you can reset to the proper position.

See Debra's site for a macro.

http://www.contextures.on.ca/xlcomments03.html#Reset


Gord Dibben MS Excel MVP