Archive of Mr Excel Message Board


Back to Printing in Excel archive index
Back to archive home



How to put a printable "DRAFT" watermark

Posted by Altug Bayram on November 01, 2001 6:24 AM
How do I put a "DRAFT" word at the background as a watermark that I can print ?
Thanks

Re: How to put a printable

Posted by Joe Garza on November 01, 2001 6:45 AM

I use the following:
Click on Insert, then Picture, then WordArt. It will creat a box on the spreadshee. You can type what ever you want and position it where you want then change the color to a gray.

Re: How to put a printable

Posted by Jonathan on November 01, 2001 7:01 AM
Right. Or change the color to "No Fill" and you get an nice outlined "DRAFT".

HTH


Re: How to put a printable

Posted by OK but how to repeat it for each page ? on November 01, 2001 7:33 AM
HTH

I use the following: Click on Insert, then Picture, then WordArt. It will creat a box on the spreadshee. You can type what ever you want and position it where you want then change the color to a gray.

OK guys,thank for the info, however to make sure that
this repeats for each page ? when you go by your
method, it only prints "DRAFT" once in mid-page (for
multiple pages). Any ideas ? Thanks so much


Re: How to put a printable

Posted by Joe Garza on November 01, 2001 9:57 AM
You got me there...

The only thing I can think of is to preprint the sheets with the word art the run them through the printer again to print the spreadsheet.

he he he


Re: How to put a printable

Posted by Altug Bayram on November 01, 2001 1:34 PM
The only thing I can think of is to preprint the sheets with the word art the run them through the printer again to print the spreadsheet. he he he

Yap that would surely work, isn't that amazing
excel doesn't have a very easy answer for this.
Thanks for your help.




This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.