Inserting a picture from file into a cell

T

The Message

What I need to do is to insert various pictures into cells going down coloumn
A with corresponding data going across the page for the associated picture. I
need to firstly

a) Ensure the picture fits the cell exactly and acts as a cell rather than
just a pasted picture over the top of the cell. At the moment I am having to
manually resize the picture and it doesn't appear to be embedded as a cell.

b) Ensure when I create a list, the pictures for the associated rows of
information are trsanferred along with the basic data. Currently I am getting
a message saying 'fixed object will be moved'. when I try this, which is
resulting in the pictures not corresponding to the correct data.

Hope someone can help me!!
 
K

KC Rippstein hotmail com>

This is tricky and may not be the right answer, but what I would do is:
- under the picture's properties check the box to Move and Size with Cell
- in the cell itself, after resizing the picture to the desired height and
width, I would use the appropriate number of forced line returns (using
Alt+Enter in the formula bar) to modify the row's height rather than the row
height property

That is all so tedious and manual a process, but I sincerely believe it
should work just fine.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top