Excel 2003 Comments

[Ann Knoff]

Is it possible to insert an image into an excel comment? If so, how?

Thanks!

Ann

 

[Norman Jones]

Hi Ann,

See Debra Dalgleish at;

http://www.contextures.com/xlcomments02.html#Picture

 

[Ron Coderre]

Go to this link on Debra Dalgleish's website and follow the instructions:
http://www.contextures.com/xlcomments02.html#Picture

Does that help?

***********
Regards,
Ron

 

[Ann Knoff]

You guys are great - thanks!!
Ann

Hi Ann,

See Debra Dalgleish at;

http://www.contextures.com/xlcomments02.html#Picture

 

[Si]

Hi Ron & Norman
I'm glad I'm not the only one who wants to do this but unfortunately i can't
use the link as it appears to be disconnected can you please give me the run
down of how to do this

thanks Si

 

[Debra Dalgleish]

The link is working fine:

http://www.contextures.com/xlcomments02.html#Picture

and there's a video here:

http://www.contextures.com/xlVideos01.html#CommentPicture

Here's what the page says:

Add a Picture to a Comment

1. Right-click the cell which contains the comment.
2. Choose Show/Hide Comments, and clear any text from the comment.
3. Click on the border of the comment, to select it.
4. Choose Format|Comment
5. On the Colors and Lines tab, click the drop-down arrow for Color.
6. Click Fill Effects
7. On the picture tab, click Select Picture
8. Locate and select the picture
9. To keep the picture in proportion, add a check mark to Lock Picture
Aspect Ratio
10. Click Insert, click OK, click OK