Comments and connectors

G

Guest

In Excel 2003 I can get the comments in like I want and it puts a little red
triangle in the upper right corner. I can then drap the comment to where I
want it but once I print it out it is really hard to see the connector line
connecting the comment to the cell. I tried right clicking the comment and
going to the colors and lines tab but the connector and arrow part is greyed
out. I am assuming Excel doesn't see this as an actual line. All I can do is
change the color of it not the size. What I want to know is if there is a way
to inlarge the line? Right now I am just drawing my own connector over that
one with AutoShapes and then I can increae the size of the line. When I say
increae the size I mean the weight of the connector. Thanks.
 
D

Debra Dalgleish

You could experiment with different autoshapes:

Display the comments
Click on the comment border, to select it (the border highlighting
should look dotted, not striped)
From the drawing toolbar, choose Draw>Change AutoShape>Callouts
Select one of the first three callouts

You can drag the yellow diamond, to position it over the red triangle
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top