|  

» Adding Data, Charts, or Other Information to a Cell Comment

Want to see a photo, Chart, Financial Ratios report or sales information inside a cell Comment?

To add a picture to a cell Comment:

1. Select a cell, press Shift+F2 to add a new Comment; if a Comment is in the cell, and press Shift+F2 to edit the Comment.
2. Select the edge of the Comment so that it is surrounded by dots, not slashes.
3. Right-click the Comment edge, and from Format Comment, select Colors and Lines.
4. In the Fill section, open the Color box.
5. Choose Fill Effects, click the Picture tab, and then click Select Picture.
6. Select a picture and click OK twice.
Screenshot // Adding Data, Charts, or Other Information to a Cell Comment
Adding Data, Charts, or Other Information to a Cell Comment

Rate This Tip
12 34 5
Rating: 4.32     Views: 32388
Engineer/Estimator
kent@psfindustries.com  Posted on: 31-12-1969
I added a picture to a comment. Now the comment stays exploded and will not shrink to hidden comment. Anybody know what gives? Thanks, Kent.
kent@psfindustries
Monique  Posted on: 31-12-1969
Go back to cell, right click and select hide comment
Software Developer
René Kevelaerts  Posted on: 31-12-1969
I added a picture to the comment in cell C6, then clicked on another cell to close the comment. Allthough the view-comment works fine when I pass the cursor over cell C6, editing the comment does not. When I right-click again on cell C6 and choose edit comment, I get only the comment-text, not the picture. To see the picture I need to left- or right-click on the frame of the comment. I'd liked to see the pictue immediately when I edit the comment. Who can help me out of this?
window split; freeze panes
brett  Posted on: 31-12-1969
It seems in XL 2000 that if you put a picture in a comment of a header cell, using window=>split; freeze panes so that the header is always visible when you scroll, then the picture is also split. If you scroll all the way up to the top of the sheet, the picture appears normally.
Default Comment format
iii  Posted on: 31-12-1969
Is it possible to change default comment format (i.e. font, size etc.)?
Changing_the_Default_Comment_Format_in_Microsoft_Excel
Joseph Rubin, CPA  Posted on: 31-12-1969
read tip:
http://www.exceltip.com/st/Changing_the_Default_Comment_Format_in_Microsoft_Excel/187.html
Picture in Comments
Henry  Posted on: 31-12-1969
this is outrageous really great thing
Pictures in Comments
Alan  Posted on: 31-12-1969
Be aware that this can rapidly make your workbook file size very large indeed!

May not matter to you as a developer when working off your hard disk, but if the workbook is then on a network it might be a different issue.

Alan.
Name
Comment Title
Comments