pictures
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pictures

Pictures

resolvedResolved · Medium Priority · Version 2010

replyReply Fri 9 Sep 2011, 12:57Delegate Joanne said...

Joanne has attended:
Excel Intermediate course

Pictures

How can I embed a picture so it is part of a spreadsheet and not overlaping the data?

For upcoming training course dates see: Pricing & availability

replyReply Tue 13 Sep 2011, 12:38Trainer Andrew said...

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.

 

Please browse our web site to find out more about
advanced excel class and other Microsoft training courses.

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard