+ Reply to Thread
Results 1 to 3 of 3

How to reduce file size (lots of pictures pasted into workbook)

  1. #1
    Forum Contributor michellepace's Avatar
    Join Date
    10-28-2015
    Location
    South Africa
    MS-Off Ver
    2013
    Posts
    128

    Question How to reduce file size (lots of pictures pasted into workbook)

    Hi there,

    I have an excel spreadsheet where I have pasted in several screenshots. The pictures themselves are really small. If I use Windows Explorer and add up the size of all the pics I have, I think it may be 5MB tops. But when I paste these pictures into my excel workbook, it becomes very large... currently 14MB. I've tried various actions (after googling about it) to reduce the file size but so far nothing has made a difference at all. \

    Is anyone able to significantly reduce the file size of this workbook and tell me how you did it?

    www.michellepace.com/Excel_work/CJ_MARKETS.xlsx

    Thanks in advance,
    Michelle

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,912

    Re: How to reduce file size (lots of pictures pasted into workbook)

    Best pratice is using by "Paint"
    > Your screenshot photo >open with paint >
    Click on "Image" tab > select stretch and skew
    In horizontal & vertical reduce size 100% to 50% or 40% & save it in folder.
    Go to Edit tab > select all > CTRL "C"
    Go to excel file > Paste.
    Secondly, my opinion is, why not using powerpoint.
    Last edited by avk; 12-01-2016 at 10:33 AM. Reason: correction


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Forum Contributor michellepace's Avatar
    Join Date
    10-28-2015
    Location
    South Africa
    MS-Off Ver
    2013
    Posts
    128

    Re: How to reduce file size (lots of pictures pasted into workbook)

    Thanks AVK, I tried what you suggest with all my pictures. The file size is not reduced.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Can Any one tell me that, How can I reduce my file size.....
    By rajeshn_in in forum Excel General
    Replies: 4
    Last Post: 11-10-2016, 11:34 PM
  2. [SOLVED] select all pictures pasted in a workbook
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2016, 05:59 PM
  3. Compress Comment Pictures to reduce file size in document
    By jholiday78 in forum Excel General
    Replies: 0
    Last Post: 09-19-2014, 03:32 PM
  4. Replies: 1
    Last Post: 12-17-2013, 03:18 PM
  5. Replies: 8
    Last Post: 11-28-2012, 02:33 AM
  6. How to reduce File Size
    By santoshsapre in forum Excel General
    Replies: 3
    Last Post: 06-25-2012, 09:06 AM
  7. Reduce workbook size
    By captbluefin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-24-2007, 10:48 AM

Tags for this Thread

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