Inserting a picture from file into a cell

  • Thread starter Thread starter The Message
  • Start date Start date
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!!
 
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.
 
Back
Top