Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Picture Sizing
Afternoon All, Can someone please tell me how to insert a picture and have it fill the size of the cell I'm inserting into? Currently when I insert a picture it pretty much fills the screen. Apologies if this is a stupid question :) -- Cheeky Monkey ------------------------------------------------------------------------ Cheeky Monkey's Profile: http://www.excelforum.com/member.php...o&userid=24243 View this thread: http://www.excelforum.com/showthread...hreadid=378511 |
#2
|
|||
|
|||
Hi
Try this code originally from Tom Ogilvy. Replace cell B9 with the cell you want to use. Range("B9").MergeArea.Select Set pic = ActiveSheet.Pictures.Insert("C:\Pictures\Sample.jp g") pic.Height = Range("B9").MergeArea.Height pic.Width = Range("B9").MergeArea.Width HTH Ken |
#3
|
|||
|
|||
First off reduce the size of your pictures. :-)
Then when you have pasted it in, click on it such that the resizing handles appear, then holding down the ALT key, drag it into the cell in question and then resize it to fit. The ALT key will allow you to fit it to the exact cell dimensions very easily - Try it and you'll see what I mean. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Cheeky Monkey" wrote in message news:Cheeky.Monkey.1qkg2j_1118667918.5293@excelfor um-nospam.com... Afternoon All, Can someone please tell me how to insert a picture and have it fill the size of the cell I'm inserting into? Currently when I insert a picture it pretty much fills the screen. Apologies if this is a stupid question :) -- Cheeky Monkey ------------------------------------------------------------------------ Cheeky Monkey's Profile: http://www.excelforum.com/member.php...o&userid=24243 View this thread: http://www.excelforum.com/showthread...hreadid=378511 |
#4
|
|||
|
|||
I would recommend backing up all your original photos to a cdr or cdrw first
as they are. Once you resize them, you lose the quality of the image if you try to make them bigger again later.You can also save them in a compressed jpg format to keep the image size the same but save some disk space. You will still suffer some image quality loss however. Remember, once you lose the original image, you can't get it back, so I never work with my originals. Always with a copy of the original..Then you can always start over if something goes terribly wrong. Ken |
#5
|
|||
|
|||
Amen to that :-)
Backup Backup Backup!!!!!! -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Ken Macksey" wrote in message ... I would recommend backing up all your original photos to a cdr or cdrw first as they are. Once you resize them, you lose the quality of the image if you try to make them bigger again later.You can also save them in a compressed jpg format to keep the image size the same but save some disk space. You will still suffer some image quality loss however. Remember, once you lose the original image, you can't get it back, so I never work with my originals. Always with a copy of the original..Then you can always start over if something goes terribly wrong. Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
how do i change excel into picture format | New Users to Excel | |||
Excel range truncates when Pasted as Picture to PPT & Word | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
insert picture into excel | Excel Worksheet Functions |