Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel Help!!

  • 16-03-2010 3:16pm
    #1
    Goldenlady
    Registered Users, Registered Users 2 Posts: 342 ✭✭


    :):) I need to insert a number of photos in to an excel document -however each time I insert a photo I then have to format it to fit in to the section I require - is there any way of automatically formatting photos prior to copying them in so that they will just fit in the area I click on - or am I asking for too much????:rolleyes:


Comments

  • #2
    Snowbat
    Registered Users, Registered Users 2 Posts: 1,065 ✭✭✭Snowbat


    You could use IrfanView's batch resize on a folder of photos to rescale them all to a suitable fixed size, ready for insertion.

    Do you really want to use a spreadsheet to store photos? :eek:


  • #3
    bette
    Registered Users, Registered Users 2 Posts: 496 ✭✭bette


    Goldenlady wrote: »
    :):) I need to insert a number of photos in to an excel document -however each time I insert a photo I then have to format it to fit in to the section I require - is there any way of automatically formatting photos prior to copying them in so that they will just fit in the area I click on - or am I asking for too much????:rolleyes:

    As the other poster suggested get that program and resize your stuff. There is also another issue here with resizing. If you reduce your photos you will end up with a pretty hefty document. Let's say you have an original 18 x 12 with a file size of 1mb and reduce with it irfanview to fit 9 x 6 your file will become ¼ of the original file size. This is because you reduce in two dimensions. However if you shrink the original in Excel the imported file size remains as the original!


    http://www.irfanview.com/


Advertisement