Results 1 to 14 of 14
  1. #1
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: how to send photo to background

    In XL97, does Format, Sheet, Background, (etc.) do what you want?
    -John ... I float in liquid gardens
    UTC -7ąDS

  2. #2
    Star Lounger
    Join Date
    Mar 2001
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to send photo to background

    It works if I open a new sheet. However if it's a sheet where I've already formatted the cell color, then the pic still doesn't show.

  3. #3
    Star Lounger
    Join Date
    Mar 2001
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    how to send photo to background

    <P ID="edit"><FONT SIZE=-1>Edited by gwhitfield on 01/04/25 03:19.</FONT></P>I've inserted a jpeg onto a spreadsheet? I want to send it behind the text in the cells. order>send backward doesn't seem to work.

    *** Geoff W. Moved from General Office Solutions ***

  4. #4
    3 Star Lounger siflaar's Avatar
    Join Date
    Jan 2001
    Location
    Amersfoort, Netherlands
    Posts
    203
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: how to send photo to background

    So, if you set the cell color to None, then picture should be visable?
    Greetings,

    Patrick Schouten
    (The Netherlands)

  5. #5
    KTYorke
    Guest

    Re: how to send photo to background

    This is old stuff... but the only thread that was relevant to what I was looking for...
    I wanted to set a "For Internal Use Only" watermark and was able to do it using Format>Sheet>Background. Then I sent the .bmp over to a co-worker who already had an excel file and wanted to apply the same watermark.
    We went to Format>Sheet and found that the Background option was grayed out. We opened a new file and was able to choose Background....
    Any idea why the background option became unavailable when the sheet was already populated?
    have fun

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: how to send photo to background

    Hi KT,
    Is the sheet protected by any chance? That would gray out the background option.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to send photo to background

    KT, not answering your question, sorry. But a bmp can add a lot of needless space to a spreadsheet- a gif or jpg can cut out a lot of that bloat.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  8. #8
    KTYorke
    Guest

    Re: how to send photo to background

    I did try that... my original was a gif... (I'm big on cutting size) it worked on my machine, but on hers, no dice, even on a new document... When I converted it to a bmp it worked... <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> it's all very strange.
    I don't work in excel often... well, ever... I was just playing around for her. Thanks for looking out though. <img src=/S/wink.gif border=0 alt=wink width=15 height=15>
    have fun

  9. #9
    KTYorke
    Guest

    Re: how to send photo to background

    I asked about the sheet being protected and she said no. I still can't figure out why the gif wouldn't work either... could that be connected? She was able to get what she wanted by opening a new sheet, putting the background on and copying the information from the other sheet to the new one. She's happy, but I'm still a little confused as to why it all happened like that.
    Thanks!!
    have fun

  10. #10
    KTYorke
    Guest

    Re: how to send photo to background

    OK, she's sent me the spreadsheet so I can play with it. <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15> I'm looking through the "Using MS Excel '97" book too... let's see who tackles this next question first.

    Once I had the spreadsheet on my machine I was able to take off the bmp and switch it with the gif and I can see it on the screen... but I don't see either in print preview... and it won't print. The whole point of putting the watermark on is so it will print out with the watermark there. <img src=/S/sigh.gif border=0 alt=sigh width=15 height=15>
    any ideas? I haven't seen anything that would protect the sheet... any suggestions as to where I should look?
    thanks
    have fun

  11. #11
    KTYorke
    Guest

    Re: how to send photo to background

    I feel so defeated... <img src=/S/surrender.gif border=0 alt=surrender width=31 height=23>
    We've given up here... If anyone still has some ideas I'd love to hear them.

    What I still don't understand is why the "powers that be" decided that you can put a graphic in the background of a sheet but you'll never be able to print it out. Why bother putting that functionality in? <img src=/S/weep.gif border=0 alt=weep width=21 height=16>

    few minutes later
    FYI... We figured a work around was using WordArt and set the color as semitransparent with the lightest gray we could. Good enough! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Thanks a bunch anyway!!
    have fun

  12. #12
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Long Beach, California, USA
    Posts
    233
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to send photo to background

    This line was at the bottom of the Excel 2000 Help item on watermarks:

    Background patterns do not print and are not retained in individual worksheets or items that you save as Web pages. However, if you publish an entire workbook as a Web page, the background is retained.

  13. #13
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: how to send photo to background

    Hi KT,
    I don't know if this is still of any interest to you, but just for information, the background option would also have been disabled if she had more than one sheet selected at the time.
    FWIW.
    PS Yup it's really annoying that you can't print backgrounds!
    Regards,
    Rory

    Microsoft MVP - Excel

  14. #14
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Chicago, Illinois, USA
    Posts
    187
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: how to send photo to background

    The solution is really convoluted. To send the photo behind the text in not possible, however, you can send the text in front of the photo.

    If you do not have the camera tool on your toolbar, do this first (right click on toolbar, select customize, the commands tools camera, drag to toolbar).

    Next select the cells you wish to print with the picture (NOTE: the picture isn't inserted at this point) and click on the camera tool. The cursor will change to a thin lined plus. Select a blank sheet and click anywhere. You will then get a graphic image of the cells selected that is linked to the original (NOTE: this image a dynamic link to the original - changes on the 1st sheet will be reflected live on the 2nd sheet).

    Select this image of your cells, right click, select format picture, colors and lines fill no fill & line no line.

    Insert your picture.

    Drag your cell image over the picture.

    Send picture to back.


    This isn't a great solution but it works.

Posting Permissions

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