automatically fit a picture on each cell of a column in MS-excel 2007

[shyra_grace]

hello i have a problem creating an automation like automatically fitting a picture on each cell of a columns without any re-sizing the picture in windows excel 2007. Is anybody have ideas on it?

[JAMES_911]

At first the picture is entered on the spreadsheet make sure it fits in the cell that you want it to be in. The entire size of the picture has to fit into that cell. Once you have that done, right click on the picture, and select format picture. Under the properties tab, select move and size with cells. Click ok. Now it should stay in the row you want. You can also refer to some suggestions given in similar kind of threads here - How to insert pictures into Excel automatically ?