Comments Display

[Scientific]

Hello all,

I have a worksheet with several columns all of which fit into the immediate
window without having to scroll left or right. In the far right column I
inserted a comment but when I scroll over the comment it appears out of view,
I have to scroll right to read it.

Is there anyway to force a comment to appear in a certain area on the
screen, or just within view of the immediate window so I don't have to scroll
to read it? Thanks in advance.

-S

 

[Shane Devenshire]

Hi,

Comments always display to the right of the cell they are in. So you will
need to add the comment to a cell further to the left.

If this helps, please click the Yes button,

Cheers,
Shane Devenshire

 

[DILipandey]

Hi Scientific,

Use following command:-
After inserting Comment, come out. Now again, right click on the cell and
choose "Show Comment" and then drag that comment section to the location
where ever you want.

Hope this helps..!!
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India

 

[Bob Umlas]

But when you hover the mouse again, it's still to the right, not where you
dragged it.
Bob Umlas

 

[RagDyeR]

Debra Dalgleish has some code on her website to fix this :

http://www.contextures.com/xlcomments03.html#Centre

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Hello all,

I have a worksheet with several columns all of which fit into the immediate
window without having to scroll left or right. In the far right column I
inserted a comment but when I scroll over the comment it appears out of
view,
I have to scroll right to read it.

Is there anyway to force a comment to appear in a certain area on the
screen, or just within view of the immediate window so I don't have to
scroll
to read it? Thanks in advance.

-S