MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

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

Re: How to put a printable


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.

Posted by Jonathan on November 01, 2001 7:01 AM

Re: How to put a printable

Right. Or change the color to "No Fill" and you get an nice outlined "DRAFT".

HTH

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

Re: How to put a printable

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

Posted by Joe Garza on November 01, 2001 9:57 AM

Re: How to put a printable

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

Posted by Altug Bayram on November 01, 2001 1:34 PM

Re: How to put a printable

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.