Results 1 to 8 of 8

Thread: Photos

  1. #1
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Can someone explain to me how the photos were placed into this spreadsheet?
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    They appear to be PDF documents; they were inserted by selecting Insert | Object...

  3. #3
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks--Next question:
    Where are the pictures, and how do you make the small box/icon that you double click on to expand the picture?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The files are stored in the workbook itself.

    When you select Insert | Object..., you first choose whether you want to insert a new object, or use an existing file, by activating the corresponding tab in the dialog. If you choose Create from File, you can click Browse... to select the file to be used.
    When you have selected the file, you decide how it is inserted - there are check boxes "Link to file" and "Display as icon".
    If you tick "Link to file", the file isn't actually stored inside the workbook, only a link to the file. This keeps the workbook size down, but will cause problems if you send the workbook to someone else, or if you move the source file to another folder or drive.
    If you tick "Display as icon", Excel will display an icon instead of the contents of the file; the icon is chosen by Excel but you can click a button to select another icon.

  5. #5
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the tutoring, I have a better understanding now. The worksheets I'm working on will need to be emailed as the example I sent was also emailed.

    I guess converting them to pdf reduces the file size.

    Appreciate it very much.

  6. #6
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    [quote name='stans' post='791277' date='29-Aug-2009 14:25']Thanks for the tutoring, I have a better understanding now. The worksheets I'm working on will need to be emailed as the example I sent was also emailed.

    I guess converting them to pdf reduces the file size.

    Appreciate it very much.[/quote]

    An alternative approach (which has been mentioned here I believe) is to include the photograph as a cell 'comment'.

    On the cell, right click and select Insert Comment.
    Right click on the margin of the comment and select Format Comment
    Select the Colors and Lines tab, and on the Color dropdown select the Fill Effects item .
    This then gives a Picture tab which allows you to select the appropriate picture. Personally, I always Lock the picture aspect ratio, and generally, you'll want to resize the comment block to show the full picture.

    To view the pictures, the user just has to mouse over the cell.

    A friend has done this to illustrate a spreadsheet of British fungi - the attached is just to show how it can work
    Attached Files Attached Files

  7. #7
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='Gfamily' date='31-Aug-2009 04:22' post='791428']
    An alternative approach (which has been mentioned here I believe) is to include the photograph as a cell 'comment'.

    Thanks, I recall reading about that a while back.

  8. #8
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I like the file size also.
    You have several pictures here.
    Small file--thanks again

Posting Permissions

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