Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 48
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,646
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 709
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 48
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,646
Default 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



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
unhide menu bar in excel - just disappeared Sean Setting up and Configuration of Excel 12 April 4th 23 10:19 AM
Show colour on screen in Excel as printed in Excel Jim POLL Setting up and Configuration of Excel 4 August 24th 05 02:16 AM
How do I remove the auto border from my printed pages in Excel GE Excel Discussion (Misc queries) 1 August 12th 05 01:37 AM
How do I remove pages in Excel? Carrmela Excel Discussion (Misc queries) 1 December 9th 04 08:13 PM
trying to remove a watermark on the excel sheet Susan Excel Worksheet Functions 2 November 18th 04 09:52 PM


All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"