inserted comments

[MMG]

I have a an Excel file witha large amount of comments,
1000 in 200 rows. When you scroll they tend to remain
open. If you right click on a cell and select display
comment it is not displyed next to the cell, it is
displayed off the screen. How can I fix this problem? Any
help would be appreciated.

MMG

 

[David McRitchie]

Not sure if you are asking about one problem or several problems.

Debra Dalgleish has a (macro) solution for getting the comments back
toward the cell.
Reset Comments to Original Position
http://www.contextures.com/xlcomments03.html#Reset

Cell comments can be shown all at once or hidden all at once with or without
only their cell comment triangle showing in Tools, options, view.
Comments: _ None, x Comment indicator only, _ Comment & indicator

In addition individual Cell comments can be shown or hidden by right-clicking on the cell with a cell comment and choosing Hide or
Show Comment. Cell comments that are shown can be reformatted and can be moved. Hiding and unhiding columns may drastically affect
position of a cell comment, but you can move it around by double-click on the cell comment outline.

More information on Cell Comments in
http://www.mvps.org/dmcritchie/excel/ccomment.htm

If not familiar with installing and using a macro see my getstarted.htm page.