ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Inserting a picture from file into a cell (https://www.excelbanter.com/excel-discussion-misc-queries/237403-inserting-picture-file-into-cell.html)

The Message

Inserting a picture from file into a cell
 
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!!

KC Rippstein hotmail com>

Inserting a picture from file into a cell
 
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.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"The Message" wrote:

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!!



All times are GMT +1. The time now is 05:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com