» Adding Data, Charts, or Other Information to a Cell Comment
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
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.
Book Store:
Recommended Books:
- The Interpretation of Financial Statements
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Excel Charts
- Special Edition Using Microsoft Outlook 2002
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 commentSoftware 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.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
