Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Draft over page (Excel 2000)

    I would like to print a document and on the page show the word "draft" over whole page. The information on the worksheet should be in the front with the "Draft" a shade lighter at the back.

    Thanks

    Mario

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

    Re: Draft over page (Excel 2000)

    1. Use a graphic program to create a page-size document with the word Draft in a large font size; make the text light gray or yellow (yellow often prints as a pleasant shade of gray on a black-and-white printer).
    2. In Excel, select Format/Sheet/Background...
    3. Browse to the graphics file you created, and click Open.
    4. The graphic will be used as background to your worksheet, tiled.

  3. #3
    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: Draft over page (Excel 2000)

    Hans,
    AFAIK, that only applies when viewing the workbook. It will not print out, unfortunately.
    Regards,
    Rory

    Microsoft MVP - Excel

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

    Re: Draft over page (Excel 2000)

    <img src=/S/doh.gif border=0 alt=doh width=15 height=15> You're right - I didn't test whether the background was printed. <img src=/S/sorry.gif border=0 alt=sorry width=15 height=15>

    I should have looked at XL: Cannot Print Background Graphic Included on Worksheet, where MS states that "Background graphics cannot be printed in Microsoft Excel."

    Low-tech solution: create a document with "Draft" in Word or a graphics program, print it, make copies and then print the workbook on those copies. Not very elegant...

  5. #5
    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: Draft over page (Excel 2000)

    Kind of makes you wonder why they bothered putting it in there at all!
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Draft over page (Excel 2000)

    Check and see if your printer supports this in it's settings. Many laser printers do nowadays.

    See also This thread.

    Andrew C

  7. #7
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Draft over page (Excel 2000)

    Thanks for all the input

  8. #8
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Ross-on-Wye, Herefordshire, United Kingdom
    Posts
    212
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Draft over page (Excel 2000)

    Not an Excel solution directly... www.fineprint.com

    Have a look at FinePrint. Does all kinds of snazzy things with printed output. Application and printer independant. It is a most excellent utility!

    Regards
    Peter

  9. #9
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Draft over page (Excel 2000)

    Hi Mario,

    Note exactly what you're after, but it might be sufficient:
    . Use WordArt to create a 'DRAFT' logo, then format it as semi-transparent, with whatever colours/borders you want.

    I know it's virtually the opposite of what you asked for, but maybe that's sufficient for your purposes ...

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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