98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Pictures
Pictures
Resolved · Medium Priority · Version 2010
Joanne has attended:
Excel Intermediate course
PowerPoint Introduction course
Pictures
How can I embed a picture so it is part of a spreadsheet and not overlaping the data?
RE: Pictures
Hi Joanne,
Thank you for your question. Give the following a try and let me know if this gets close to the effect you are looking for.
You might want to test it out in a blank workbook first so you can see the result and decide how you might add it to your list.
First right-click on a cell and choose to add a comment:
Right click again and choose to edit your comment.
Delete out the name that Excel added into the comment
Now right click on one of the edges of the comment box
From the menu that appears choose Format comment
Click on the Colors and Lines tab
Choose Fill Effects
Click select picture and browse to an image you would like to display for this cell (you may wish to tick the "lock aspect ratio" box so the image doesn't distort when you later resize it)
Click OK and click outside your cell. Now when you hover over the cell with the comment the image appears.
To keep the image on display all the time go to the Review ribbon and click the "Show all comments" button.
Resize and drag the comment/image as needed.
You should find that sorting and filtering of rows will keep the comment/images in line with their respective rows
I hope this help - let me know how this works out for you.
Kind regards,
Andrew
Mon 19 Sep 2011: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Colouring cells containing formulasCells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells. |