ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Watermark on all printed pages in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/120350-watermark-all-printed-pages-excel.html)

Kathrine

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

Stefi

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


Paul B

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




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


Stefi

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


Gord Dibben

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