Excel Comments - positioning

[Paul T]

Hi

I have inserted a comment (near bottom of page view) dragged it up page to
can see it.

But when Mouseover half of the comments box is not viewable.(defaults next
to cell near bottom of view)

When I select show - it appears where I moved it! Great... apart from it
don't want it on show all the time.

I prefer the mouse over version - how do I get it to display the comments
where I moved when I mouseover it.


Cheers

Paul T

 

[David McRitchie]

Hi Paul,
You have no control over where the comment box will appear,
usually it works out okay. If the comment boxes are larger
than they need to be you can resize them with FitComments macro.
http://www.mvps.org/dmcritchie/excel/ccomment.htm#resizing
You can reset the comments to their original position
http://www.contextures.com/xlcomments03.html#Reset
Neither of which is going to provide you with control of where
comments appear. If you can think of a way for a comment
to appear where you want it regardless of column width changes
and scrolling you can submit your ideas to Microsoft wish list.