Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Posts
    309
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Picture as Watermark (Excel 2002)

    I inserted a picture in my excel spreadsheet. I want the grid lines to show on top of the picture. It seem the picture is on top of grid lines.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Picture as Watermark (Excel 2002)

    You can create an on-screen watermark by selecting Format | Sheet | Background... This will be displayed behind the cells and gridlines, but it won't be printed. Excel doesn't have a printable watermark the way Word has.

    Some printers have the capability of downloading and printing a watermark. You can also print pages with a watermark from (for instance) Word, and print the spreadsheet on top of that.

    If you insert a picture by Insert | Picture | Illustration or ... | From File, it floats above the cells and gridlines. It can't act as watermark.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Picture as Watermark (Excel 2002)

    SInce you add graphics ON TOP of the of the worksheet, the grids (and the cell contents) will not show thru. You can change the FILL color (format picture, fill) to NO FILL or to transpaent, but that is only for SOME parts of SOME pictures.

    You can add the picture as a background (format - sheet - background) and the picture will be behind the grids.
    Note ONLY 1 background and it will NOT print.

    If the picture is only for printing, Another option is to put the picture in another location, and then add a "picture" of the cells you want over the picture so they show up. You can do this easily with the camera tool and it is "linked" so changes to the original are reflected in this "picture". You edit the origianl data and you would print the pictures if desired.

    Steve

  4. #4
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Picture as Watermark (Excel 2002)

    Yes, or even format a blank sheet with some empty cells done in a tasteful grey outline, and do a 'copy as picture' of that and paste on top of the image you're using as the fake 'watermark'.

Posting Permissions

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