I have a shared workbook with a top frozen section that has comments by myself and others. The only issue that I have is when I go to edit a comment the comment box appears way below where the cell with the comment is located.

IE.
Cell in top frozen section is C10 and has a comment. When edited the comment box appears in above row 6500.

So how do I get the comment box to show next to the cell when I edit it?

Thanks for the help.