Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

pictures

ResolvedVersion 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.

Excel tip:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.