ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   inserted comment not displays in the cell it displays on top row (https://www.excelbanter.com/excel-worksheet-functions/243361-inserted-comment-not-displays-cell-displays-top-row.html)

S.Kumar

inserted comment not displays in the cell it displays on top row
 
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

inserted comment not displays in the cell it displays on top row
 
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

On Tue, 22 Sep 2009 04:30:01 -0700, S.Kumar
wrote:

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




All times are GMT +1. The time now is 04:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com