pictures

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

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

Pictures

resolvedResolved · 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.


 

Excel tip:

Colouring cells containing formulas

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

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips


Server loaded in 0.09 secs.