+ Reply to Thread
Results 1 to 5 of 5

Resizing Multiple Images

  1. #1
    Registered User
    Join Date
    05-29-2007
    Posts
    4

    Resizing Multiple Images

    This should be easy be somehow the hour is either late or my brain isn't working...

    I have a very simple 'data-entry' style spreadsheet. No calculations, macros or conditionals. Figures are added manually. The spreadsheet also incorporates images that have been pasted into cells (no links back to original files). My problem is that several users have imported images without resizing or compressing them. As a result the file is HUGE. No surprise there.

    The spreadsheet is duplicated - so that the workbook contains 10 Sheets (each sheet is set out identically).

    What I'd like to do is select all the images in the the workbook and compress and resize them - while at the same time enlarging their respective cells.

    Any help gratefully received.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    If you are using Excel 2007, there's a compress pictures option on the picture format command bar.
    Martin

  3. #3
    Registered User
    Join Date
    05-29-2007
    Posts
    4
    Apologies for not mentioning this: I'm using Excel 2003. Compressing isn't really my problem.

    When I double click an image I get a dialog box that allow me to choose a "COMPRESS" but with an option to compress all images in the doc. It is really the resize and the auto-fit which is stumping me.

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Dri,

    It would help to see the spreadsheet to better understand what your formatting requirements are. Can you post a copy for review?

    Sincerely,
    Leith Ross

  5. #5
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    This macro will resize cells which contain the top left hand corner of pictures in a sheet to the size of the picture.

    Please Login or Register  to view this content.
    This assumes that there are not pictures in the sheet which might share the same row or column and be a different size.

    The (54.29 / 288) fudge factor was necessary for my display. Yours might be different.

+ 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