Watermark on all printed pages in Excel
Is it possible to make a "watermark" on each page / behind the text when
printing out from Excel. The need is to have the text DRAFT on each page when printing - without interfering on the actual text - it should just be in the backgroun. Header and footer only gives text in the bottom or top - I want it all the way in the back. A picture inserted in header / footer seems to take all the space. Kathrine |
Watermark on all printed pages in Excel
It can be done easily in Excel2003:
Formats/Sheets/Background (the 4th option, just under the separator line in the box; the actual word can differ, I translate it back from Hungarian) Regards, Stefi €˛Kathrine€¯ ezt Ć*rta: Is it possible to make a "watermark" on each page / behind the text when printing out from Excel. The need is to have the text DRAFT on each page when printing - without interfering on the actual text - it should just be in the backgroun. Header and footer only gives text in the bottom or top - I want it all the way in the back. A picture inserted in header / footer seems to take all the space. Kathrine |
Watermark on all printed pages in Excel
Kathrine, you may also what to have a look here
http://www.xldynamic.com/source/xld.xlFAQ0005.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Kathrine" wrote in message ... Is it possible to make a "watermark" on each page / behind the text when printing out from Excel. The need is to have the text DRAFT on each page when printing - without interfering on the actual text - it should just be in the backgroun. Header and footer only gives text in the bottom or top - I want it all the way in the back. A picture inserted in header / footer seems to take all the space. Kathrine |
Watermark on all printed pages in Excel
I have tried this and it looks great on the screen; but does not come out on
the printer :-( Kathrine "Stefi" wrote: It can be done easily in Excel2003: Formats/Sheets/Background (the 4th option, just under the separator line in the box; the actual word can differ, I translate it back from Hungarian) Regards, Stefi €˛Kathrine€¯ ezt Ć*rta: Is it possible to make a "watermark" on each page / behind the text when printing out from Excel. The need is to have the text DRAFT on each page when printing - without interfering on the actual text - it should just be in the backgroun. Header and footer only gives text in the bottom or top - I want it all the way in the back. A picture inserted in header / footer seems to take all the space. Kathrine |
Watermark on all printed pages in Excel
Try File/Page settings/Sheet/Options/Effects/Water marks/Edit
Regards, Stefi €˛Kathrine€¯ ezt Ć*rta: I have tried this and it looks great on the screen; but does not come out on the printer :-( Kathrine "Stefi" wrote: It can be done easily in Excel2003: Formats/Sheets/Background (the 4th option, just under the separator line in the box; the actual word can differ, I translate it back from Hungarian) Regards, Stefi €˛Kathrine€¯ ezt Ć*rta: Is it possible to make a "watermark" on each page / behind the text when printing out from Excel. The need is to have the text DRAFT on each page when printing - without interfering on the actual text - it should just be in the backgroun. Header and footer only gives text in the bottom or top - I want it all the way in the back. A picture inserted in header / footer seems to take all the space. Kathrine |
Watermark on all printed pages in Excel
Kathrine
You can use InsertPictureWordArt. Make it a semi-transparent color with a light colored line. Gord Dibben MS Excel MVP On Tue, 28 Nov 2006 04:31:01 -0800, Kathrine wrote: I have tried this and it looks great on the screen; but does not come out on the printer :-( Kathrine "Stefi" wrote: It can be done easily in Excel2003: Formats/Sheets/Background (the 4th option, just under the separator line in the box; the actual word can differ, I translate it back from Hungarian) Regards, Stefi „Kathrine” ezt ķrta: Is it possible to make a "watermark" on each page / behind the text when printing out from Excel. The need is to have the text DRAFT on each page when printing - without interfering on the actual text - it should just be in the backgroun. Header and footer only gives text in the bottom or top - I want it all the way in the back. A picture inserted in header / footer seems to take all the space. Kathrine |
All times are GMT +1. The time now is 08:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com