![]() |
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!! |
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