Excel Question Again: Images

[MikeVic]

Is there any way to have an image take up a cell(s) in Excel? So that when I resize the cell(s), the image is resized too?

[cthomer5000]

yes, but it's a little tricky.

First right click the image and go to "format picture".
Click the "properties" tab
select "move and size with cells"
go back to the spreadsheet.
Now i find it easiest if you resize a cell so that it's more than big enough to fit the picture.
move the image to within the cell
now when you resize the cell a bit smaller (so the image fills it 100%) the image will always be the size of the cell.

the one issue is that excel doesn't seem to recognize the image when you autosize something (by double clicking between cells). You have to manually strectch the column/row that the picture resides in.

If anyone knows of an easier way, please let me know!