Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default 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!!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 168
Default 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!!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting a Picture using Cell as picture name. the-jackal Links and Linking in Excel 12 November 10th 08 09:21 AM
Big Excel file after inserting picture Sandro Excel Discussion (Misc queries) 0 October 28th 08 05:30 PM
Inserting Picture From File Mike Goodson Excel Discussion (Misc queries) 3 October 1st 07 05:52 PM
Inserting picture into excel based on # in the another cell jstaggs Excel Worksheet Functions 2 December 14th 06 06:55 PM
inserting a picture into a cell Rosa B. Excel Discussion (Misc queries) 1 December 7th 05 09:42 PM


All times are GMT +1. The time now is 06:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"