Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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!! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inserting a Picture using Cell as picture name. | Links and Linking in Excel | |||
Big Excel file after inserting picture | Excel Discussion (Misc queries) | |||
Inserting Picture From File | Excel Discussion (Misc queries) | |||
Inserting picture into excel based on # in the another cell | Excel Worksheet Functions | |||
inserting a picture into a cell | Excel Discussion (Misc queries) |