Front Office Football Central

Front Office Football Central (https://forums.operationsports.com/fofc//index.php)
-   FOFC Archive (https://forums.operationsports.com/fofc//forumdisplay.php?f=27)
-   -   Excel Question Again: Images (https://forums.operationsports.com/fofc//showthread.php?t=21456)

MikeVic 02-11-2004 11:46 AM

Excel Question Again: Images
 
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 02-11-2004 11:50 AM

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!


All times are GMT -5. The time now is 09:33 PM.

Powered by vBulletin Version 3.6.0
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.