Add a Picture to an Excel Comment
Add a bit of interest to a worksheet, by changing the comment shape from a rectangle.
- Right-click the cell which contains the comment.
- Choose Show/Hide Comments, and clear any text from the comment.
- Click on the border of the comment, to select it.
- Choose Format|Comment
- On the Colors and Lines tab, click the drop-down arrow for Color.
- Click Fill Effects
- On the picture tab, click Select Picture
- Locate and select the picture
- To keep the picture in proportion, add a check mark to Lock Picture Aspect Ratio
- Click Insert, click OK, click OK
Change the Comment Shape
For MS-Office 2000/XP/2003 only.
- Right-click the cell which contains the comment.
- Choose Edit Comment
- Click on the border of the comment, to select it.
- On the Drawing toolbar, click the Draw button
- Choose Change AutoShape, and choose a category.
- Click on a shape to select it.
- When finished, click outside the comment.
For MS-Office 2007/2010.
In Excel 2007, the Drawing Tools Format tab doesn’t appear on the Ribbon when you select a comment, so the Change Shape command isn’t available. It’s still possible to change the comment’s shape, but it takes a bit more effort.
You can add the Change Shape command to the Quick Access Toolbar (QAT):
- Right-click the QAT, and click Customize Quick Access Toolbar
- In the Choose commands from drop down list, click Drawing Tools | Format Tab
- In the list of commands, click Change Shape, and click Add.
No comments:
Post a Comment
Your feedback is always appreciated. I will try to reply to your queries as soon as time allows.Please don't spam,spam comments will be deleted upon reviews.