+ Reply to Thread
Results 1 to 5 of 5

Excel Picture Sizing

  1. #1
    Registered User
    Join Date
    06-13-2005
    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

  2. #2
    Ken Macksey
    Guest

    Re: Excel Picture Sizing

    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.jpg")
    pic.Height = Range("B9").MergeArea.Height
    pic.Width = Range("B9").MergeArea.Width


    HTH

    Ken



  3. #3
    Ken Wright
    Guest

    Re: Excel Picture Sizing

    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" <Cheeky.Monkey.1qkg2j_1118667918.5293@excelforum-nospam.com>
    wrote in message
    news:Cheeky.Monkey.1qkg2j_1118667918.5293@excelforum-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. #4
    Ken Macksey
    Guest

    Re: Excel Picture Sizing

    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. #5
    Ken Wright
    Guest

    Re: Excel Picture Sizing

    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" <KenMacksey@tnt21.com> wrote in message
    news:ur%23oUMGcFHA.2212@TK2MSFTNGP14.phx.gbl...
    > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1